Trek Bikes 加速零售分析.pdf

1、2024 Databricks Inc.All rights reserved1TREK BIKES TREK BIKES ACCELERATES ACCELERATES RETAIL RETAIL ANALYTICSANALYTICSAdvait Raje&Garrett BaltzerAdvait Raje&Garrett BaltzerJune 2024June 2024Accelerating Retail Accelerating Retail Analytics using Azure Analytics using Azure DatabricksDatabricks andan

2、d QLIKQLIKThe speakers Keep Pedaling!Advait RajeGarrett BaltzerTrek Bicycle Overview Born in a Barn-1976 Global Leader in Bicycle Manufacturing,Distribution and Retail Significant number of company owned stores globally 2000+independent retailer store network globally Treks Mission:Only build produc

3、ts we love Offer incredible hospitality Change the world for better by getting more people on BikesAwesome Trek Products to Get More People on BikesINDUSTRYINDUSTRY:Retail and Consumer GoodsSOLUTIONSOLUTION:Real-Time Point-of-Sale AnalyticsPLATFORM USE CASEPLATFORM USE CASE:Qlik Replicate,Delta Lake

4、,Databricks SQL,Delta Live Tables,Data StreamingPARTNERPARTNER:Qlik&DatabricksCLOUDCLOUD:AzureAccelerationIncreaseReductionIn runtime of retail analytics solutions globally3X daily data refreshes using Azure DatabricksNear real-time ERP Data Replication enabled by Qlik Replicate80-90%3x1 WeekDatabri

5、cks Data Intelligence Platform,along with data replication to Databricks using Qlik,aligns perfectly with our broader cloud-first strategy,which demonstrates confidence in the adoption of this platform at Trek.”Steve Novoselac,Vice President,IT and Digital,Trek BicycleAgenda and Objectives Retail Da

6、ta Growth Cost-Performance Matrix Old Architecture ERP&POS Solution Overview Why Databricks?New Architecture ERP&POS Delta Live Tables at Trek Databricks SQL at Trek Databricks Unity Catalog at Trek Lessons Learnt and Conclusion Q&AChallenges Faced by Trek Bicycle Slow replication of ERP&POS data to