Data warehousing has evolved into a unique and key component of IT strategy for many organisations. Dimensional modelling is the proven technique for developing understandable, high-performance data warehouses and data marts.
This course introduces data warehouses, demonstrates the techniques involved in developing dimensional models and shows how these models fit in to the process of building data warehouses. All techniques are illustrated by real world examples drawn from a range of industries.
After taking this course, students will be able to:
- Define the constituent parts of a data warehouse.
- State the limitations of classic entity-relationship models in data warehouse design.
- State the strengths of dimensional models and understand how such models are used in the development of data warehouses and data marts.
- Gather relevant requirements and place these requirements into a proper context for use in dimensional model development.
- Develop appropriate dimensional models using the approach given in the course.
- Understand what metadata is and its importance in data warehouse design.
- Use appropriate techniques in the design of systems to perform the functions of extract, transform and load.