Did Chicago Mafia Hits Increase in Summer Months? Data Cleansing Tutorial - Excel Pivot Tables
Вставка
- Опубліковано 10 вер 2024
- Want more practice on real BI/Data Analyst Projects?
www.flowthruan...
Link to data: reallifeexcel....
Skip to 14:00 for answer.
I found this Chicago 1970s mafia dataset in a reddit post. I use it as an example of how to cleanse data before analysis in Excel Pivot Tables. From there I chart some trends.
1) Who was the most prolific hit man?
2) Which years were most deadly?
3) Which months in any given year were most deadly?