Successful Data Warehousing - How to Design the Data Architecture to make BI more actionable - Foundation Level - Agilis

Successful Data Warehousing – How to Design the Data Architecture to make BI more actionable – Foundation Level


 1.1  Course Profile

How to Design the Data Architecture to make BI more actionable

This one-day course is designed for business & IT managers who are considering a Business Intelligence/Reporting solution, project managers involved in the implementation of a Data Warehouse and also anyone who requires an understanding of how and why Data Warehouses are used and the basic strategies for success. It will ultimately help you avoid the most common pitfalls and teach you the five guiding principles of designing, building and implementing a data warehouse that really will drive your business forward.

1.2.        Skills acquired by delegates

Delegates will:

  • 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 requirements

1.3.        Duration of the course

1 Day

1.4.        Pre-requisites

A basic understanding of relational database concepts

1.5.        Type of courseware

Customised

 


Top