All Brands   >   IT Technical   >   Databases   >   Dimensional Modelling

CMDBID: 43248 | Course Code: QADM | Duration: 3 Days
Overview >

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 >
Skills Gained >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-6 out of 6
Location
Duration
Start Date
Price
Toronto, Canada
3 Days
14th Dec 2021
$2700
Calgary, Canada
3 Days
14th Dec 2021
$2700
Vancouver, Canada
3 Days
14th Dec 2021
$2700
Montreal, Canada
3 Days
14th Dec 2021
$2700
Ottawa, Canada
3 Days
14th Dec 2021
$2700
ONSITE, United States
3 Days
Onsite
£2415

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes