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)
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:
- 01 · TransformAWS GluePython / pandas jobs
- 02 · StoreAmazon S3Parquet files
- 03 · QueryAmazon AthenaSQL over Parquet
- 04 · ServeQuickSightSPICE · 38 dashboards
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.