Business Sales Dashboard.

Overview

This project is a business intelligence dashboard built using Power BI to analyze sales performance from the Superstore dataset.

The goal was to transform raw transactional data into structured insights that can support business decision-making.

Problem

Raw sales data often lacks clarity and requires structured analysis to identify trends, performance gaps, and opportunities.

Without proper visualization, it becomes difficult for decision-makers to:

• identify seasonal demand patterns
• evaluate product performance
• understand regional contributions

Approach

The dashboard was built using Power BI, with data preparation performed in Excel and analytical measures created using DAX.

The system focuses on three core areas:

• sales performance over time
• product and category insights
• regional and customer segmentation

Interactive filters and visual components were used to allow dynamic exploration of the data.

Key Features

• Time-series analysis of sales trends
• Category and sub-category performance breakdown
• Regional sales distribution visualization
• KPI metrics using DAX
• Interactive filters for detailed analysis

Key Insights

• Sales peak during November and December, indicating strong seasonal demand
• Phones are the highest-performing sub-category (~₹0.33M), followed by chairs and copiers
• Technology is the leading revenue category (~₹0.84M)
• The South region contributes the highest share (~26%), with balanced regional distribution overall
• Consumer segment accounts for ~51% of total sales

Outcome

This project demonstrates how data visualization and structured analysis can convert raw datasets into actionable business insights.

It highlights the importance of dashboards in identifying trends, guiding strategy, and supporting decision-making processes.