An industry-standard, end-to-end Data Analytics project analyzing customer shopping trends. Features data cleaning in Python, deep-dive behavioral querying via SQL, and an interactive Power BI executive dashboard. Translates raw retail data into strategic, actionable business intelligence.
📌 Project Overview The goal of this project is to simulate a corporate-grade end-to-end data analytics workflow, demonstrating the ability to translate raw data into strategic business intelligence by:
✅ Data Preparation,Modeling & Exploratory Data Analysis (Python): Clean and transform the raw dataset for analysis.
✅ Data Analysis (SQL): Simulate business transactions, and run queries to extract insights on customer segments, loyalty, and purchase drivers.
✅ Visualization & Insights (Power BI): Build an interactive dashboard that highlights key patterns and trends, enabling stakeholders to make data-driven decisions.
✅ Report and Presentation: Write a clear project report summarizing your key findings and business recommendations. Prepare a presentation that visually communicates insights and actionable recommendations to stakeholders.
The Dataset used in this project is avaiable on kaggle and is accessible by the following link : https://www.kaggle.com/datasets/ayeshasiddiqa123/customer-shopping-behavior-dataset
🛠️ How to Use This Project Clone the repository
git clone https://github.com/SHASHANKBHATT03/Customer_Trends_Analysis-using-SQL-Python-and-PowerBI.git
cd customer-trends-data-analysis-SQL-Python-PowerBI
Open Customer_Shopping_Behavior_Analysis.ipynb notebook
This file contains:
Data Import
Data exploration
Data cleaning
Connection to SQL Database
Load the data from Python notebook into MySQL
Create a database in SQL
Run Python code to load data into SQL database
Open customer_behavior_sql_queries.sql
Answer Business Questions using SQL Queries
Connect the SQL Database to Power BI
Open customer_behavior_dashboard.pbix
Create interactive dashboard in Power BI
Create Project Report and Presentation
Create project report
Build presentation deck using Gamma AI