Dimensional Modeling for Data Warehouse Projects
Duration: 5 Days
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
Dimensional Modeling Primer
Starting the Design
Fact table considerations
Other Dimension Considerations
Other Data Warehouse Project Considerations
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.
Participants should have at least some experience with any relational database management system.
Instructor led with 50% lecture and 50% lab.
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 [email protected]