The exciting dashboard week finally starts!


What an exciting dataset to start with! Today, we are provided with Los Angeles crime dataset. The dataset includes crime cases recorded by the Los Angeles Police Department from 1 Jan 2020 to July 2023. It has lots of details on date and time, location information, crime type, victim demographics, the weapon used, crime case status, etc. Now, since we only have 1 day to complete the dashboard, I will go through my step-by-step approach to complete this challenge.

Step 1 (morning 9:30am – 10:30am)

I used Alteryx to investigate the data and googled a lot of terms to understand the data. Then I identified the fields that are worth analyzing and fields that are not suitable for analysis (e.g. too many missing values, too complicated to analyze, low value on finding insights). Then I identified the analysis to be done and for each analysis, determine the type of chart, and whether a parameter is needed to provide more controls. It is also important to determine if this is going to be an explanatory dashboard or an exploratory dashboard.

Remember to TIME BOX your time. Keep in mind that formatting always takes longer than you expected.

Step 2 (morning 10:30am – 12:30pm)

I converted the file in Alteryx to “.hyper” and started creating charts in Tableau. At this point, colors and formatting do not matter. I created lots of charts that could support the analysis I have in mind. After having some ideas of what to put on the dashboard, I started drawing the dashboard design so that I can have a better idea of the locations and sizes for each of my charts. By lunchtime, I had my dashboard design planned and almost all the charts I need to put into the dashboard.

Take some time for lunch and relax.

Step 3 (afternoon 1:00pm – 5:00pm)

Since I decided that this dashboard will be exploratory in nature, I can start looking for insights after I dragged everything into my dashboard. I spent the whole afternoon looking for insights while doing formatting. By the time the clock ticks 5 pm, my dashboard is ready to go. Then, of course, some extra time needs to be spent to refine the insights and think about the presentation.

Overall, day 1 of the dashboard week is not only challenging but also fun to enjoy. Again, it is incredibly important to time-box the plan. Otherwise, it could be really stressful. I am looking forward to taking on more upcoming challenges!


The Data School
Author: The Data School