Empowering end-users beyond BI and leveraging Machine Learning

Transcript

1. Anh Vu - Data Analyst
   Empowering end-users beyond BI
   and leveraging Machine Learning
   

   View Slide

2. 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
   

   View Slide

3. Data Analytics Maturity
   Where we could help
   

   View Slide

4. Use case
   Demand
   Forecasting
   Supply
   Chain
   Analysts
   Category
   Managers
   Supply
   Chain
   Managers
   Suppliers
   Customers
   Our client
   

   View Slide

5. Missions
   Empower our data consumers
   ● Visualisation & analysis
   ● Prediction
   ● Forecast adjustments
   Minimise (technical) silos in reporting landscape
   

   View Slide

6. Technology
   

   View Slide

7. Technology
   Looker
   

   View Slide

8. Technology
   Looker
   

   View Slide

9. Technology
   BigQuery Machine Learning
   

   View Slide

10. Technology
    BigQuery Machine Learning
    

    View Slide

11. Technology
    Extension Framework
    

    View Slide

12. 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
    

    View Slide

13. 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!
    

    View Slide

14. 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
    

    View Slide

15. Want to see Looker in action?
    Visit us at stand 119 for a demo!
    

    View Slide