You are tasked with designing a data warehouse for an e-commerce company from scratch. Walk through your approach, from gathering requirements to delivering value.

Sample answer preview

Designing a data warehouse from scratch requires a structured approach that balances delivering quick value with building a sustainable foundation. Here is how I would approach it for an e-commerce company.