⬅ Projects

Amazing Mart Performance Dashboard (EU)

Interactive Power BI dashboard analyzing sales across segments, countries, categories, and yearly trends.

Author: Paul (SUT ZAW AUNG) Project: Amazing Mart BI Dashboard Date: 2025

Dashboard Overview

This interactive Power BI dashboard transforms raw sales data into meaningful business insights. It provides a clear view of performance across customer segments, regions, categories, and year-to-year trends. These insights help improve marketing targeting, operational planning, and long-term strategy.

1. Sales by Segment

The donut chart shows how revenue is distributed across Consumer, Corporate, and Home Office segments. Understanding segment performance helps identify the most valuable customer groups and shape marketing priorities.

Insight: Consumer segment generates the highest sales and shows strong buying behavior.

2. Sales by Country

The map visual compares performance across major European countries. Large bubbles represent high sales volumes, highlighting areas with strong customer demand and growth potential.

Insight: France, Germany, and the UK lead the region. Smaller markets offer opportunities for expansion.

3. Sales by Category

This chart reveals which product categories generate the most revenue. It helps businesses identify profitable items and evaluate which categories may need strategic adjustments or promotion.

Insight: Technology leads as the strongest category, showing high demand and profitability.

4. Sales by Year

Yearly sales trends from 2011–2014 show consistent, steady growth. This visualization helps evaluate business health and supports future demand forecasting.

Insight: Continuous growth indicates strong expansion and increasing customer acquisition.

Summary

The Amazing Mart EU dashboard provides a clear and actionable overview of sales performance. Key takeaways include:

• Consumer segment is the largest revenue driver.
• France, Germany, and the UK dominate regional performance.
• Technology is the most profitable product category.
• Sales show stable growth from 2011–2014.

These findings support smarter decision-making in marketing, product strategy, and business planning.

Forward Strategy

To continue improving business performance, the following steps are recommended:

• Focus marketing campaigns on the Consumer segment to maximize ROI.
• Expand into lower-performing countries using localized strategies.
• Increase investment in Technology products due to high profitability.
• Use forecasting techniques (ARIMA, Holt-Winters, SES) for better planning.

These actions will help Amazing Mart strengthen growth and maintain competitive advantage.

Project Data Sources

📊 Data Files Used