Data Analyst skilled in SQL, Tableau, Power Bi, and Python. @RoshanBhatta_Github @RoshanBhatta_Tableau
In this Project we cleaned housing Data in SQL server. We combined data,
parsed the address data column into three parts to make it easier to read, updated columns, removed duplicates, and deleted unused columns.
In this project I took covid data sets from ourworldindata.com parsed it into Covid deaths and Vaccinated data. Retrieved data through SQL query and visualized using Tableau. I had the following insights from the data. Total cases till date(19th June 2023) with total deaths, 29 million deaths worldwide. Total Deaths per Continent: Europe is the highest and Oceania is the least. This may question the most advanced healthcare system in the world i.e. in the most developed countries like Europe. Percent Population Affected: Australia leading the race and with India being the least affected shows how effectively India handled the covid outbreak than the western world countries like the US, Canada, and even Australia.
This dataset was taken from https://comtradeplus.un.org/ website under the heading of Electric vehicle exports of China to the world. We can see from the charts that China has sold over 20 billion dollars worth of Elelctric vehicle in 2022 whereas, in 2017 China had $0.11Billion dollars worth of sale. Additionally, China is one of the leading EV exporter in European nations as well where, Belgium comes out on top on imports from China.
Using the data of Premier league season 21/22, used data to explore the country that supplies the most valuable players in the Premier league. Secondly, Club value in descending order which further disected into position values of players whether the player is an attacker, midfield or defense. Finally, the average measurements of players were done where players height and weight were taken, which showed that the biggest interms of height and weight were the defenders, then the attackers, and finally the midfielders in that order.