Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Empowering end-users beyond BI and leveraging Machine Learning

Marketing OGZ
September 20, 2022

Empowering end-users beyond BI and leveraging Machine Learning

Marketing OGZ

September 20, 2022


  1. Introduction ☁ Born in Google Cloud ♻ Sustainability is at

    the core of what we do ❤ We live through our values 🌎 Largest dedicated Google Partner in EMEA
  2. Missions Empower our data consumers • Visualisation & analysis •

    Prediction • Forecast adjustments Minimise (technical) silos in reporting landscape
  3. Solution LookML handles multiple analytical operations for demand forecasting Consolidated

    training data Train predictions Visualise and correct forecasts Adjust Create time-series forecasting model (automatic weekly refresh) Historical sales data partitioned in BigQuery BigQuery ML Looker block to pre-process training data Request and accept forecast adjustments Request accepted and merged back to original forecast Adjust
  4. Lessons learned Scale what you can in your BI tool,

    otherwise leave it to your data engineers Understand and practise software engineering principles Work on the UX Measure your success!
  5. Summary 1. Identified the customer pain points (technical and business)

    2. Designed our solution 3. Iterated the solution with feedback 4. Tested it with our end-users 5. Handover and retrospective for 2nd phase