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

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 39
Location
Start Date
Price
London, United Kingdom
5th Oct 2020
£2415
LVC, United Kingdom
19th Oct 2020
£2415
LVC, United States
19th Oct 2020
$2700
LVC, Australia
19th Oct 2020
$3900
LVC, New Zealand
19th Oct 2020
$3900
LVC, New Zealand
19th Oct 2020
$3900
LVC, France
19th Oct 2020
€2400
LVC, Germany
19th Oct 2020
€2400
LVC, Spain
19th Oct 2020
€2400
LVC, Italy
19th Oct 2020
€2400
LVC, Australia
19th Oct 2020
$3900
LVC, Australia
19th Oct 2020
$3900
LVC, United States
19th Oct 2020
$2700
LVC, United States
19th Oct 2020
$2700
New York, United States
9th Nov 2020
$2700
Wellington, New Zealand
9th Nov 2020
$3900
Auckland, New Zealand
9th Nov 2020
$3900
San Francisco, United States
9th Nov 2020
$2700
Sydney, Australia
9th Nov 2020
$3900
Canberra, Australia
9th Nov 2020
$3900
Paris, France
9th Nov 2020
€2400
Milan, Italy
9th Nov 2020
€2400
Chicago, United States
9th Nov 2020
$2700
Berlin, Germany
9th Nov 2020
€2400
Melbourne, Australia
9th Nov 2020
$3900

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