McLaren Racing pursues car build efficiency with Alteryx

Controlling costs

The cost cap introduced into Formula 1 this year, and announced in October 2020, was the trigger to find something like Alteryx to streamline the manufacturing costs of the car, said Green. The cost cap for 2021 for the 10 F1 teams is $145m.

Green refers to the car build as a major area where costs can be controlled better. There are many disparate datasets in play there, and while they do have the existing ability to see where the costs lie, there is a pressing need to do so “in the moment”, around the races themselves.

“There are 80,000 components on the car, and they change at a rapid rate,” he says. “In any given season, about 90% of the car will change. And there is small carryover into next season’s car, even less next year due to regulation changes.

“The car is always best described as a prototype. Depending on the characteristics of the track, that will change features of the car. We are roughly producing a new part every 17 minutes throughout the season.” And that is at the track, using 3D printing, as well as at the factory, he says.

Analysing data

Green says Alteryx is helping to bring together over a dozen different datasets to automate the analysis and processing of information to help design and engineering teams avoid excess material and manufacturing wastage, to be more efficient in terms of what is manufactured and delivered to the track.

McLaren’s use of Alteryx will also help what the high-performance car industry calls “aero model correlation”. The aerodynamic modelling of a car will traverse a multitude of analysis tools, each producing data points – from purely virtual computer simulation, wind tunnelling, and then “real, real life” of the races themselves, says Green.

And it is the data associated with each part that is critical. Alteryx will provide correlation and analysis of each part’s “journey” from design through testing and deployment in the races. The essential idea is to align better and better how the part performs, from virtual simulation through wind tunnelling to the car as it is driven under race conditions.

“We’ll be looking to see, ‘Did that part perform as we thought it would, based on our modelling and simulation?’ So, you have all those different datasets and data coming from the car. And, ultimately, we want to bring that all together into one view,” says Green.

“What we are trying to see is, ‘Did that part perform from the virtual world to the physical world when that part went into the wind tunnel as scaled down model?’ And if we think those two sets of information do correlate, then there’s a strong likelihood that we will say, ‘Yes, we think that’s a good performance advantage for the part’. We would then put that into manufacturing. Then we get to the car. You then want to see if the part you produced worked at scale with all the other aerodynamic properties around the car.”

There are about 300 sensors on the car, which, along with the on-board video and radio feeds in its “brain”, its electronic control unit (ECU), produce 1.5TB (terabytes) of data over a typical race weekend.

“Our challenge as a team is to get all that data back and combine it to spot anomalies, and so on,” says Green. “A lot of strategy work takes place in simulating the races. We do about 300 million simulations of the race before we see the green light on Sunday afternoons.”

For the drivers, such as Lando Norris and Daniel Ricciardo, that means taking in information such as, ‘If it starts raining on the first lap, this is what we recommend you do’. “Those decisions have to be made in as little as three seconds,” says Green.

For the team members working with the race data, Alteryx’s value is that “it gives people time to focus on the output and the results, and working and collaborating with other people, rather than manually munging the data”, he says.

Connecting with geodata

An additional, and differentiating, benefit of Alteryx, says Green, is the “unique” capability that the supplier delivers with geodata. This means they can connect McLaren fans with their commercial partners.

“If one of our lifestyle partners has a location in a city and we can see that a lot of our fans are based in that area, we might go and do a fan engagement at their headquarters, regional offices, or one of their stores, or equivalent,” he says.

By this, Green means Alteryx datasets use geodata to help McLaren understand what race venues are closest to their fans and how to build experiences close to them. Alteryx Data Sets are available to their users through the install platform.

An Alteryx spokesperson says the datasets are either “location intelligence or consumer intelligence packages and consist of data from providers such as Mapbox, TomTom, Experian and Digital Globe”.