This is the actual start of your Data Warehouse project. Following things needs to executed in this step.
1. Design a data model based on requirement analysis. It could be star schema or snowflake schema based on requirement. Data modeling consist of following three parts.
a. Conceptual data model
b. Logical data model
c. Physical data model
2. Document in the data model design process including all possible details.
3. Get it reviewed and cross check the data model with reporting needs and your technical team.
5. Design a ETL process. ETL can be done using home grown tool or commercial tools. Having commercial tool speed up the process and also make is easy to maintain as skill set and support is available easily.
6. Create a sample data for the data warehouse and ETL. this could be a snap shot of the OLTP data.
5. Create a Unit testing plan and test ETL and data model for every new addition and change.
6. Try creating sample reports on top of data warehouse to test it.
Did you enjoy this article? Please subscribe to Email or RSS to receive all the FREE updates!
Related posts: