Data Analytics Portfolio

Welcome to my Data Analytics Portfolio repository.

This repository contains projects completed during my Data Analytics training, demonstrating skills in Excel, SQL, Python, Statistics, Power BI, and Tableau.

---

About Me

I am Gagan Bawankule, an aspiring Data Analyst with hands-on experience in:

• Excel
• SQL
• Python
• Statistics
• Power BI
• Tableau
• Data Cleaning
• Exploratory Data Analysis (EDA)
• Data Visualization
• Business Intelligence

My goal is to transform raw data into meaningful insights that support data-driven decision making.

---

Projects

1. Excel Sales Dashboard

Overview

Built an interactive sales dashboard in Microsoft Excel using Pivot Tables, Pivot Charts, and Slicers to analyze sales performance and business trends.

Skills

• Data Cleaning
• Pivot Tables
• Pivot Charts
• Dashboard Design
• Business Reporting

📁 Folder: Excel-Amazon-Sales-Dashboard

---

2. Python Customer Data Analysis

Overview

Performed customer transaction analysis using Python libraries such as Pandas, NumPy, Matplotlib, and Seaborn.

Skills

• Data Cleaning
• Exploratory Data Analysis
• Customer Segmentation
• Data Visualization
• Python Programming

📁 Folder: Python-Customer-Data-Analysis

---

3. SQL Sales Analysis

Overview

Analyzed retail sales data using SQL queries involving joins, aggregations, filtering, and business reporting.

Skills

• SQL Queries
• Joins
• Group By
• Aggregations
• Business Analysis

📁 Folder: SQL-Sales-Analysis

---

4. Statistics Customer Insights

Overview

Applied statistical concepts to customer data analysis, including descriptive statistics and business insights generation.

Skills

• Statistical Analysis
• Data Interpretation
• Business Insights
• Reporting

📁 Folder: Statistics-Customer-Insights

---

5. Power BI Sales Dashboard

Overview

Created interactive Power BI dashboards to visualize key performance indicators and uncover business trends.

Skills

• Power BI
• DAX
• Power Query
• Data Modeling
• Dashboard Design

📁 Folder: PowerBI-Sales-Dashboard

---

6. Tableau Real Estate Insights Dashboard

Overview

Developed an interactive Tableau dashboard to analyze real estate sales trends, property types, regional performance, and market insights.

Skills

• Tableau
• Dashboard Design
• Interactive Filters
• Geographic Analysis
• Data Storytelling

📁 Folder: Tableau-Real-Estate-Insights

---

Tools & Technologies

• Microsoft Excel
• SQL
• Python
• Pandas
• NumPy
• Matplotlib
• Seaborn
• Statistics
• Power BI
• Tableau
• Git
• GitHub

---

Contact

Gagan Bawankule

Aspiring Data Analyst

GitHub: https://github.com/gaganbawankule

LinkedIn: https://www.linkedin.com/in/gagan-bawankule

Instagram: @gagan.bawankule

---

Thank you for visiting my portfolio.