The situation
Toyota International had to decide which cars to send to which dealers. Those calls leaned on manual work, and the data lived in more than one system.
What I did
My firm, Everything To Gain, was brought in to fix how cars get matched to dealers.
Set the sales-speed numbers (how fast each dealer sells each car) that guide which dealer gets which car.
Built Tableau and Essbase dashboards that match cars to dealers automatically.
Set up security so each person only sees the data they should, across Essbase and Snowflake.
The result
Car-to-dealer matching moved from manual work to dashboards the team could trust, with an eight-figure impact for Toyota International.