Supply Chain: Starbucks DW Consolidation
TL;DR The Starbucks data warehouse doubled in size.
Challenge: After acquiring Seattle’s Best Coffee (SBC), Starbucks merged its supply-chain operations to pick/pack/ship and bill for whole-bean and ground coffee from one transactional system. As a Data Warehouse PM, I was challenged — along with the DW database and application leads — to merge accounts for seamless reporting post go-live and SBC deprecation.
Impact / Key Learnings: You can never have enough test cases, and you can never trust that test data will look like production. Data-warehouse consolidations in tandem with transactional-system migrations are hard.
