Key steps in designing and implementing a best in class enterprise data warehouse
Identify all busines entities that generate data and consume data.
Identify all key data sources supporting business entities.
Develop a detailed data model – establish facts and dimemsions.
Develop key criteria for Data Warehouse platform selection.
Evaluate best in class platforms – Redshift, Snowflake, Synase, Databricks etc.
Develop Technical Design and Detailed Design documents.
Identify specific reporting and analytical requirements
Implement Data Warehouse and Data Marts.
Develop and implement Business Intelligence dashboards.