This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     

Advanced SQL Server Data Warehouse Design

1st June 2015 - 2nd June 2015

Who is it for?

This course is for BI consultants and architects who are building a new data warehouse or maintaining an existing one, and who already have some experience in data warehouse design and dimensional modelling.

What you will learn

On this course Thomas will demystify some of the “hand waving” that is often thrown around about data warehouse modelling. You will get into the modelling tricks that drive performance, agility, maintainability and optimal compression.   The method Thomas teaches is specifically designed to make the best use of modern hardware and keep you close to the actual implementation details; the stuff that truly matters when you get your hands dirty with data modelling. He will cover the following topics:

  • Introducing Data Models and Agile Development
  • Logical data models: What are they good for?
  • Comparing Inmon and Kimball
  • Why normalisation is bad for data warehouses, and what you can do about it
  • Demystifying meta data: Meta Models and auto generated ETL
  • Understanding modern hardware: Co-Located data in SMP and MPP systems
  • Choosing between column and row stores
  • Key handling, master data and mapping layers
  • Tracking history in the warehouse
  • Handling changing user requirements
  • High speed data loading – and reloading
  • Big Data and Data Warehouses

It is expected that you are familiar with the basics of dimensional modelling as described in Ralph Kimball’s book: “The Data Warehouse Toolkit: The Complete Guide to Dimensional Modelling”. Some basic familiarity with 3rd normal form data modelling and/or UML is an advantage.

Even if you subscribe to another modelling technique than the one described in the course, the course will help you understand why some models work and others fail. You will also learn what types of modifications you need to make in the Dimensional model to counter the typical critique of this modelling approach for large environments.

Key Benefits

This course will take your skill in data warehouse modelling to the next level, allowing you to handle very large datasets and to build data model which provide high query performance in both SMP and MPP environments.

Cost: £1200 (until June 30 2014), 1299 (from July 1 2014) +VAT


Formerly of the SQL CAT Team, Thomas Kejser is now a consultant and entrepreneur. Building multi-terabyte- sized data warehouses, setting up OLTP systems for extreme scale and tuning world record data movement speed are some of Thomas’ recent achievements.



MSE Meeting Rooms
103a Oxford Street

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

decoration decoration decoration decoration