Steps to design a Data Warehouse

• Gather Requirements

• Environment (Physical / Cloud)

  • Dev

  • Test

  • Prod

• Data Modeling

  • Star Schema

  • Snowflake Schema

  • Galaxy Schema

• Choose ETL - ELT Solution

• OLAP Cubes or Not

• Visualization Tool

• Query Performance

• Production release