Dimensional Modelling Training

  • Learn via: Online Instructor-Led / Classroom Based / Onsite
  • Duration: 3 Days
  • Level: Fundamentals
  • Price: From €2,685+VAT
  • Upcoming Date:
  • UK Based Global Training Provider

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!

HAVELSAN
ASELSAN
PepsiCo Türkiye
JTI TÜTÜN ÜRÜNLERİ SANAYİ A.Ş.
ING Bank
DHL
MASTERCARD
Huawei
TotalEnergies
Mercedes-Benz Türk A.Ş.
Goodyear
FORD OTOMOTIV SANAYI A.S.
3M COMPANY
Schneider Electric
Central Bank of Azerbaijan
BP Petrolleri
Procter & Gamble (P&G)
Qatar Foundation
Bank Of China
GlaxoSmithKline (GSK)
MORGAN STANLEY & CO Inc
Novo Nordisk
DEUTSCHE BANK
Azerbaycan Cumhuriyeti Emek ve Ahalinin Sosyal Güvenliği Bakanlığı
ACCENTURE

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. 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 with flexible scheduling to meet your professional needs through our globally available virtual classrooms.

Immerse yourself in our most sought-after learning style for Dimensional Modelling Training. Our hand-picked classroom venues 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. 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.
Contact us for more detail about our trainings and for all other enquiries!

Dimensional Modelling Training Course Schedule

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

We can organize this training at your preferred date and location.
15 April 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
22 May 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
09 June 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
13 June 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
22 June 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
23 June 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
03 July 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT
01 August 2026 (3 Days)
Istanbul, Ankara, London
€2,685 +VAT

Our IT training and professional development services reach a global audience, transcending geographical boundaries through advanced digital learning platforms and strategic international hubs. We specialize in delivering world-class curriculum across continents, ensuring that no matter where you are located, you have access to the latest industry certifications and technical expertise. By partnering with global technology leaders and academic institutions, we provide a unified learning experience that meets the demands of a diverse, international workforce. Our commitment to global excellence ensures that professionals in every time zone can master the digital skills required to lead, innovate, and thrive in the ever-evolving global technology landscape.

Bilginç IT Academy All Rights Reserved

By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.