Question: what are the steps in designing a data warehouse?
Answer: Defining Business Requirements (or Requirements Gathering) ... 
Setting Up Your Physical Environments. ... 
Introducing Data Modeling. ... 
Choosing Your Extract, Transfer, Load (ETL) Solution. ... 
Online Analytic Processing (OLAP) Cube. ... 
Creating the Front End. ... 
Optimizing Queries. ... 
Establishing a Rollout.