A company wants to gain insights into its sales performance and key metrics to improve operational efficiency and strategic decision-making. They seek to monitor total sales, quantity sold, delivery efficiency, and returned orders while analysing sales distribution by segment and market. Additionally, they aim to identify top customers, high-profit products, low-profit products, and regional sales patterns. The ability to filter data by selecting a specific year is also crucial for year-over-year analysis.

• Load data into Power BI Desktop, dataset is a csv file.
• Gathered comprehensive sales data including total sales amount, quantity sold, delivery days, returned orders, customer segmentation, market information, product profitability, and regional sales data.

• Utilized a data visualization tool like Power BI to design the dashboard interface.

• Implemented Card visuals to display KPIs: Total Sales, Total Quantity Sold, Average Delivery Days, and Returned Orders, providing quick snapshots of key metrics.

• Created a Pie Chart to illustrate sales distribution by Segment, offering insights into the contribution of each segment to overall sales.

• Constructed a Donut Chart to represent sales by Market, allowing for a visual comparison of sales performance across different markets.

• Developed a Bar Chart to identify the top 10 customers based on sales volume, aiding in identifying key accounts and customer-centric strategies.

• Created two separate Bar Charts:

  • One to highlight the top 5 Profit Products, showcasing products driving profitability.
  • Another to pinpoint the top 5 Loss Products, indicating areas for improvement or optimization.

• Incorporated a Map Plot to visualize sales per Region, enabling geographic analysis of sales performance and regional trends.

• Implemented a slicer or filter functionality to enable users to select a specific year, facilitating comparative analysis across different time periods.

• Total Sales and Quantity Sold metrics provide a comprehensive understanding of revenue and sales volume.
• Average Delivery Days offer insights into the efficiency of logistics and order fulfilment processes.
• Analysis of Returned Orders helps gauge customer satisfaction and identify areas for improvement in product quality or customer service.

• The Pie Chart and Donut Chart illustrate sales distribution by Segment and Market respectively, highlighting areas of strength and opportunities for growth across different segments and markets.

• Identification of top 10 customers aids in recognizing key accounts driving revenue, facilitating targeted sales and retention strategies.

• Analysis of top 5 Profit and Loss Products guides product management decisions, focusing on promoting profitable products and addressing issues with low-performing products.

This visualization file showcases the actionable insights into various aspects of the company's operations, enabling informed decision-making to drive growth and profitability.

• The Map Plot visualizes sales per Region, enabling geographic analysis and identification of regions with high or low sales performance, helping in strategic allocation of resources and marketing efforts.

Overall, this dashboard provides actionable insights into various aspects of the company's operations, enabling informed decision-making to drive growth and profitability.