Data Warehouse Design (DW)

Roundtable Description

This one-day event describes why you may need a data warehouse and how to go about designing one. It explains the fundamentals of Data Warehouse Design and looks at the differences between conventional ER modelling and dimensional modelling.

Our experienced consultants will also discuss the common issues around planning and implementing a data warehouse and how to overcome them.

Audience

This is aimed at people with a good understanding of database technologies and covers dimensional modelling and best practice implementation methods.

Prerequisite Knowledge, Experience and Education

Basic ER modeling
SQL
Basic Programming Fundamentals

Delivery & Duration

This instructor-led offering is a one day event.

Subject Matter

Data Modelling

Dimensional Modelling
Event-State Modelling
Star and Snowflake Schemas
Typical dimensions and hierarchies

Managing a data warehouse project

Coping with changing requirements - the agile approach
Data Quality - the main risk to a data warehouse project
Satisfying business rules

Additional Education

'Empower the Decision Maker' roundtables. This is a series of intense one day events aimed at senior decision makers to enable them to better understand how they can benefit and implement solutions to enable them to make more use and gain more competitive advantage from their data resources.

These 'Decision Maker' events are supplemented by our 'Implementing BI for Benefit' series of roundtables. These are non product focused, but relate more to a technical audience, responsible for delivery of the solution. The emphasis is around using approaches and tools to provide quick, cost effective results to provide real business benefit.

For more information, or to register, please contact us on 0845 124 9495 or fill in the simple enquiry form below and we will be in touch: