Data Cleaning In SQL
In this project, I clean the housing sales data set in SQL server. The tasks performed are Standardizing Date Format, updating the adress data using String functions and removing the duplicates.
Data Cleaning In SQL
Video Games sales data with Python and SQL
In this project, I worked with the Video Games Sales data set which contains sales data about some of the most popular Video Games (1980 - 2020). I clean the data set by using python_pandas. Likley, updating the data types, Filling the Nan values and establishing a connection with database. Also, Combained the Video games user data and sales data tables by Joins, Filtering and Manupliating the data, and find out the percentage of sales data of different regions by using Aggregate functions and Windows functions in SQL server.
Data Correlation in Python
In this project, I took Movie data set which have wide range of data such as budget, gross and iMDb ratings e.t.c. I clean and worked with this data set in python to find a correlation between selected columns by with help of 'pearson' method .
Covid-19_Data Exploration In SQL
I this Project , I choose Covid-19 data set which contains the infection rate, recovery and death rates across the globe. I worked with this data set for Data exploration such as Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types in SQL server.
Video Games sales data with Python and SQL
This is my PowerBI projects folder, where you can see the dashboards of E-commerce and Choclate_Sales.
Tableau Dashboards
This is my Tableau public profile, where we can find beautiful Dashboards for different data sets.