Advanced Data Warehousing Workshop: Multi-Dimensio
Advanced Data Warehousing Workshop: Multi-Dimensional Modeling培訓
?
授課對象
Data warehouse modelers with a prime interest in dimensional modeling for OLAP data marts, data warehouse data administrators, information analysts with an interest inmulti-dimensional data warehouse modeling, and project managers and technical professionals with an interest in MDDM and a good background knowledge of data modeling (E/Rmodeling for traditional OLTP databases).
預備技能
Courses: CF18: Relational Database Design and ?DW11:
Architecting the Data Warehouse or
Understand the techniques of E/R modeling for OLTP databases and be able to apply them.
Be familiar with OLAP from a data ?analysis point of view and with the basic concepts of data ?warehouses and data marts.
課程目標
By the end of the course, the students will be able to:
Understand MDDM basic principles
Produce dimensional models (Star- and Snowflake models) for non-trivial data warehouse modeling projects
Position MDDM with respect to ER modeling and to Temporal ER modeling in particular
?
?

?
?

?

?

?

?

?

?

?

?
?

?

?