Crime Analysis with PowerBI
I retrieved data from Kaggle regarding crime rates in CO. I am an absolute crime nerd so this was a fun data set to play with. PowerBI is a very powerful visualization tool. I decided to analyze this data based on victim count. With the help of DAX, I was able to create a new measure. I had the data for victim count. However, I wanted to know the maximum victim count per crime, per year. Therefore, I created the measure "Max_victim."
Once I had this new measure created it was fairly easy to determine that the maximum victims in a crime were 19. This crime occured in 2022. I then took this a step further and determined the top 10 dangerous neighborhoods in CO by crime. (using victim count) . See the above visuals.