Sales & Profitability Analysis Dashboard

The Sales and Profitability Analysis Dashboard is a comprehensive business intelligence tool designed to answer critical questions about financial performance, geographic reach, and product efficiency. It is structured into three distinct analytical views: Executive Overview, Sales Analysis, and Profitability Analysis. The dashboard uses interactive filters for City, Year, and State Province to allow users to drill down into specific segments. Key findings from the data include a total profit of 9.92 million with a strong profit margin of nearly fifty percent. The business is heavily concentrated in North America, specifically in the city of Akhiok, which leads in both total sales and total profit. However, the average sale value is highest in Meadowdale, indicating different customer behaviors across regions. The product portfolio is led by the Air cushion machine, and the company relies heavily on Medium Profit items. Finally, there is a notable concentration risk, as the top five cities account for the majority of profits. Overall, this dashboard provides a complete narrative of what is selling, where it is selling, when it peaks, and how profitable it truly is.