Power BI Dashboards - Sales & Customer Insights

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:

1. Sales Overview
2. Customer Insights
3. Profit Overview
4. 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.

Contents

• 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.

Requirements

• Power BI Desktop (Free version).
• The dataset (Superstore.xls) can also be used in other data analysis tools like Excel, Tableau, etc.

How to Use

1. Download the dataset:

   • Download the Superstore.xls file and save it on your computer.

2. Open Power BI:

   • Launch Power BI Desktop on your computer.

3. Import the dataset:

   • In Power BI, click on Home > Get Data > Excel.
   • Select the Superstore.xls file from your saved location and load it into Power BI.

4. Open the Power BI file:

   • If you already have the pre-built Power BI file (superstore dashboard.pbix), open it directly by clicking File > Open and selecting the .pbix file.
   • Alternatively, import the dataset into a new Power BI project and create dashboards from scratch.

5. Customize the dashboards:

   • Use the existing dashboards or modify them to suit your analysis or business needs.
   • You can change visualizations, add filters, or adjust slicers as required.

Dashboards Overview

Sales Overview:

A snapshot of total sales, quantity sold, customer count, and key performance indicators.

Customer Insights Dashboard:

Displays customer-related data, including orders by state and repeat customers.

Profit Overview Dashboard:

Highlights profit trends, total profit, and profit by category.

Sales Managers Insights Dashboard:

Provides sales performance metrics and profit by region for different managers.

Note:

While these are static images, you can interact with the dashboards in the Power BI file superstore dashboard.pbix to explore data in real time.

Acknowledgements

Thanks to the creators of the Superstore dataset, available from Kaggle.