Todo.md

Todo List

Project Overview

1. Final Staging Area + ETL
   • Warehouse
   • Sales
   • Purchase (Removed)
2. Final Design of Data Warehouse
   • Warehouse
   • Sales
   • Purchase (Removed)
3. Final Dimensions + SCD and ETL
   • Warehouse
   • Sales
   • Purchase (Removed)
4. Final Facts + ETL
   • Warehouse
     • Transactional
     • Periodic Snapshot Daily
     • Accumulative
   • Sales
     • Transactional
     • Periodic Snapshot Daily
     • Accumulative
   • Purchase (Removed)
     • Transactional
     • Periodic Snapshot Daily
     • Accumulative
5. ETL Documentation and Metadata
   • Warehouse
     • Dimensions
     • Facts
   • Sales
     • Dimensions
     • Facts
   • Purchase (Removed)
     • Dimensions
     • Facts
6. Data Warehouse Metadata and other stuffs
   • Use partitioning
     • Warehouse
     • Sales
     • Purchase (Removed)
   • Adding indexes to appropriate tables
     • Warehouse
     • Sales
     • Purchase (Removed)
7. >> OPTIONAL PART :D <<
   • SSAS + OLAP Engine For Every Mart (Up to 2 pts)
   • SSIS (Up to 1 pts)
   • SSRS (Up to 1 pts)
   • Using Job (Up to 0.5 pts)