Profile : Starbucks Europe (HQ in the UK) distributes RTD (ready-to-drink) and AHC (at-home-coffee) to 17 countries around Europe Objective : Generate consolidated report of sales from local retailers (data via Nielsen) Problem : Each country/retailer has a different representation of the data. They come in large volume and are non-standardised Starbucks Case Study: Data standardisation and automation with speed Transparent / Automated / Error-free 4 hours - online dashboard BEFORE AFTER * * External Agency Fragmented sales data for 17 countries 1 billion row+ processed monthly Built for scale Fragmented sales data for 17 countries Opaque / Non-repeatable / Error-prone 4 weeks to generate offline report Inability to handle complex data Non-scalable 6