Superstore-Sales-Dashboard - PowerBI

• Power BI dashboards can be a helpfull tool to provide insights into sales performance and trends of an organization.
• The dashboard should include key metrics such as total sales, sales by product, sales by location, sales by customer segment, and sales by product category.
• It should also provide comparisons of performance to prior years, and allow for drill-down into individual market and products.

Problem Statement:

• Build a Sales Analysis, Product Analysis and Shipping Analysis Dashboard.

Tools Used:

• Microsoft Power BI

Data:

• Data Source : Superstore dataset from kaggle https://www.kaggle.com/datasets/laibaanwer/superstore-sales-dataset
• The sales is between the period of 2011 to 2014

Dashboards:

Sales Analysis Dashboard:

• Sales department can analyze sales and profit through this dashboard. Filter through years and quarterly sales.
• The company has made a Total Sales of 3 million and Total Profit of 400.9K between 2011- 2014.
• 1 million worth of sales and 119.11K profit was made in 2014.
• 46% of profit came from product category technology.
• Year 2014 March and April has seen high sales revenue and December being the holiday Season has the lowest revenue sales.
• Filter for year 2014, category: technology, Order Priority: Medium !

Product Analysis Dashboard:

• This dashboard dive deep into product categories, quantity ordered, product- subcategory
• Highest amount of office supplies have been ordered in terms of quantity.
• Tables have been sold at an average discount of 28% in 2014
• Filter year: 2014, market: US

Shipping Analysis Dashboard:

• 53% of the orders have Standard shipping mode and lowest preferred is same day shipping.
• 41% of Orders with critical order priority have been ordered by firstclass ship mode.
• 100 % of the orders with low priority have been ordered through standard class.
• APAC markets have highest shipping cost, followed by EU and US.