This project is part of a Data Analyst Internship task focused on Data Visualization and Storytelling using Power BI. The dashboard provides key insights into sales performance, customer segments, and business trends from a fictional Superstore dataset.
Create a visually compelling and interactive Power BI dashboard that communicates business insights clearly and effectively.
-
✅ KPI Cards for:
- Total Sales (1.08M)
- Number of Orders (5K)
- Average Order Value (218.90)
-
🗺️ Map Visualization:
- Regional sales performance across US states.
-
📈 Time Analysis:
- Sales trends from 2015 to 2018 using line charts.
-
🎯 Categorical Analysis:
- Sales by Category and Segment.
- Preferred Ship Mode analysis.
- Regional sales comparison.
-
🧩 Interactive Slicers:
- Region, Category, Ship Mode, and Year for dynamic filtering.
-
🎨 Clean UI/UX:
- Custom color palette, icons, and layout using Power BI design best practices.
- Microsoft Power BI
- DAX (for calculated measures)
- Power BI Visualizations: Cards, Line Charts, Donut Charts, Maps, Bar Charts, Slicers
- Technology is the top-selling category with ~0.38M in sales.
- Standard Class is the most used shipping mode (58.42%).
- Consumer segment generates the highest sales.
- Sales increased significantly from 2015 to 2018.
- West Region has the highest contribution in total sales.
train.csv: The dataset useddashboard_screenshot.png: Image of the final dashboardREADME.md: Project documentation
- Clone this repo.
- Open Power BI Desktop.
- Load the dataset (
train.csv) and replicate visuals using the screenshot. - Explore insights by using the slicers.
Mastered:
- Building clean and insightful dashboards.
- Using storytelling elements to communicate data.
- Creating KPIs and custom visuals for decision making.
If you find this helpful or have suggestions, feel free to open an issue or connect!