Dashboard week day 3 was the most difficult challenge yet, not only was the data unfamiliar to the entire team, but it was also in Power BI, in which we have less practice as opposed to Tableau. Come with me as I take you through the steps I took to get my data from the Victorian Crime Statistics Agency to a Power BI report.

Step 1: Find the data

Our coaches gave us the link to the Victorian Crime Statistics Agency and we were required to create a Power BI report of our liking using the data. I decided to look at the number of different incidents across the years to see if there were any trends and whether the overall number of incidents was decreasing.

 

Step 2: Curate the data

Once I downloaded all of my data (6 Excel worksheets), it was time to merge all the data together into one coherent dataset. The merging of the data was pretty simple, it was just multiple joins based on year and LGA. I then removed all of the aggregate data rows by filtering out rows containing “total”. From there my data was ready for analysis, but I decided to also pivot the data in case I changed direction in my report and needed to build different charts. You can find a photo of my workflow below. 

 

Step 3: Create the charts

Creating charts is Power BI is often more intuitive than Tableau. Power BI allows you to drag in a template of a certain chart and add the data afterward, whereas in Tableau, you drag the data in first and then change it to the chart of your choice. Now comes the tricky part. I wanted to create a parameter that allowed users to change the axis of a scatterplot depending on which type of incident they wanted to look at. I’d never created a parameter in Power BI before and I have limited experience using DAX, so creating the parameter took up a lot of my time throughout the day. Eventually, through the help of my coaches, I got there and created 3 different parameters; 1 for each axis of a scatterplot and 1 for a bar chart, so you could see total incidents for the different categories.

 

Step 4: Create a Power BI report

Finally it was time to create my report. I dragged in my charts, formatted my text, added in some KPI’s and made it look aesthetically pleasing. Overall, I was pleased with how my report turned out, as this was the first time I had used Power BI in weeks. You can view my report by clicking the link below:

https://app.powerbi.com/links/D3QSz_a7vg?ctid=eff41017-c1ff-4c20-aba2-c11b3930bb12&pbi_source=linkShare

 

The Data School
Author: The Data School