All Brands   >   IT Technical   >   Business Intelligence   >   Data Warehouse Design

CMDBID: 44810 | Course Code: | Duration: 3 Days
Overview >

Data warehousing has evolved into a unique and key component of IT strategy for many organisations. Dimensional modelling is the proven technique for developing understandable, high-performance data warehouses and data marts.

This course introduces data warehouses, demonstrates the techniques involved in developing dimensional models and shows how these models fit in to the process of building data warehouses. All techniques are illustrated by real world examples drawn from a range of industries.

After taking this course, students will be able to:

  • Define the constituent parts of a data warehouse.
  • State the limitations of classic entity-relationship models in data warehouse design.
  • State the strengths of dimensional models and understand how such models are used in the development of data warehouses and data marts.
  • Gather relevant requirements and place these requirements into a proper context for use in dimensional model development.
  • Develop appropriate dimensional models using the approach given in the course.
  • Understand what metadata is and its importance in data warehouse design.
  • Use appropriate techniques in the design of systems to perform the functions of extract, transform and load.
Audience >
Prerequisites >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-24 out of 24
Location
Start Date
Price
New York, United States
9th Nov 2020
$2700
San Francisco, United States
9th Nov 2020
$2700
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
London, United Kingdom
9th Nov 2020
£1300
Berlin, Germany
9th Nov 2020
€2400
Melbourne, Australia
9th Nov 2020
$3900
Sydney, Australia
9th Nov 2020
$3900
Madrid, Spain
9th Nov 2020
€2400
Bath, United Kingdom
17th Nov 2020
£1300
LVC, United States
23rd Nov 2020
$2700
LVC, United Kingdom
23rd Nov 2020
£1300
LVC, Australia
23rd Nov 2020
$3900
LVC, Germany
23rd Nov 2020
€2400
LVC, France
23rd Nov 2020
€2400
LVC, United States
23rd Nov 2020
$2700
LVC, United States
23rd Nov 2020
$2700
LVC, Australia
23rd Nov 2020
$3900
LVC, Australia
23rd Nov 2020
$3900
LVC, Spain
23rd Nov 2020
€2400
LVC, Italy
23rd Nov 2020
€2400
ONSITE, United States
Onsite
£1300

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