-
About Us

Calendar of Events

By Special Invitation only - Sandhill's one day Dimensional Modeling for Data Warehouse Concepts class - Ottawa

Sandhill Consultants Presents  - By Invitation only  

Our Special one day Dimensional Modeling Concepts Workshop
for Data Warehousing
Sandhill Consultants realize that organizations DBA’s, BA’s and Data Modelers are struggling to apply modeling techniques that effectively translate business requirements into actionable, performance oriented solutions, that meet the information and timely needs of their business users. Often furnished with one of the Kimball or Inmon’s big books and a pat on the back as the toolkit to build solutions, warehouse and data mart developers , modelers and DBA's are left without an methodology or approach in starting these types of projects. 
 
Begin at the beginning:
 
Sandhill Consultants one day work shop is the students’ first step in understanding all there is to know about Dimensional Modeling for building effective Data Warehouses , and how to apply the best techniques.
By the time students finish this one day workshop they will be able to understand and answer questions such as why Dimensional modeling is different from Data Modeling, and how should companies apply Dimensional Modeling techniques in developing modeling solutions
Please mark your calendars:  We are starting to accept registration for this event  which will be held at a training facility  in Ottawa on Monday the 26th of October, from 9:00 am to 5:00 pm. 
This workshop is the first in a series of classes that will teach students not only the fundamentals of Dimensional Modeling for building effective Data Warehousing, but allow students to progress to the next level where they will also learn the skills necessary to analyzes, design, develop and implement a Dimensional Model from re-stated business requirements. This workshop provides the concept necessary to understand what a Dimensional Model is and how it all ties in with various OLAP implementation styles.
Students will learn how to approach Dimensional Modeling for Data Warehousing, by leveraging a combination of case studies, and successive labs on how to analysis the problem from the beginning and beak it down into the following series of easy to understand steps.
·         Part 1 – Define the different types of modeling constructs Multi-dimensional DM Techniques –
·         Part 2 – Identify what a fact table is and how to identify it.
·         Part 3 – Understanding how a Dimensional model grows in complexity
·         Part 4 – Time variant analysis – Explained
·         Part 5 – Putting it all together in a Data Mart Design
    
        This one day event is packed with live examples and many techniques from our years of experience in implementing Dimensional Modeling for Data Warehouse's:  Mark the date in your calendar!, Don't miss this critical dimensional modeling event..
 
To Register for this event, please e-mail Robert.Lutton@sandhillconsultants.com  with your name, company name and the number of folks you would like to have attend this session. Please note that in some cases we may have to limit the number of students per Federal Government department.