Would you like to do less ad-hoc data work and ensure your data structure meets best practice?

Would you like more confidence that your data is being modelled correctly?

Would you like more transparency of your data?

Would you like to create a framework for thinking about how you use data?

What’s involved with Red Olive Dimensional Modelling training?

By the end of this course you will be able to:

• Understand the difference between ‘normalised’ and ‘dimensional’ data models
• Understand the Dimensional Modelling concepts described in this course
• Design a ‘Star Schema’ data model based on the example information provided using these Dimensional Modelling principles

We will also touch on:

• Transactional databases and their design
• Reporting or Data Warehouse databases
• Online Analytical Processing (OLAP) systems


This face to face course is led by one of Red Olive’s experienced trainers. Learning is facilitated through individual and group-based exercises. The course is held over two days.

Day One:
• Introduction
• Dimensional Modelling Concepts
• Fact and Dimension Types
• 2 Practical Exercises

Day Two:
• Recap
• Advanced Concepts
• 2 Practical Exercises
• Final ‘real world’ Practical Exercise

NB. It is assumed that you have the following experience:
• Basic knowledge of database systems
• An understanding of the concepts of tables and columns

Cost and how to book

This two day, interactive course costs £800+VAT per person. If you book before the 27th August, there is a 10% discount on your booking. If you book a group of 3+ more people, there is a 20% discount available.

To book on this course, email becky.howe@red-olive.co.uk or ring Red Olive on +44 1256 83 11 00. Payments need to be made in advance to secure the booking.

A buffet lunch and refreshments are included in this cost. Please inform Becky of any dietary requirements when booking.

Attend (16 left)

  • Please enter a number greater than or equal to 1.