This course is designed to teach attendees the fundamentals of business dimensional modeling. The basic principles are shared using real-world scenarios. This course is not intended to provide the complete skills necessary to develop dimensional models from scratch but does provide a solid foundation of what dimensional models are and how they work. This practical background can be used by members of the business community to improve communication of their requirements and increase their understanding and participation throughout the project.
The course ends by putting the modeling effort into the proper context. Techniques for successfully gathering business requirements are shared. A quick overview of what is needed to build the database and deliver the data to the business is also provided. Several design exercises are included to reinforce the concepts presented in class. These team exercises prepare the students to apply these concepts on their own projects.
1. Why Data Warehousing?
2. Introduction to Dimensional Modeling Concepts
3. Exercise: Identifying Dimensions and Facts
4. Designing Dimensions
5. Designing Facts
6. Exercise: Developing the Business Dimensional Model
7. Gathering Business Requirements
8. More about Dimensions
9. More about Facts
10. Putting the Model in the Right Context