Empowering end-users beyond BI and leveraging Machine Learning

Transcript

1. Anh Vu - Data Analyst Empowering end-users beyond BI and leveraging Machine Learning
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
3. Data Analytics Maturity Where we could help
4. Use case Demand Forecasting Supply Chain Analysts Category Managers Supply Chain Managers Suppliers Customers Our client
5. Missions Empower our data consumers • Visualisation & analysis • Prediction • Forecast adjustments Minimise (technical) silos in reporting landscape
6. Technology
7. Technology Looker
8. Technology Looker
9. Technology BigQuery Machine Learning
10. Technology BigQuery Machine Learning
11. Technology Extension Framework
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
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!
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
15. Want to see Looker in action? Visit us at stand 119 for a demo!