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.
-
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 modemore, 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 daysfollowing Second, First Class and Same Day Delivery!Standard Class Delivery Customers contributes ( $912K / $2M )
45.6%of Total Sales