superstore-powerbi-dashboard

A Power BI dashboard project analyzing Superstore sales data.

Problem Statement

Superstore Inc. is a growing retail business operating across the United States. The management has noticed variations in sales, profitability, and customer behavior across different regions and product segments. With expansion plans underway, they want a clearer understanding of:

• Who their top customers are

• Which regions perform best

• Which product categories and sub-categories drive the most profit

• How sales are trending and what future sales look like

To enable data-driven decision making, the management requested the Business Intelligence team to build an interactive dashboard to analyze sales performance, product trends, and forecasts.

Task

You are Omkar Borate, a Business Analyst responsible for building this Power BI dashboard using the Superstore dataset. The objective is to create a comprehensive and interactive reporting solution that enables stakeholders to:

• Visualize customer behavior

• Evaluate segment and regional performance

• Track product profitability

• Forecast future sales trends

Dashboard Views

1. Customer Behavior View

• Top customers by sales

• Profit vs Sales by segment

• Average order value by segment

• Customer contribution in cumulative sales

2. Product Performance View

• Tree map of sales, profit, and quantity by category & sub-category

• Profit by sub-category

• Top 10 products by profit

3. Regional Performance View

• Sales and profit by region

• Segment-wise sales by region

• State-level map of sales performance

4. Sales Forecasting View

• Historical monthly sales trends

• Future sales predictions using built-in forecasting model

• Monthly sales comparisons

5. Sales Performance Overview

• Total sales, total profit, and order volume by year

• Sales trends across months and years

• Segment-wise breakdown

Key Insights

• The Consumer segment is the highest contributor with $1.16M in sales.

• The West region tops the chart with $0.73M in total sales.

• Phones lead as the most profitable sub-category, earning $45K.

• Top customers like Sean Miller and Tamara Chand have contributed significantly to total revenue.

• Sales show a clear Q4 spike every year, especially in November–December, due to festive demand.

• Forecast models predict an 18% uptick in sales during the final quarter.

Skills & Tools Applied

• Power BI (Data modeling, DAX, Slicers, Forecasting)

• Data cleaning & transformation

• Visual storytelling through KPIs & drilldowns

• Advanced visualizations (Map, TreeMap, Line Charts, etc.)

Learnings from the Project

• Gained a strong understanding of interactive BI dashboards.

• Understood how to translate raw data into meaningful insights.

• Learned to present multi-view dashboards for cross-functional use cases.

• Improved hands-on experience with Power BI filters, relationships, and forecasting techniques.

Project Screenshots

Sales Overview

Regional Performance

Product Performance

Customer Behavior

Sales Forcasting

Conclusion

This Superstore Sales Dashboard is designed to empower decision-makers with critical insights about business performance, trends, and forecasts. It brings together key dimensions of the business in a visually intuitive and interactive format, enabling faster and smarter decisions.