Dimensional Modeling for Data Warehouse ProjectsCourse: DWMODEL
Duration: 5 Days
Level: II
Course Summary
This course provides participants with the skills necessary to analyze and design a successful data warehouse using multi-dimensional data modeling techniques and proven industry best practices. The design concepts for the course will include works by Bill Inmon, Stefano Rizzi, and Ralph Kimballs. Financial examples and workshops addressing the students projects are included in the course. The course also discusses additional industry-wide best practices concerning Dimensional Modeling and Star Schemas. The instructor will include material from previous consulting engagements. The class can optionally use data modeling software such as CA Erwin. Topics Covered In This Course
Introduction
Dimensional Modeling Primer
Starting the Design
Fact table considerations
Dimension Considerations
Other Dimension Considerations
Accounting
Financial Services
Web Considerations
Other Data Warehouse Project Considerations
Workshops
What You Can Expect
At the end of this course, delegates will be able to:
Who Should Take This Course
This course is designed for individuals who are technical staff, team leaders and project managers who need to understand how to design a data warehouse using multi-dimensional data modeling techniques. Recommended Prerequisites
Participants should have at least some experience with any relational database management system. Training Style
Instructor led with 50% lecture and 50% lab. Related Courses
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year. You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details. |
|
|||||||||||||||||||||||||||||||||||||||||
Can't find the course you want? Call us at 800.533.3893, or email us at info@verhoef.com |
||||||||||||||||||||||||||||||||||||||||||