Embarking on the Dashboard Challenge Week Day 2, my focus was on dissecting the variance in reported crimes across Australia, specifically delving into crime types and gender disparities. Leveraging data from the Australian Bureau of Statistics, I aimed to unravel the changing landscape of crime over time, identify the best and worst years for different offenses, and explore the evolving ratios of female to male crimes.

Data Preparation with Alteryx:

The initial step involved wrestling with raw data downloaded in Excel files. Alteryx came to the rescue, with its powerful tools like Transpose and Data Cleansing, making the data cleaning and reshaping process seamless. I downloaded separate datasets for male and female crimes, cleaned them up, and then unioned them in Alteryx for a consolidated dataset ready for analysis.

Power BI Exploration:

Transitioning into Power BI, I used DAX to create custom measures, bringing my visualizations to life. Calculating the ratio of crimes by gender (female to male) and determining the percent difference in crime numbers from 2008 to 2022 were just a few of the measures designed to uncover insights.

Report Design with Figma:

To present my findings creatively, I turned to Figma, a versatile graphic design tool. Crafting a red-themed report with crime-related visuals, I utilized Figma’s creative freedom to build engaging backgrounds and containers. The choice of a title font further emphasized the theme, enhancing the overall visual appeal of the report.


The report provides data-driven insights in crime across the years. One of the standout findings was the fluctuating ratios of female to male crimes, providing a unique perspective on gender dynamics within criminal activities. For those intrigued, the link to the report on Novy Pro awaits exploration. Uncover the trends, explore the ratios, and delve into the evolving landscape of crime in Australia. Click to discover for yourself.

Felix Ralphs
Author: Felix Ralphs