Send to a Friend
 
Content to send

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.

Objective

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

Share with others
Please provide the following information
Your Name
Your Email Address
Recipient Emails
Message

Can't Read? Click to Generate New Code
Enter the verification code shown above into the text box below