Back to Projects

International Sales BI Dashboard

Custom business intelligence dashboard for a European fabric company, providing spatial distribution patterns and sales performance insights.

Business Intelligence
2023
UK / Germany

Project Overview

Built a comprehensive business intelligence dashboard for a European fabric company that needed to understand sales patterns across UK and Germany markets. The solution provides real-time insights by product, customer segment, and geographic region.

The dashboard integrates multiple data sources and includes geographic heat maps, time series analysis, and customer segmentation views that the sales team reviews every Monday morning.

Spatial distribution patterns by product, customer, region, and sales representative became visible for the first time, enabling data-driven decision making.

Key Metrics

2
Markets Covered
1000+
Postal Areas Mapped
Daily
Data Updates

Technical Approach

Data Processing

  • Sales data extraction and cleaning pipeline
  • Postal code to geographic coordinate mapping
  • Customer segmentation by purchase patterns
  • Time series aggregation (daily, weekly, monthly)

Visualization Components

  • Interactive heat maps by postal sector
  • Sales performance by representative
  • Product category breakdown
  • Trend analysis and forecasting

Technologies Used

Power BI Python Pandas GeoPandas GeoJSON DAX

Deliverables

  • Interactive Power BI dashboard
  • Geographic heat maps for UK and Germany
  • Automated data refresh pipeline
  • User documentation and training
Back to Projects