1. Home
  2. Work
  3. BMW

Case study 03 · Enterprise data

BMW: Qlik to AWS QuickSight migration

The Qlik to AWS QuickSight migration of all 38 dashboards, which I planned and led, after seven years as the sole developer on BMW’s data and analytics programme: from BMW Japan and the Middle East to one view of 100+ countries for leadership in Munich.

Period
Oct 2019 – Aug 2026
Employer
UST, then BMW TechWorks India
Role
Sole developer
Scale
100+ markets · 38 dashboards

2019–2026

Japan
Excel → Qlik Sense; refresh 2.5 hours → under 4 minutes; ~200 users
Middle East
Sales, After-Sales and Director dashboards, plus NPrinting reports
C3 market
100+ countries in one view for leadership in Munich; ~100 senior users
Migration
All 38 dashboards, Qlik → AWS QuickSight (2023 – 2025)
This work is described in words only. No BMW systems, screenshots or internal data are shown.

01The problem

BMW markets needed reporting they could rely on: first replacing Excel in Japan, then one consolidated view of 100+ countries for leadership in Munich, and finally a move from Qlik to AWS QuickSight after BMW’s global decision to change platforms.

02What I built

  • BMW Japan: replaced Excel reporting with Qlik Sense Sales and After-Sales dashboards. Data refresh went from ~2.5 hours to under 4 minutes; maintained for ~200 users.
  • BMW Middle East: Sales, After-Sales and Director dashboards in Qlik Sense, plus Qlik NPrinting reports. Formal appreciation from BMW Group Middle East (2020).
  • C3 market dashboard: one consolidated view of 100+ countries, including Japan, Korea, India, Thailand, Australia, the Middle East, Qatar, Bahrain and Pakistan, for leadership in Munich. It covers sales, marketing and registrations, has ~100 senior users (country managers and directors) and is used heavily in Munich leadership meetings. ~25 million rows, refreshing hourly in ~9 minutes.
  • Qlik → AWS QuickSight migration (2023 – 2025): following BMW’s global decision, I planned, led and executed the migration of all 38 dashboards (Sales, Marketing, Registration, Stock) from zero to 100%.

03My role

Sole developer on the programme for seven years: at UST from October 2019 to December 2024, then as Assistant Manager at BMW TechWorks India from January 2025 to August 2026, after an internal transition.

Development was entirely mine, with a manager overseeing the programme.

04Tech

The QuickSight pipeline:

  1. 01 · TransformAWS GluePython / pandas jobs
  2. 02 · StoreAmazon S3Parquet files
  3. 03 · QueryAmazon AthenaSQL over Parquet
  4. 04 · ServeQuickSightSPICE · 38 dashboards
Pipeline behind the migrated dashboards. Generic AWS services only; no BMW data or naming.
  • Qlik Sense
  • Qlik NPrinting
  • AWS QuickSight
  • Athena
  • S3
  • Glue
  • Python
  • SQL

Data sources: AWS Athena (Parquet), Excel, text, JSON and XML feeds. Power BI: one 2021 project.

05Outcome

The migration removed ~90% of manual reporting, about 10–15 working days a month.

In June 2026, BMW Group’s C3 business owner wrote to the dashboard team that the QuickSight migration had been “smooth, fast”, and that the dashboard was now used by a growing number of colleagues, including the head of the C3 division.

Need something like this built?

Work with me