₦airaland Forum

I am not done yet, just getting started.....

Lets look at the golden ball winners.....

a) The first pics shows the number of players that have won the golden ball more than once. And as you can see only one player has done that.. the GOAT himself Lionel Messi.
Note: the "not awarded" which appeared 11 times means that no golden ball was awarded in the first 11 world cup tournament (1930 - 1978).

b) The second pics shows the full list of players that have won the golden ball since the award began. (1982 - 2022)

Now let the analysis begin

I can't say for other data analyst but I love to analyze my data from field to field i.e. analyzing each column from the beginning to the end.

So, Here we go...…

a) The first pics shows the country that have hosted the world cup more than once.
b) The second pics shows the countries from pics (a) and the years they hosted the world cup.

Working on the tables separately can be stressful and time consuming, so I joined the first three table (since those are the tables I will be working with) using the INNER JOIN function. I also created a virtual table using "view" to help simplify the my analysis.
Please note: the table is way wider than this. You can't see it but all three tables were successfully joined. Trust me
This is what I got from joining all three tables.

The FIFA World Cup is an international soccer tournament held every four years. It features teams from around the world, who compete for the title of world champion. The World Cup has a rich history, dating back to the inaugural tournament in 1930. Over the years, the tournament has seen many memorable moments and legendary players.

So today I will be conducting an analysis of the FIFA World Cup from 1930 to 2022.

This Dataset was gotten from Kaggle.

This dataset came in four different files i.e. four different tables and as you can see from the pictures below it shows the four tables....
*fifa_world_cup_attendance
*fifa_world_cup_award
*fifa_world_cup_finals
*top_four_world_cup_teams

Now lets look at the dataset from each table:
a) The first pics shows the dataset for the fifa_world_cup_attendance
b) The second pics shows the dataset for the fifa_world_cup_award
c) The third pics shows the dataset for the fifa_world_cup_finals
d) The fourth pics shows the dataset for the top_four_world_cup_teams

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

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.

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.

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.

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.

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

Rahyberg:
I resumed

.

Rahyberg:
Sir, I have downloaded the video but couldn't get it using the MySQL workbench. He uses the cloud9 IDE...

I'm having issue with MySQL workbench anytime I want to open folders of SQL files I download from the internet.




I'll be glad if you can mentor me on this.

It's still the same thing. Every query used by the guy on cloud9 IDE woks on MySQL as well. You just have to follow the queries step by step. If you still don't get it, you can learn using MySQL command Line client. It has the same similar background features with the guys own. But I'd prefer you learn with MYSQL.

What Kind of Errors does it show?
Having you tried increasing the Open files limit.

GREATIGBOMAN:
Seems you're also high from the marijuana from posting same pics over n over again

look closely. They're all different. I can't give full analysis with just one picture nah.

BRATISLAVA:
This is much, much better and quite interesting.

Thank you.

Ladies and Gentlemen that is all I have for you and my client today.

More and more insights can be gotten from this dashboard. I can't share everything you not because I don't want to but I think the ones I have shared are the most important aspects that you can get from this dashboard, the ones that will really help my client in making a better decision on the state she wants to relocate to.

And like always I look forward to sharing more sample project with you all.

Thank you for your time

Peace.

Still The Filtering Level

1) Looking at the decriminalized and Medical filters, the first picture shows the decriminalized status as FALSE and Medical status as TRUE. What this means is that the states seen on the dashboard has approved the use of marijuana for medical use purposes only i.e... it is medicinal. But not for recreational use. It is a criminal offence, If caught, you will be penalized.

2) Also looking at the decriminalized and Medical filters, the second picture shows the decriminalized status as TRUE and Medical status as FALSE i.e.... it is not an offence to have marijuana and it is also not medicinal. In other words you can use marijuana for recreational use. No Doctor is gonna prescribe marijuana as form of medicine. Not in this states. Enjoy your marijuana No one is gonna arrest you.

More Filtering

1) The first pics shows the number of states which decriminalized status shows FALSE i.e.. states that have sanctioned the possession of weed as a criminal offence. And as you can see from the dashboard there 14 medical states and 5 fully illegal states that have criminalize the possession of marijuana. Marijuana is not allowed either for recreation or medical use.

2) The second pics shows the number of states which decriminalized status shows TRUE i.e... states that have not sanctioned the possession of marijuana as a criminal offence. It is not an offence. You can use weed for both recreational and medical use.
And surprisingly, looking at the map you can see a red bubble. That means in south Dakota marijuana is illegal but not an offence don't look at me that's what the data says LOL.

