Dimensional Modelling Design is key to a successful data warehouse. Many data warehouse projects fail due to poor design. To gain the knowledge necessary to create a flexible data warehouse with optimal performance for your business, this practical course introduces delegates to the key terminology and techniques used in Dimensional Modelling.
What you will learn
On completion, delegates will be able to:
- Design a data warehouse as a series of interlocking star schema data marts according to dimensional modelling design principles.
- Resolve many types of user requirements including tracking history, aggregate tables, and recursive relationships.