good evening house, I'm here to seek the opinion, advice and criticism of every data analyst in here about my first data analytics project.
So earlier this year I decided to start the journey of learning data analytics, so far have learnt excel and sql(postgresql), still learning sql tho, looking forward to start learning R programming very soon, but before going further, thought of applying what have learnt so far by solving real life projects, so I got online and searched for data sets, then I come across one on kaggle( airplane crashes and fatalities from 1908-2009). Link to the datasets:
https://www.kaggle.com/datasets/saurograndi/airplane-crashes-since-1908

So I started working on it, after downloading and importing the data into my postgresql database, I cleaned the data( remove some unnecessary columns and added new columns like the 'number of survivors') which was initially not in the data.
Grouped the crashes by year, found the sum of crashes and deaths by year and by operator type..
After exploring the data using postgresql, I had to use excel to visualize the data since have not learnt a proper visualization tools yet..

Will be uploading the excel charts soon

1.total number of crashes between 1908-2009
And number of crashes per year

2. Crashes based on operators(military and non-military)

3.the deaths toll

This is all I could make of the dataset using just postgresql and excel from what have learnt so far.
Thought of adding this to my github repository but was intimidated when I went through the codes written by other data analyst and what they made out of the data.
So before going ahead to upload this to my github, thought of consulting the data analyst in here about what I could have done better with the data and if my result is good enough to upload online or add to one's CV.

Bar charts are for comparison, I feel you should have use pie chart instead to show your total number.
I haven't gone through the dataset though

Sageez:
Bar charts are for comparison, I feel you should have use pie chart instead to show your total number.
I haven't gone through the dataset though

Ohh!! Noted, thanks bro

Oga find beta topic..

LikeAking:
Oga find beta topic..

you mean another dataset to work on?

ConsciousMan01:
This is all I could make of the dataset using just postgresql and excel from what have learnt so far.
Thought of adding this to my github repository but was intimidated when I went through the codes written by other data analyst and what they made out of the data.
So before going ahead to upload this to my github, thought of consulting the data analyst in here about what I could have done better with the data and if my result is good enough to upload online or add to one's CV.

go ahead and upload it bro. Then update it as time goes on.

jesmond3945:
go ahead and upload it bro. Then update it as time goes on.

thanks bro