Sales Analysis Power BI Dashboard

This repository contains a comprehensive Sales and Product Analysis Dashboard built with Power BI. The project is designed to visualize complex sales data, providing clear, actionable insights through a clean, interactive, and professional user interface.

Overview

This dashboard provides a deep dive into sales performance, product trends, and market behavior. It is an excellent example of visual storytelling with data, demonstrating advanced DAX calculations and a strong focus on clean UI/UX design.

The dashboard visualizes:

• Average discounts by product sub-category
• Monthly sales trends by product category
• Order quantities distributed by market
• A clear sales flow from region to category using Sankey diagrams

dashboards-included) Features

The project includes three main dashboard pages, each tailored for a specific analytical purpose:

1. Executive Summary

• High-Level KPIs: Sleek visual indicators for key metrics (Total Sales, Profit, etc.).
• Performance Overview: Quick insights into sales performance by region and category.
• Professional UI: Designed for business decision-makers and stakeholders.

2. Sales Analysis

• Trend Analysis: Tracks total sales and profits with dynamic filters for year and quarter.
• Geographic & Market Breakdowns: Analyzes sales by state, market, and order priority.
• Customer Insights: Drills down to customer-level sales data.

3. Product Analysis

• Product Performance: Visualizes average discounts and order quantities by sub-category.
• Sales Flow: Uses a Sankey diagram to illustrate the sales flow from region to product category.
• Category Trends: Tracks monthly sales and quantities ordered by category.

---

Key Technical Features

• Advanced DAX: Utilizes complex DAX measures to create dynamic and insightful metrics.
• Data Modeling: Implements data modeling with relationships to connect different data sources effectively.
• Dynamic Filtering: Features interactive slicers for Year, Quarter, Category, and Region.
• Rich Visuals: Employs a variety of visuals, including Pie, Bar, Line, and Sankey charts, to tell a compelling story.
• Power Query Editor: Used for data transformation and preparation.

📷 Dashboard Preview

Executive Summary	Sales Analysis	Product Analysis

🛠️ Tools Used

• Microsoft Power BI Desktop
• DAX (Data Analysis Expressions)
• Power Query (M Language)

🚀 Getting Started

To use this dashboard:

1. Clone the repository:

   git clone [https://github.com/dot-css/Sales-Analysis-Power-BI-Dashboard.git](https://github.com/dot-css/Sales-Analysis-Power-BI-Dashboard.git)

2. Open the file:

   • You will need Microsoft Power BI Desktop installed.
   • Open the Superstoredata-dashboard.pbix file.

3. Interact with the data:

   • Use the slicers and filters to explore the data.
   • Click on visuals to cross-filter other elements on the page.

📄 Data Source

The dashboard is built using the "Superstore" dataset, a common sample dataset used for sales analysis.

License

This project is not currently licensed. Please contact the repository owner for permissions regarding use or distribution.

📬 Contact

For collaborations or freelance Power BI projects, you can reach out to the repository owner at [email protected].