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

Format

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 (0) 203 745 9790. 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.