Dashboard Week - Day 2

After the first horrific day of dashboard week - I was mentally preparing for today.

The TASK:

We need to pick an industry - any industry we liked. Then build your own data set using Mockaroo and finally create a KPI dashboard using Power BI.

So first I decided to make an industry and my quick dataset idea:

My Plan:

I actually managed to finish my Mockaroo dataset before 12pm - actually at 11:15am, I then managed to do my Excalidraw by 11:30am but then I had unforeseen meetings after that so me writing this blog and figuring out how to do PowerBi - the timing went all over the place.

I knew I wanted 5 artists that each produced 5 songs - 25 in total

The issue I was having was what would my 1 row of data represents?

1 row of data can be 1 sale - this can include the gender and age of person who downloads
1 row of data will be 1 song and its info

Creating the dataset - Mockaroo

This is was one part of my mockaroo data as i was struggling to link the songs to the artist (i wanted 5 artists that sold 5 songs each)

To combat this issue - I created another dataset in mockaroo that only has the 25 songs linked to the artists and I created a song ID which I should be able to join once in PowerBi

Brainstorm:

This was the outline of my KPI dashboard I was going for

Power of PowerBi:

PowerBi only accept excel worksheets, so once I downloaded them from Mockaroo as a csv, I saved as an excel workbook.

I then had to do a relationship/join between my 2 tables in power Bi - this was actually very simple.

I just had to drag the Song ID field on top of each other and this would let me create the relationship I want.

In the time I was given, this was the KPI dashboard I was able to create.

Not my best work I must admit. But I did find the actions in PowerBi to be much easier as they are automatic compared to tableau.

I will be remaking this dashboard in tableau when I have time.

Author:

Maha Hussari

View Profile