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-25 out of 88
Location
Duration
Start Date
Price
LVC, United Kingdom
3 Days
11th Jul 2022
£1800
LVC, Australia
3 Days
15th Aug 2022
$3750
LVC, Australia
3 Days
15th Aug 2022
$3750
LVC, United Kingdom
3 Days
15th Aug 2022
£1800
LVC, France
3 Days
15th Aug 2022
€2100
LVC, Germany
3 Days
15th Aug 2022
€2100
LVC, New Zealand
3 Days
15th Aug 2022
$3750
LVC, New Zealand
3 Days
15th Aug 2022
$3750
LVC, Australia
3 Days
15th Aug 2022
$3750
LVC, United States
3 Days
15th Aug 2022
$2700
LVC, United States
3 Days
15th Aug 2022
$2700
LVC, Italy
3 Days
15th Aug 2022
€2100
LVC, Spain
3 Days
15th Aug 2022
€2100
LVC, United States
3 Days
15th Aug 2022
$2700
Auckland, New Zealand
3 Days
7th Sep 2022
$3750
LVC, Spain
3 Days
7th Sep 2022
€2100
LVC, New Zealand
3 Days
7th Sep 2022
$3750
Melbourne, Australia
3 Days
12th Sep 2022
$3750
San Francisco, United States
3 Days
12th Sep 2022
$2700
Wellington, New Zealand
3 Days
12th Sep 2022
$3750
Sydney, Australia
3 Days
12th Sep 2022
$3750
New York, United States
3 Days
12th Sep 2022
$2700
Canberra, Australia
3 Days
12th Sep 2022
$3750
Madrid, Spain
3 Days
12th Sep 2022
€2100
Paris, France
3 Days
12th Sep 2022
€2100

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