This repository contains an end-to-end data analysis project using the AdventureWorks dataset. It includes data cleaning, exploratory data analysis, and interactive Power BI dashboards to provide business insights. The project utilizes SQL, Python, and Power BI to analyze over 121,000 transaction records across five relational tables.
From the README
--- 📌 Overview End-to-end sales data analysis on the AdventureWorks dataset — covering data cleaning, exploratory data analysis and interactive Power BI dashboards to support business decision-making. --- 🎯 Problem Statement The business needed clarity on which products, regions and customer segments were driving revenue and profit — across 121,000+ transaction records spread over 5 relational tables. --- 🛠️ Tech Stack --- 📁 Repository Structure --- 🔍 What I Did • ✅ Cleaned and merged 5 relational tables using Pandas & NumPy • ✅ Performed full EDA — nulls, outliers, distributions, correlations • ✅ Wrote SQL queries for aggregation, joins and KPI extraction • ✅ Built 2 Power BI...
Skills
- Jupyter Notebook
