₦airaland Forum

Hello Fam!! So good to be here again

Today I will be sharing with you a simple data analysis/summarization using Excel pivot table.

Pivot table is one of the most powerful tool in Excel. It helps with the calculation and summarization of data (especially numerical data), which in turn helps you see patterns and trends in your data.

I got this dataset from kaggle. This dataset is all about the Gun violence in America. This dataset shows the states, cities, number of killings and injuries obtained from Gun violence in the past 8 years.


Here is what the dataset looks like.....…

You can't see the full table but this table has 448,402 rows and 7 columns

Now Lets Summarize This Data Using Excel Pivot Table

a) The first pics show the summarization of the table. The table has been grouped based on each state in America and each states shows the total number of incidents, killing and injuries.

b) The second pics show the cites under each states. There are more than there cities in Illinois and the other states but I filter the data to show me the three major cities in each state with the highest number gun violence incidents. As you can see, Chicago, Rockford and Decatur are the major cities under Illinois with the highest number of gun violence incidents.

More Summarization

a) Like I said earlier this dataset is all about gun violence incidents in the past 8 years i.e. 2014 - 2022 but I filtered the data to show me the information from 2020 - 2022 as you can see below. That means each state and cities and have filtered to show the information from 2020 - 2022 alone.

b) The second pics shows the quarter and the months from each year. You can get the total number of incidents, deaths and injuries from each quarter and also the total number of incidents, deaths and injuries from each month.

And Finally

The picture below show the total number of incidents, killings, and injuries from each day in the month of January. And as you can also see, it show the address from each incidents. For example January 1st 2020 shows a total of 9 incidents, 0 deaths and 6 injuries and it also shows the different address where each incidents occurred.

I'm not done yet

Please note that the pics below does not show the total number of incidents, deaths and injuries running from 2014 - 2022. The analysis and summarization and the pics I have shared so far are just total values running from 2020 - 2022.



More Sample Projects Coming Your Way

Thank You For Your Time.

For full summarization of this dataset Please check out the video I did.

This videos shows the step by step process and it is more detailed than the ones I shared here.

Check it out.

Thank You.



https://www.youtube.com/watch?v=GR73n4O09ec

Great work. How long have been learning data analytics and what sources did you deploy in learning Excel?