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-4 out of 4
Start Date
Bath, United Kingdom
3 Days
24th May 2021
Bath, United Kingdom
3 Days
26th Jul 2021
Bath, United Kingdom
3 Days
15th Nov 2021
ONSITE, United States
3 Days

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