Data Warehousing and Business Intelligence Reporting

Course Number:  724-DJ
Recommended Duration:  3 or 4 days

Intended Audience
This course is designed for technical staff, team leaders and project managers who need to understand how to design a data warehouse and access it via popular BI Reporting Tools.

Course Overview
This course provides participants with the skills necessary to design a data warehouse.  The course discusses Dimensional Modeling and Star Schemas.  The design of Staging Area, Fact and Dimension tables are featured.  The Oracle 10G database is used in this course in several student workshops.  A brief SQL refresher, the use of Oracle DB Functions and Oracle Materialized Views are covered.  If the customer has the licenses to Business Objects or Cognos, the development of BI reports running against the classroom data warehouse can be included.

Objectives
At the end of this course, student will be able to:

• Design and create a Data Warehouse to meet key business objectives
• Build and load the Data Warehouse
• Design and implement BI reports using Business Objects/Cognos

Prerequisites
Participants should have some experience with relational database management systems.  The database system featured in this course is Oracle 10G.

Topics

Data Warehouse design

• Data Warehousing concepts

• Designing BI reports and key process indicator

Data Warehouse Build

• Building the staging area

• Designing the dimension and fact tables

• Creating tables, indexes, functions and materialized views

• SQL review

• Extract/transform/load

• Designing transformations using SQL

• Data quality and auditing

• Implementation readiness

• BI reporting and Business Objects

• Creating Universes using Designer

• Creating reports using Web Intelligence

• Running reports in InfoView

• BI reporting with Cognos

• Creating Frameworks using Framework Manager

• Creating Reports Query Studio and Report Studio