Business KPIs: • Total Revenue • Total Orders • Total Customers • Average Order Value • Quick evaluation of overall performance

Sales trend analysis: • Clear growth from 2010 to 2011 • Stable behavior with seasonal peaks • Monthly visualization to identify time patterns

Geographic distribution: • Strong revenue concentration in the United Kingdom • Lower contribution from Netherlands, EIRE, Germany and France • Market expansion opportunities

Market risk detection: • High dependency on a single country (UK) • Exposure to demand changes in that market

Product performance: • Identification of top-selling products • High-demand items such as PAPER CRAFT, LITTLE BIRDIE and MEDIUM CERAMIC TOP STORAGE JAR

Product concentration patterns: • A small group of products generates a large share of total sales • Opportunity to optimize inventory and marketing strategies

Interactive dashboard analysis: • Integration of KPIs and visualizations in a single view • Real-time data exploration • Improved understanding of business metrics

Business insights generation: • Data-driven understanding of sales behavior • Support for decision-making • Identification of growth opportunities

End-to-end sales data analysis project using Python (Pandas) and Power BI.

The project includes data cleaning, type validation, and correction of data modeling issues to ensure accurate calculations. Key insights were generated through interactive dashboards, including sales trends over time, revenue by country, and top-selling products.

This analysis highlights business patterns such as strong geographic concentration and product demand distribution, providing valuable insights for decision-making.