This repository showcases a set of Power BI dashboards created using the Superstore dataset from a USA-based Superstore, covering data from 2014 to 2017. The dashboards cover various aspects of sales and business insights. The key dashboards include:
- Sales Overview
- Customer Insights
- Profit Overview
- Sales Managers Insights
Each dashboard includes slicers for selecting data by year (2014, 2015, 2016, 2017) to view data for individual years or all years collectively.
Superstore.xls: The dataset used for the dashboards, sourced from Kaggle.superstore dashboard.pbix: The Power BI file containing the dashboards.screenshots/: A folder containing screenshots of the dashboards.
- Download the dataset (
Superstore.xls) and open it in your Power BI environment. - Open the Power BI file (
superstore dashboard.pbix) or import the dataset into a new Power BI project. - Customize the dashboards as needed for your own analysis or use the existing ones for business insights.
-
Sales Overview:
- Total sales, total quantity sold, total customers, and average order value.
- Sales trend by months.
- Top-performing categories and subcategories.
- Top 10 customers by sales.
-
Customer Insights:
- Number of orders and customers.
- Average shipping time (in days).
- Orders by state.
- Repeated top 10 customers.
- Ship mode analysis.
-
Profit Overview:
- Total profit, average profit per order.
- Total sales and profit trends by months.
- Profit by categories and subcategories.
- Top 10 products by sales.
-
Sales Managers Insights:
- Number of managers and total profit.
- Tabular format with manager names and their assigned regions.
- Profit by regions using a pie chart.
- Sales performance by managers.
- Power BI Desktop (Free version).
- The dataset (
Superstore.xls) can also be used in other data analysis tools like Excel, Tableau, etc.
Thanks to the creators of the Superstore dataset, available from Kaggle.