Project2
SuperStore Sales Dashboard Analysis
📊 SuperStore Sales Dashboard Analysis
Author: Deepak Annapureddy
Tools Used: Power BI, DAX, Excel, SQL
🔍 Project Overview
- Developed an interactive Power BI dashboard to analyze sales performance across regions, categories, and customer segments.
- Implemented KPIs and forecasting to support data-driven business decisions.
- Visualized trends in sales, profit, and customer behavior using dynamic filters and charts.
🎯 Project Objectives
- Analyze sales and profit trends over time
- Identify top-performing products and categories
- Perform region-wise and state-wise sales analysis
- Forecast future sales for 15 days
- Create interactive and user-friendly dashboard
📊 Sample Dashboard Visuals
🧠 Key DAX Measures
Total Sales = SUM(Orders[Sales])Total Profit = SUM(Orders[Profit])Total Orders = DISTINCTCOUNT(Orders[Order ID])-
Profit Margin % = DIVIDE(SUM(Orders[Profit]), SUM(Orders[Sales]), 0) -
Sales Growth % = (Current - Previous) / Previous
📈 Insights Gained
- California generates the highest sales revenue
- Office Supplies is the top-performing category
- Phones and Chairs contribute major revenue
- Standard Class is the most used shipping mode
- Sales show an overall upward trend
- Forecast indicates continued growth in upcoming days