A Power BI-based retail analytics project designed to analyze sales performance, customers, products, locations, and shipping methods through an interactive business intelligence dashboard.
The project uses a Star Schema data model with a central sales fact table connected to multiple dimension tables.
The Retail Performance Intelligence Dashboard provides an interactive view of retail business performance.
The dashboard was developed using Microsoft Power BI, with data preparation, modeling, DAX calculations, and visualization used to transform raw retail data into meaningful business insights.
The project focuses on understanding sales trends, product performance, customer segments, geographical performance, and shipping methods.
- Analyze overall retail sales performance
- Understand product and category performance
- Analyze customer segments
- Identify geographical sales patterns
- Analyze different shipping methods
- Monitor important business KPIs
- Create an interactive and user-friendly dashboard
- Implement a structured Star Schema data model
- Convert raw retail data into meaningful business insights
- Microsoft Power BI
- Power Query
- DAX
- Microsoft Excel
- Data Modeling
- Star Schema
- Data Visualization
The project follows a Star Schema architecture.
The model consists of one central fact table and multiple dimension tables.
The central transaction table contains sales-related information including:
- Customer ID
- Order Date
- Order ID
- Postal Code
- Product ID
- Row ID
- Sales
- Ship Date
- Ship Mode
Contains product-related information:
- Product ID
- Product Name
- Category
- Sub-Category
Contains customer-related information:
- Customer ID
- Customer Name
- Segment
Contains geographical information:
- City
- Country
- Postal Code
- Region
- State
Contains shipping-related information:
- Ship Mode
The main dashboard provides a consolidated view of retail performance through KPIs, charts, and interactive analysis.
The dashboard provides analysis across multiple business dimensions:
- Overall Sales Performance
- Sales by Category
- Sales by Sub-Category
- Sales by Customer Segment
- Sales by Region
- Sales by State
- Product-level Performance
- Customer-level Analysis
- Shipping Mode Analysis
- Geographical Sales Distribution
The dashboard incorporates business-oriented KPIs to provide a quick overview of retail performance.
Key performance areas include:
- Total Sales
- Customer Performance
- Order Performance
- Product Performance
- Category Performance
- Regional Performance
- Shipping Performance
The dashboard can be used to identify:
- High-performing product categories and sub-categories
- Customer segments contributing to sales
- Geographical regions with stronger sales performance
- Products contributing significantly to overall sales
- Distribution of sales across shipping methods
- Differences in performance across locations
- Areas requiring further business attention
A Star Schema was implemented to create a structured and efficient analytical model.
The fact_sales table acts as the central fact table and is connected to the following dimension tables:
dim_products
|
|
|
dim_location ---- fact_sales ---- dim_customers
|
|
dim_ship