Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data might be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses.
| Files/Folder | Description |
|---|---|
| Project pbix Files | This file consista the power BI dashboard and reports. |
| Raw Data Files | This file is the superstore data file . |
The superstore dataset consists of the data of Orders and return table:
The orders table consists of the data of all the orders which were ordered in US in the year 2019-2020 with all the details ranging from the date of order, mode of shipment,customer details,products etc
The returns table consists of the orders which were returned with the orderid as the primary key.
The project contains different dashboard which hold the information about the sales overtview, customer and products overview.
These dashboards show the concise view in all these sectors and the use of slicers have also helped in viewing the details much more effectively.
The dashboard is made of different types of graphs, tables,maps etc to get every bit of data to the person viewing these.
o KPI’s :-
o Total Sales
o Profit
o Sales , Profits etc by categories and sub-categories.
o KPI's based on the regions.
o KPI's based on different segments.
o Comparison of profit by quantity sold
o Manufacturer per city in USA
1. Imported the dataset in Power BI and did a bit of cleaning.
2. Created some sheets for KPI's and their charts.
3. Used Parameters and actions for better representation of data.
4. Used calculated fields for some complex calculations.
5. Used some of the formatting options for better visualization.
6. Created a interactive and dynamic dashboard at the end.
--A Sales Overview Dashboard in Power BI is a comprehensive visual representation of key sales performance indicators and metrics for a business. It provides a consolidated view of sales data, allowing stakeholders to monitor and analyze sales performance in real-time or near-real-time
-- A Customer Details Dashboard in Power BI provides a comprehensive view of customer data and insights to better understand customer behavior, preferences, and interactions with a business. It enables stakeholders to gain valuable information about customers, segments, and trends, empowering data-driven decision-making and targeted marketing strategies.
-- This dashboard typically includes various visualizations and charts that display details about individual products, product categories, and their performance.
The superstore dashboard project using Power BI showcase the data of the orders done in the year 2019 and 2020 using different graphs and various other visualization tools.
Different types of graphs included with slicers which helps the user to go through the details and understand the insights much better.With its interactive and customizable features, the dashboard enables users to gain valuable insights into sales performance, inventory management, customer behavior, and other critical aspects of the business
By leveraging the power of Power BI, the Superstore Dashboard empowers decision-makers to make data-driven decisions, improve operational efficiency, and drive business growth.
The dashboard provides a comprehensive and visually appealing overview of key performance indicators (KPIs) and metrics related to the Superstore's operations, sales, and customer behavior.