Successful Data warehousing

Course Overview

It's a fact that most Data warehousing projects fail to deliver all the anticipated benefits. Yet for those that do get it right, the returns can be spectacular. If you are considering a Business Intelligence/Reporting solution, then this one-day course will help you avoid the most common pitfalls and teach you the five guiding principles of designing, building and implementing a data warehouse that really does help drive your business forward.

Audience

• Business & IT Managers who are considering a Data Warehousing project
• Project Managers involved in the implementation of a Data Warehouse
• Anyone who requires an understanding of how and why Data Warehouses are used and the basic strategies for success

Skills Gained

• Know the five guiding principles for a successful Data warehousing project
• Know the most common pitfalls in Business Intelligence projects
• Understand the value of a Data Warehouse
• Be able to justify and plan a Data Warehousing project
• Understand the terminology & key concepts associated with dimensional modelling
• Understand what's involved in designing a simple data warehouse
• Understand the methods of populating a Data warehouse
• Understand the importance of Audits and data cleansing
• Understand the importance of maintaining history
• Know the different ways in which data can be accessed & presented to suit User

Prerequisites

A basic understanding of relational database concepts

Follow On Courses

Dimensional Modelling for a Data Warehouse