How KFC UK & Ireland Plans To Move The Business Forward With Answers To Bigger Questions
summary
KFC migrates its SQL Server warehouse to Snowflake on AWS, using Matillion for ELT, Matillion Data Loader to copy tables via S3, and MicroStrategy for reporting. A largest table has 8.5 billion rows, legacy loads time out, and replatforming runs historic backfills and daily deltas. Basket analysis that once takes four hours now drops to 30 seconds, enabling self-serve reports. The rollout uses waves/sprints and CDC-style sync to keep systems aligned.
AI-written summary · about
chapters (5)
- 0:00Start
- 1:29Who Are Kfc
- 4:22Front End Reporting
- 12:36Data Loader
- 18:22Deeper Integration with the Apis
related talks
57mHow Petco transformed its legacy business for the next generation
31mFrom Raw Data to Real Impact: Lessons from Real-World Transformations
59mHow Siemens & Petco drive enterprise transformation with data & AI
32mScalable Python and SQL Data Engineering without Migraines
42mWeb Development To Big Data. A Journey
30mRaw Data to Business Insights: What You Need to Build a Modern Data Lake
41mRole of Private Data Lake for Sustainable Business Growth
27mModernize Your Data Warehouse