Now let's filter and get some insights from this dashboard.

I) The first pics shows the number of states in America that have not legalized the use of marijuana either for medical use or recreational use. And as you can see on the map the red bubble shows states on the map. So these are the states my client who has confidential told the she uses marijuana for medical use only should avoid. And I forgot to mention that opposite the map is a table that shows the per capital income, median rent and median age of the illegalize state.

2) The second pics shows the number of states in America that have fully legalized the use of marijuana. So these are the states my clients bear in my mind when choosing a state to relocate to. And opposite the map is the table that shows the per capital income, median rent and age of the legalized states.

3) The third pics shows the number of states in America that have approved the use of marijuana for medical use only. These means you can't use marijuana for recreational use. It's not allowed. And like the first two pics the table opposite shows the per capital income, median rent and age of the states that approved the use of weed for medical use only.

Few days ago I shared my analysis on the legalization and illegalization of marijuana in some of the states in America using MySQL. If you haven't seen it please check out my previous thread or topic. A lot of insights was gotten from the analysis and I was able to answer my client questions on the legalization and illegalization of marijuana in some of the states in America. And with my findings he was able to pick and relocate successfully to one of the legalized states

But sharing my MySQL analysis with another client who was looking to relocate but also had issues with the illegalization of marijuana in America, there was a slight problem.

Being the non-technical clients that she was, she couldn't quite grab my MySQL analysis, so I decided on creating a simple, straight forward dashboard using Power BI.

So I will be analyzing the weed dataset using PowerBI like I did with MySQL

SO HERE WE GO...…

The picture below shows the full dashboard with no filters. And as you can see from the map, the colored bubbles shows the:
*fully legal (dark blue bubble),
*fully illegal (red bubble)
*medical (dark yellow bubble)… states in America.

You can also look at the KPI above for better display.

Also three (3) filters were created to help you get any particular answer or insights you want from the dashboard.

BRATISLAVA:
Absolutely didn't expect this. Expected another stoner fantasy. It's been nice watching your portfolio grow over the year (s).

Can you leave the SQL behind and let's see your visuals? Would be more stimulating.

Nice.

For the weed analysis, visuals. Didn't know there's more.

Thanks Man I appreciate. And for the visuals; definitely. I'll be working on it. Using Power BI, more findings can be gotten from this weed dataset. Thanks once again.

Apart from just relocating to a state in America, you might just find you self visiting friends and family or going for a business trip in state where marijuana is fully illegal and also a criminal offense. To avoid breaking the law here the number of states and also the name of the states where possession of marijuana is a criminal offense.

Lets Check It Out;

a) The first pics shows the states that have criminalized and decriminalized the use of marijuana. True means It is not a criminal offense in 32 states and False means it is a criminal offense in 19 states.

b) The second pics show the 19 states that have criminalized the use of weed. Just incase you find yourself in one of theses states try as much as possible not to break the law. Whether for medical use (unless approved by a doctor) or recreational use do not be caught with marijuana.


I hope my client is happy with my findings

Thank You For Your Time

More Data Analysis Coming Your Way

Peace.

legalization of marijuana in the state you are looking to relocate to shouldn't be your only reason for wanting to relocate. Checking out the Per Capital Income and the average rent paid per month should also help in you decision making. You are not just moving to smoke weed or use it for medicine. You also want to work and earn so that you can afford to buy as many ounce of weed you can afford

Lets Check It Out;

a) The first pics shows the fully legal states and its per capital income. Ranging from the state with the highest per capital income to the state with the lowest. It also shows the average rent paid per month in those states. As you can see below District Of Columbia has the highest per capital income but is that the state you would love to move to. Take your time and choose the fully legal state and its income that is best for you.

b) The second and third pics shows the per capital income and average rent of states where marijuana is fully illegal or used for medical purpose. Lets say for instance you've always wanted to move to New York but the legality status is medical i.e. you can't smoke but only use only for medical purpose. The per capital income and rent can help you decide if you want to move to New York or find some where else.

Lets Check Out The States;

a) The first pics shows the six(6) state that have not legalized the used of marijuana. And not only is it illegal, it is also a criminal offense. The decriminalized field shows all state as false i.e. it is a criminal offense except for South Dakota.

