Data Cleaning using SQL
Link : https://github.com/Nishesh07/Data-Cleaning-SQL
- Using the Nashville housing data containing more than 50,000 rows of data
- Using various SQL data cleaning functions to clean data so that it is organized and ready for Analysis.
Data Exploration with SQL
Link : https://github.com/Nishesh07/Data-EXPLORATION-SQL
- Using Microsoft SQL to explore the two data sets on India's Census
- Using joins, group by and other complex queries to analyze data and finding out on the top and bottom states in each category of the dataset.
- Using aggregate functions like avg,count to gain more insights on the Data
Data Analytics Using Python
Link : https://github.com/Nishesh07/Data-Analytics-Python
- Using python on Jupyter Notebook to analyze the movies data consisting of the budget,revenue,etc
- Using Various Python Libraries like Numpy,pandas,Matplotlib and seaborn to perform Data cleaning and visualizing data.
- The end goal was to find correlation between the gross-profit and Budget of the films using the regplot,heatmap functions in Seaborn Library.
SQL and TABLEAU
Link : https://github.com/Nishesh07/SQL-and-TABLEAU
Link: https://public.tableau.com/app/profile/nishesh8719
- Using SQL to Analyze a product sales data using group by and other aggregate functions.
- Using Tableau Public to Visualize the data for easier understanding of each products data.
- Creating Dashboards to make it easier in viewing all the data.