A data analytics project focused on understanding customer shopping patterns using Python, SQL, and Power BI. This project transforms raw transactional data into actionable insights that can support business growth and strategic decision-making.
In today’s competitive market, understanding customer behavior is critical for improving customer retention, optimizing product offerings, and increasing revenue.
This project analyzes customer shopping data to identify purchasing trends, customer segments, and high-value behaviors. The workflow integrates data cleaning, exploratory analysis, structured querying, and interactive visualization to deliver a complete end-to-end analytics solution.
- Python (Pandas, NumPy) – Data cleaning and analysis
- SQL – Data querying and insight extraction
- Power BI – Interactive dashboard and visualization
- Jupyter Notebook – Analysis workflow documentation
- Git & GitHub – Version control and project management
The project follows a structured data analysis pipeline:
-
Data Preparation
- Handling missing values and inconsistencies
- Formatting and transforming variables
-
Exploratory Data Analysis (EDA)
- Identifying trends and distributions
- Understanding customer purchase behavior
-
SQL-Based Analysis
- Aggregations and filtering for business insights
- Query-driven exploration of customer activity
-
Data Visualization
- Building an interactive Power BI dashboard
- Translating data into intuitive visual insights
-
Revenue Concentration: A small segment of customers contributes disproportionately to total revenue, indicating opportunities for targeted marketing and retention strategies.
-
Category Performance: Certain product categories consistently outperform others, suggesting areas for inventory prioritization and promotional focus.
-
Customer Segmentation: Distinct groups of customers exhibit different purchasing behaviors, enabling personalized marketing approaches.
-
Purchase Patterns: Variations in purchase frequency highlight differences between occasional and loyal customers, providing insight into customer lifecycle stages.
-
Trend Identification: Observable patterns in sales data can support forecasting and seasonal planning.
The Power BI dashboard provides an interactive interface to explore:
- Sales distribution across product categories
- Customer segmentation and contribution
- Purchase trends over time
- Key performance indicators (KPIs)
To view the dashboard, open the .pbix file in Power BI Desktop.
- Open the Jupyter Notebook to review the full analysis workflow
- Execute SQL queries in your preferred database system
- Launch the Power BI dashboard to interact with visual insights
This project demonstrates how data analytics can:
- Improve customer targeting and personalization
- Identify high-value customers
- Support strategic decision-making
- Enhance overall business performance through data-driven insights
For collaboration, feedback, or opportunities, feel free to connect via GitHub.