b) The second pics shows all 16 states that have legalized the use of marijuana. These are the states you should bear in mind when you are ready to relocate. And as you can see all 16 states show true i.e. it is not a criminal offense.

c) The third pics shows states that have approved the use of marijuana for medical use only. That means you can use marijuana as a form of medicine only and not for recreational use. If caught smoking you can be penalized as you can see below all values in the decriminalized field shows false i.e. it is a criminal offense.

d) The fourth pics shows states that have legalized the use of marijuana for both medical and recreational use. You don't need to worry anymore one of this states should work for you.

My Findings:

a) The first pics shows the legality status In America. Marijuana is fully illegal, fully legal or medical in some of the states in America.

b) The second pics shows the number of states in America and its legality status. And as you can see below there are six(6) that have not legalized the use of marijuana either for recreational use or medical use.

So you are looking to relocate to the United States of America but feel discourage coz you heard the state you're moving into have not legalized the use of marijuana . Which also means it is a criminal offence to have in your possession marijuana or weed like some may call it.

Feeling sad and confused about the next step to take, you hire a data analyst (me of course ) to help you analyze a dataset you saw online. A dataset that shows all the states in America and its legality status, per capital income, median rent etc...… and you believe with the insights and findings the analyst shares with you, you are able to make a decision on which state in America to relocate to.

And just to be clear you only use marijuana for medical use and not for recreational use


Hello! my name is Jamer the analyst. I have been able to analyze the dataset and this are my findings...…..

BUT before I go into sharing my findings, I would love to start from the beginning and show you the step by step process into my findings.


Here We Go:

As you can see in the picture below, this dataset has two tables. The REGULATIONS table and the WEED_CLEAN table

a) The first picture shows the values in the REGULATIONS table
b) The second picture shows the values in the WEED_CLEAN table
c) The third shows a virtual table (state_weed_data) I created to join both the REGULATIONS and the WEED_CLEAN table together. The blue line represent the regulations table and the red line represent the weed_clean table.

As a data analyst having a TECHNICAL MINDSET is one of the most important analytical skill you can have. The ability to break things down into smaller pieces and use that pieces in a logical and orderly manner is something that will help you in your career as a data analyst.

sharing our findings, insights and conclusion from the data we got to non technical people like our boss or shareholders is really important.

A lot of data analyst do not like this part We just want to clean, transform and analyze our data without having to share our findings in front of everyone. You can't escape it

Personally what I do is go online, search for sample dataset, work on it and pretend to share my findings gotten from the data. It could be presenting my findings in front of friends, or the mirror or video like the one I will be sharing. This helps build my confidence and I am also able to work on my weaknesses (lots of weaknesses )

I have done quite a few number of videos but today I will be sharing with you my first ever video.

Here is my analysis on a student adaptability levels to online education.

Please watch and tell me what you think. Thank you.



https://www.youtube.com/watch?v=Cn2AQXtdJ-M

nisot14:
Boss pls, which video, site or book are you learning sql from

There's a channel called "Full course" on YouTube . They have a 20 hrs mysql beginner to expert video. Check it out.

Hello Guys! Please, are there more advanced MySQL functions out there, coz I feel like I know them all.... From "ranks" to "views" to "stored procedures" to more "advanced sub-queries". I am no expert, I just wanna learn something new and different on MySQL. Searching for advanced MySQL videos on YouTube still leads me to the ones I listed above or functions on other server like postgre, Microsoft server etc.. (which I don't use). I have done and posted few sample Data Analysis projects here on nairaland. Plz Kindly view my profile and see if there are more things I need to know and Improve on. Thank you.

More filtering and analysis was done. I can't share them all

Finally I am done with this dataset No more.

I look forward to sharing more of my sample projects.

Thank you for you time.

#dataanalyst
#dataanalysis
#datavisualization
#data

Peace

F) And finally this pics shows the number of students with "Mobile devices" that uses the Internet with "Mobile data" using a "4G" network.

FILTERING THE DATA

D) The fourth pics shows the complete data of only the male students. This shows you the total number of male student online that are from the University or college. It also shows the devices, network and Internet used by male students online........ etc..

E) Just like the fourth pics, this pics shows the complete data of the female students online.

FILTERING THE DATA

B) Clicking on a particular data changes the whole data on the dashboard which in turn gives you the insights or information that you need. The second pics shows the number of online students from a Private University.

C) The third pics shows the number of online students from a public College.