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 live, interactive learning from the comfort of your home or office with Bilginç IT Academy's Online Instructor-Led Dimensional Modelling Training in United Arab Emirates. Engage directly with expert trainers in a virtual environment that mirrors the energy and schedule of a physical classroom.

Live Sessions: Join scheduled classes with a live instructor and other delegates in real-time.
Interactive Experience: Engage in group activities, hands-on labs, and direct Q&A sessions with your trainer and peers.
Global Expert Trainers: Learn from a handpicked global pool of expert trainers with deep industry experience.
Proven Expertise: Benefit from over 30 years of quality training experience, equipping you with lasting skills for success.
Scalable Delivery: Accessible worldwide, including United Arab Emirates, with flexible scheduling to meet your professional needs.

Immerse yourself in our most sought-after learning style for Dimensional Modelling Training in United Arab Emirates. Our hand-picked classroom venues in United Arab Emirates offer an invaluable human touch, providing a focused and interactive environment for professional growth.

Highly Experienced Trainers: Boost your skills with trainers boasting 10-20+ years of real-world experience.
State-of-the-Art Venues: Learn in high-standard facilities designed to ensure a comfortable and distraction-free experience.
Small Class Sizes: Our limited class sizes foster meaningful discussions and a personalized learning journey.
Best Value: Achieve your certification with high-quality training and competitive pricing.

Streamline your organization's training requirements with Bilginç IT Academy’s Onsite Dimensional Modelling Training in United Arab Emirates. Experience expert-led learning at your own business premises, tailored to your corporate goals.

Tailored Learning Experience: Customize the training content to fit your unique business projects or specific technical needs.
Maximize Training Budget: Eliminate travel and accommodation costs, focusing your entire budget on the training itself.
Team Building Opportunity: Enhance team bonding and collaboration through shared learning experiences in your workspace.
Progress Monitoring: Track and evaluate your employees' progression and performance with relative ease and direct oversight.

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 in United Arab Emirates

Target Audience

Prerequisites

What You Will Learn

Training Outline

Why Choose Us

Online Instructor-Led Training (VILT)

Classroom Based Learning

Onsite / In-House Learning

Dimensional Modelling Training Course in United Arab Emirates Schedule