- 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.
- Build a Sales Analysis, Product Analysis and Shipping Analysis Dashboard.
- Microsoft Power BI
- 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
- 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
!
- 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
- 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.
