To develop a comprehensive Super Store Sales PowerBI dashboard that provides real time insights into key-performance-metrics, trends and performs time-series forecasting.
- Prepare/Download the given CSV files
- Load File (from Get Data) into PowerBI and perform necessary Transformations on columns if required.
![image](https://private-user-images.githubusercontent.com/157014747/326337857-0fdd2589-915a-4d88-80df-33224cf23414.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM5NzQxMjgsIm5iZiI6MTcyMzk3MzgyOCwicGF0aCI6Ii8xNTcwMTQ3NDcvMzI2MzM3ODU3LTBmZGQyNTg5LTkxNWEtNGQ4OC04MGRmLTMzMjI0Y2YyMzQxNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxOFQwOTM3MDhaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT02ZDkxN2IwMDhjMmUxMzBkOTliM2Y4YzYzMGFkOWYxODBkNzkyNWUzZDI3YzY3ZmExZDZiNGI2OThkNWJiOTgxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.3Mx1xnMj_3hqT-jaJk90VBaYITW9xpqOel_RXHi0iPM)
-
Created (Order and Shipping Date Days Duration) column
Difference between Order Date and Shipping Date = DATEDIFF('Sheet1'[Order Date], 'Sheet1'[Ship Date], DAY)
-
Created (SalesForeCast) NEW TABLE in order to get (SUM OF SALES) by performing (GROUP BY ON ORDER_DATE COLUMN), with intention to get sum of sales done from different customerID on that particular date.
SalesForeCast = SUMMARIZE('Sheet1', 'Sheet1'[Order Date], "Total Sales", SUM(Sheet1[Sales]))
-
Top 5 States which led to generate more sales are California, NY, Texas, Washington and Pennsylvania as seen below
EASTERN Zone States have contributed ($450K / $2M) which is
22.8%
of total Sales generated. -
Customers preferred Cash-On-Delivery (COD) as their payment mode
more, following Online and Cards!
-
Sales and Profit's Rises from August to December month
Though Sales Increased but Profit🔻Decreased in month of November
-
We can
Expect an Average Sum of Sales from beginning of next year as $5.2K
-
Customers mostly preferred Standard Class which delivers Products in 5-7 days
following Second, First Class and Same Day Delivery!Standard Class Delivery Customers contributes ( $912K / $2M )
45.6%
of Total Sales