Exploratory Data Analysis Projects

This repository is dedicated to showcasing various data analysis projects, demonstrating not only the implementation of different analytical techniques but also the methodologies employed, data preprocessing steps, exploratory data analysis, and visualization.

Skillset & Tools

Tools Utilized

• Google CoLab
• Jupyter Notebook
• Microsoft Excel
• Microsoft Power BI
• Microsoft SQL Server

Skills Acquired in Analyzing Datasets

SQL

• MySQL
• Aggregate Functions (SUM, AVG, COUNT, etc.)
• Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN)
• Subqueries
• Group By and Having Clauses
• Window Functions
• Indexing and Performance Optimization

Python

• Data Preparation and Cleaning (Handling Missing Values, Data Transformation)
• Data Analysis (Descriptive Statistics, Hypothesis Testing)
• Data Visualizations (Charts, Histograms, Heatmaps)
• Libraries; NumPy, Pandas, Matplotlib, Seaborn, Folium, Plotly (Interactive Graphs)
• Time Series Analysis
• Correlation and Regression Analysis
• Advanced Visualization Techniques (Pair Plots, Facet Grids)