The Global Superstore Sales & Profit Analysis project focuses on analyzing sales, profit, customers, orders, products, categories, and regional performance using Excel, SQL, and Power BI.
The main objective of this project is to transform raw sales data into meaningful business insights and create an interactive Power BI dashboard for better decision-making.
- Analyze overall sales and profit performance
- Identify yearly sales and profit trends
- Find top-performing products
- Compare sales across different regions
- Analyze sales by category and sub-category
- Identify profitable products and sub-categories
- Analyze customer and order performance
- Calculate key KPIs such as total sales, total profit, and profit margin
- Build an interactive Power BI dashboard
- Excel – Data preparation, cleaning, and initial analysis
- SQL – Data querying, filtering, aggregation, and business analysis
- Power BI – Data visualization, KPI creation, DAX measures, and interactive dashboard development
- Total Sales: 12.64M
- Total Profit: 1.467M
- Total Orders: 25K
- Total Customers: 5K
- Profit Margin: 11.61%
Analyzed yearly sales and profit trends to understand business growth and performance over time.
Identified the top 10 products based on sales to understand the products contributing most to revenue.
Compared sales across:
- Technology
- Furniture
- Office Supplies
Analyzed regional sales performance to identify the strongest and weaker-performing regions.
Compared profit across different sub-categories to identify the most profitable areas of the business.
The dashboard includes slicers for:
- Year
- Market
- Region
- Category
- Segment
These filters allow users to interactively explore different parts of the dataset.
- Total sales reached approximately 12.64M.
- Total profit was approximately 1.467M.
- The overall profit margin was 11.61%.
- Technology generated the highest share of sales among the categories.
- The East region recorded the highest sales among the displayed regions.
- Machines were the highest profit-generating sub-category in the analysis.
- Focus on high-performing products and categories to increase revenue.
- Analyze low-profit areas and optimize pricing and costs.
- Develop strategies for regions with lower sales performance.
- Monitor profit margins along with sales to ensure profitable growth.
- Use customer and segment analysis to improve marketing strategies.
This project demonstrates the use of Excel, SQL, and Power BI to analyze a global retail dataset and convert raw data into actionable business insights.
The interactive Power BI dashboard provides a clear overview of sales, profit, customers, orders, products, categories, regions, and profitability, helping businesses make data-driven decisions.
Excel | SQL | Power BI | DAX | Data Cleaning | Data Analysis | Data Visualization | Business Intelligence