Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
TDWI's Data Modeling course provides data modelers with techniques for developing sustainable normalized and dimensional data warehouse and data mart models on relational DBMS platforms. The course pursues a top-down approach, which begins with a business view that depicts the major subject areas and domains of the enterprise. The models at this level are then transformed into logical models, and finally into physical models.
LEARNING OBJECTIVES
After taking this course, you will be able to:
- Distinguish differences in modeling techniques for business transactions, business events, and business metrics
- Understand different types of data and their implications
- Apply business context to modeling activities
- Describe the role of business requirements in BI data modeling
- Explain the role of source data analysis in data modeling
- Use normalized and dimensional modeling techniques for data warehouse analysis and design
- Understand the roles of generalization and abstraction in data warehouse design
- Define the roles of identity and hierarchy management in master data management
- Explain how time-variant data is represented in data models
- Understand implementation and optimization considerations for warehousing data stores
WHO WILL BENEFIT
The course is designed for practitioners familiar with traditional data modeling techniques who need to develop the data structures for business intelligence data stores. The course presumes a basic knowledge of BI architectures and traditional data modeling.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
How to Access The Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Jonathan Geiger, CBIP, is an executive vice president with Intelligent Solutions, Inc. Jonathan has been involved in many Corporate Information Factory projects in several industries. He presents frequently at national and international conferences, has written more than 60 articles, and is a co-author of three books: Data Stores, Data Warehousing, and the Zachman Framework: Managing Enterprise Knowledge; Building the Customer-Centric Enterprise; and Mastering Data Warehouse Design.
TDWI is the leading provider of education and research for business intelligence, analytics, and data management professionals. TDWI’s vendor-neutral training is led by experienced practitioners, and has earned a world-wide reputation for being comprehensive, practical, and actionable.