Dimensional modelling is an integral part of any BI (Business Intelligence) system and can be used within the data warehouse and/or the data marts. This 3 day course assumes no prior knowledge of dimensional modelling. It starts by discussing what a data warehouse is, how they are designed and the part that dimensional modelling plays.

The vitally important process of requirement gathering is covered and delegates are shown how to:

Collect the analytical requirements of the business users
Create a logical model of these requirements
Create a star schema from those requirements

The relational and dimensional models are compared and contrasted, with particular reference to the current Kimball/Inmon debate.

The course then looks in great detail at dimensional modelling itself and finally ends with a summary of possible BI architectures.

Target Audience

This course is aimed at people who work in the BI area. It is suitable for business analysts who need to understand the analytical requirements and turn those requirements into a model. It is also suitable for the IT professional who will turn those models into working OLAP (On-Line Analytical Processing) structures. Please note, delegates who have previously attended QADMBIS - Developing A Modern Business Intelligence System should not attend this course.

We can organize this training at your preferred date and location. Contact Us!

Prerequisites

There are no specific pre-requisites for this course but delegates who have previously attended QADMBIS - 'Developing A Modern Business Intelligence System' should not attend this course due to the duplication of content.

What You Will Learn

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

Understand the pros and cons of relational and dimensional modelling
Design dimensional models from analytical business requirements
Produce effective star schemas that deliver the analytical capabilities that the business requires

Training Outline

Introduction to designing dimensional data warehouses
Gathering analytical requirements
Measures and dimensions
Logical (Sun) modelling
Physical modelling - the star schema
Facts and dimensions
Attributes and hierarchies
Time dimensions
Synonym dimensions
Surrogate keys
Additive, semi-additive and non-additive measures
Degenerate dimensions
Slowly changing dimensions
Bridge tables
Mini dimensions
Hot-swappable dimensions
Multi-valued dimensions
Parent child dimensions
Bitmap dimensions
Ragged hierarchies
Unbalanced hierarchies
Step dimensions
First and last analysis
Optimizing fact table performance
Indexing in star schema
Aggregation
MOLAP
HOLAP
ROLAP

Why Choose Us

Experience Dimensional Modelling through Bilginç IT Academy's live and interactive virtual classroom environment, accessible from your home, office, or any location. Connect with expert trainers in real time and bring the energy of classroom learning into the digital experience.

Live Instructor-Led Sessions: Join scheduled training sessions with your instructor and fellow delegates in real time.
Interactive Learning Experience: Take part in discussions, practical exercises, group activities, and Q&A sessions throughout the course.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's long-standing experience in delivering professional training since 1995.
Flexible and Scalable Delivery: Access live virtual classrooms worldwide with flexible planning options for individual and corporate training needs.

Experience Dimensional Modelling in a focused classroom environment designed for high engagement and effective learning. Bilginç IT Academy's carefully selected training venues provide a professional setting where delegates can interact directly with expert trainers and peers.

Experienced Trainers: Learn from specialists with extensive field experience and real-world knowledge.
Professional Training Venues: Attend courses in comfortable, well-equipped classrooms designed to support effective learning.
Focused Classroom Experience: Benefit from limited class sizes that encourage discussion, interaction, and personalized support.
Quality-Driven Learning: Develop practical skills through structured, up-to-date, and professionally designed training content.

Meet your team's training needs with Bilginç IT Academy's onsite Dimensional Modelling solution, delivered at your office or preferred location. Align your team's development with your business goals through a training experience tailored to your organization.

Tailored Course Content: Adapt the training program to your organization's projects, team structure, and specific business requirements.
Time and Cost Efficiency: Reduce travel, accommodation, and operational costs while maximizing the value of your training investment.
Team-Focused Learning: Help your employees develop around the same knowledge base and strengthen collaboration across your organization.
Simplified Planning and Tracking: Manage the training process, participant development, and organizational requirements with greater control.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Dimensional Modelling Training

Target Audience

Prerequisites

What You Will Learn

Training Outline

Why Choose Us