Learning Path - Data Modeling
We have taken a few of the fundamental articles of our website and ordered them in such a way so that it helps a newcomer or a learner to grasp the concept from beginning. Please check below
Data Warehouse Design Pattern
- OLTP and OLAP
- What is Data Warehousing?
- Business Intelligence
- Decision Support System ( DSS )
- What is a data warehouse - A 101 guide to modern data warehousing
- A road-map on Testing in Data Warehouse
- Enterprise Data Warehouse Data Reconciliation Methodology
- Top 5 Challenges of Data Warehousing
- Top 10 things you must know before designing a data warehouse
- Why people Hate Project Managers – A must read for would-be managers
- Top 10 things to avoid in DWBI project management
- Data Retention and Purging in a Data Warehouse
Dimensional Modeling
- Classifying data for successful modeling
- The 101 Guide to Dimensional Data Modeling
- Dimensional Modeling Schema
- History Preserving in Dimensional Modeling
- Dimensional Modeling Approach for Various Slowly Changing Dimensions
- Implementing Rapidly changing dimension
- Common Mistakes in Data Modelling
- Performance Considerations for Dimensional Modeling