This project has been created for an on-going personal/public development of a datawarehouse to improve and maintain existing SQL skills on the Microsoft BI Stack using Kimball Methodologies.
The stages of this project are as follows:
- Create Table Scripts
- Develop Procedures for Insert and Update of Tables
- Create ETL Deliver Table Scripts
- Develop Procedures for Delivering Updates to Datawarehouse Tables
- Create SSAS project based on Datawarehouse
I will add further stages later on as I have enough to get on with, I Will be using latest technique learnt over career and future research in Microsoft BI stack.