Last week we had the task to create fake data to use in our analysis. Our task was to pick a field ( Real Estate, Healthcare, Marketing etc.), and to create an executive and normal dashboard with our created data from Mockaroo.
What is Mockaroo?
Mockaroo is a website that allows the user to create fake datasets. Fake data or "Dummy data" can a lifesaver when you're trying to create a demo dashboard from scratch.
You can create formulas, aggregate and analyze the data created using a Ruby syntax. This programming language is quite different from python but is also easy to understand.
Here is an example:
For the task, I have decided to create 'fake' data for a Real Estate company. I started first by filtering the country in Mockaroo. In my case, I've filtered the country and postal code to be only in the United Kingdom.
I've filtered the "Price for Sale" to be a number between "100,000-10 Mil) and I put the Rent price between "£700-£10,000"
Because I wanted to have two types of listings: sold and rented I've added a the Rent? field with a Boolean filter so that the listings can have a "YES" or "NO" (Rented, Not Rented) option.
Here is the final look for my dataset:
Here is the final dashboard:
PS. I really had fun creating the data and analyzing the Real Estate company, and I think everyone should try to experience this "fake data" creation process. It can give you so much understanding of what is needed for a dashboard.