Accelerate BMW’s BI Migration to AWS with GenAI
Storm Reply automated the migration of Tableau dashboards to Amazon QuickSight, leveraging Generative AI to slash costs and establish a vendor-agnostic data ecosystem.
#Business Intelligence
#Amazon QuickSight
#Generative AI
#Automotive Industry
,allowExpansion)
The challenge
Migrate over 10,000 complex BI dashboards to a cloud-native platform to reduce maintenance overhead, lower licensing costs, and scale performance for BMW’s global teams.
The scenario
Providing 270 teams with reliable insights
Business Intelligence (BI) solutions are a key success factor in today's automotive industry. They form the basis for sound, data-driven decisions. This is why BMW Group has opted for a central BI platform that provides employees with useful data in an interactive and understandable way.
A solution that has been well received: about 270 teams access over 10,000 dashboards, which can be quickly tailored to the needs of individual employees and departments using various filters and parameters. However, maintaining the Tableau-based platform used to be very time-consuming for the company. At the same time, on-premises hosting resulted in high costs and limited scalability.
The solution
A future-ready BI ecosystem
Today, BMW benefits from a new cloud-based BI platform in Amazon QuickSight that offers:
Operational excellence
Infrastructure management, data refreshes, and scaling are now fully automated, ensuring high availability.
Conversational analytics
By integrating GenAI, users can now gain insights through natural language queries, democratizing data access across departments.
Seamless continuity
Dashboards retain their original look and feel, ensuring zero downtime for user productivity and no need for extensive retraining.
Strategic IT realignment
The IT department has transitioned from "maintenance mode" to "innovation mode," focusing on optimizing data value rather than managing servers.
,allowExpansion)
How we did it
90 percent accuracy thanks to Gen AI
A manual migration of this scale would normally take 7 to 10 days per dashboard. By leveraging Generative AI via Amazon Bedrock, Storm Reply reduced this to just a few hours, with only 10 per cent of the data requiring manual intervention. The process is powered by a custom parsing script that automatically generates an intermediate JSON file for each dashboard based on Tableau data. This enables BI tools to read the data easily and provides a tool-agnostic solution, allowing future integration with other BI platforms.
Additionally, the solution integrates Amazon Q, a GenAI assistant, enabling BMW employees to interact with their data conversationally, accelerating insights and decision-making.
The result
The optimal basis for data-driven decisions
The amount of data that companies like BMW need to process to stay competitive is growing, and managing it is becoming increasingly complex. But with Storm Reply's solution, the car manufacturer is now well equipped benefiting from a rapid transition from traditional BI tools to cloud-native solutions, accelerated by GenAI.
Thanks to the new BI platform in Amazon QuickSight, BMW can continuously benefit from the latest advances in cloud computing and AI, and scale cost-effectively at any time. This gives them the ability to respond more quickly and flexibly to market changes and make more informed, data-driven decisions.
With its brands BMW, MINI, Rolls-Royce and BMW Motorrad, the BMW Group is the world’s leading premium manufacturer of automobiles and motorcycles and a provider of premium financial services. The Group operates more than 30 production sites worldwide and maintains a sales network spanning over 140 countries. In 2024, the BMW Group sold over 2.45 million cars and more than 210,000 motorcycles. Earnings before taxes totalled €11.0 billion on revenues of €142.4 billion. As of 31 December 2024, the company employed 159,104 people. Long-term thinking, responsible action and sustainability are deeply embedded in the BMW Group’s corporate strategy, from the supply chain to production and beyond the end of a product’s life cycle.
Storm Reply is part of the Reply Group and specialises in developing and implementing innovative AWS-based solutions and services. The company's expertise in Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS) enables them to provide comprehensive support throughout the entire cloud transformation process. Using AWS creates measurable business value. As an AWS Premier Consulting Partner, Storm Reply assists leading European and global companies with implementing and managing critical cloud-based systems and applications. The targeted use of AI and generative AI from the AWS portfolio automates processes and enhances long-term innovative strength. This creates a scalable, cloud-based foundation for the continuous transformation of business models.