Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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

Slide 3

Slide 3 text

Data Analytics Maturity Where we could help

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text


Slide 7

Slide 7 text

Technology Looker

Slide 8

Slide 8 text

Technology Looker

Slide 9

Slide 9 text

Technology BigQuery Machine Learning

Slide 10

Slide 10 text

Technology BigQuery Machine Learning

Slide 11

Slide 11 text

Technology Extension Framework

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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!

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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