Download PDF
Strategic Planning & Forecasting Using Alteryx and Tableau
Technology Category
- Analytics & Modeling - Big Data Analytics
- Application Infrastructure & Middleware - Data Visualization
Applicable Industries
- Automotive
Applicable Functions
- Business Operation
- Sales & Marketing
Use Cases
- Demand Planning & Forecasting
- Predictive Maintenance
Services
- Data Science Services
The Challenge
Audi's Strategic Planning team was facing challenges with data analysis. The data was being accumulated faster, in greater quantities and in more diverse types than ever before in history. The current data analysis processes were inefficient and often ineffective. Data was scattered & fragmented, typically in many different places. Analysts were spending more time pulling data, transferring it into excel and then graphing it in neatly formatted powerpoint slides than exploring the data and actually analyzing what it means. There was a clear need for tools to empower data analysts, managers and executives - not IT - to explore and self-serve their own advanced data visualizations.
About The Customer
Audi is a German automobile manufacturer that designs, engineers, produces, markets and distributes luxury vehicles. Audi is a member of the Volkswagen Group and has its roots at Ingolstadt, Bavaria, Germany. Audi-branded vehicles are produced in nine production facilities worldwide. The company has been a major player in the automotive industry and has a strong presence in the U.S. market. Between 2009 and 2014, Audi saw a 120% growth in sales volume in the U.S. and has had 52 consecutive months of record sales. The company is committed to sustainable profitable growth and is the #2 top cross shopped premium brand. Audi has seen growth in high-end models, has a low retail incentive spend per vehicle, increased pricing power, and healthy lease penetration.
The Solution
Audi's Strategic Planning team adopted Alteryx and Tableau to address their data analysis challenges. Alteryx was used as a key enabler of data consolidation. It helped in reducing the storage from 1gb to 4mb for over 3 million rows of data, resulting in much faster processing times in Tableau. Alteryx was also used as a data cleanser and shaper, used repetitively in many instances. Tableau was used as a visual and analytical layer. With all relevant data sitting in one database, other important variables became obvious. The combination of Alteryx and Tableau allowed for a comprehensive understanding of the market, dedication to customer delight, marketing excellence, exciting product, committed partners, and a futuristic vision.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Monitoring of Pressure Pumps in Automotive Industry
A large German/American producer of auto parts uses high-pressure pumps to deburr machined parts as a part of its production and quality check process. They decided to monitor these pumps to make sure they work properly and that they can see any indications leading to a potential failure before it affects their process.
