Course Overview
Dimensional modeling has become the technique of choice in the Data Warehousing arena for the data designs used for Business Intelligence and analytical reports. This workshop introduces dimensional modeling from a non-technical perspective.

The course will show you how to use dimensional modeling to provide the customer with understandable models for analytical reporting. You will discover the difference between Fact and Dimension tables, and be able to properly allocate the appropriate information to each in the design. The course also covers how to create and use an enterprise data warehouse bus matrix as a multi-faceted planning and communication tool. You will also explore using common dimensions to facilitate information re-use and sharing. Read More.

Who Should Attend
This workshop is for business and data analysts and application developers responsible for the analysis and design of any component of business intelligence reporting applications. Business professionals and managers needing to understand how these techniques fit into enterprise information and reporting architecture will also find the content useful..

Benefits and Learning Objectives
The business analyst, modeler or manager participating in this workshop will be equipped with an understanding of how and why to apply the respective design tips as well as guidelines to create an understandable and well performing dimensional design. You will complete the seminar knowing how to:

• Use dimensional modeling to provide the customer with understandable models for analytical reporting
• Make important dimensional design decisions and know the supporting principles and reasons
• Create and use an enterprise data warehouse bus matrix as a multi-faceted planning and communication tool
• Use common dimensions to facilitate information re-use and sharing
• Apply various techniques for handling changes in dimension data
• Get the full course outline.

Plus, receive valuable takeaways. The workshop manual supplies full step-by-step instructions for creating good models along with valuable concept explanations and techniques used within the course.

Some comments from past participants:

"Wow! Value for anyone working with data.”
"Class covers general and specific concepts very well.”
"Good instruction. Learned a great deal of additional concepts not learned on the job."

Get information about the Instructor : Wayne Little

Read about other courses led by this instructor:

• Data & Reporting Architecture Overview

Register early and Save $100. Benefit from 'early-bird' pricing on courses.

October 29-30  Vancouver, BC             $1095 CAD   Register

Read information on payment, cancellation policy and course locations.