Duration:

Two day classroom instruction. Note: This is a combination of the Business Intelligence Introduction and Data Warehousing Introduction courses.

Prerequisite Education or Experience

None assumed.

Course Outline:

Section 0: Introductions

Section 1: What is Business Intelligence, What is Data Warehousing?

  • Brief History of Accessing, Reporting And Analyzing Data
  • Data to Information Lifecycle
  • Definition of Business Intelligence (BI)
  • Definition of Data Warehousing
  • Definition of Corporate Performance Management (CPM)

Section 2: Where are Business Intelligence and Data Warehousing being used today

  • Business Drivers For BI
  • Business and IT Drivers For DW
  • Applications that use BI And DW
  • Data Shadow Systems
  • Industry terminology

Section 3: Business Intelligence and Data Warehousing - The Architectures

  • The Four Architectures
  • How do business intelligence and data warehousing fit together?

Section 4: Information Architecture - BI applications and usage

  • Business applications of BI
  • BI Categories - Reporting to Analytics
  • OLAP Architectures
  • Classifying BI users

Section 5: Data Integration

  • Overview
  • Data modeling concepts
  • Data Integration Framework (DIF)

Section 6: Data Architecture

  • Processes
    • Transforming data to information
    • Process management


      •  

  • Data Stores
    • Data Warehouse, Data Marts, Operational Data Stores, Cubes
  • Architectures
    • Data staging options
    • Implementation choices
  • Standards
  • Tools
  • Resources & Skills

Section 7: Technology Architecture

  • Overview
  • Data Integration
  • Business Intelligence
  • Databases
  • Deployment & Operational Tools

Section 8: Product Architecture

Note: Brief overview to position vendors within market. Not intended to evaluate or endorse vendors.

  • Major data warehouse and BI vendors
  • Market positioning

Section 9: Culture, Politics and Organization

  • Overview
  • Sponsorship and Governance
  • Program Organization and Management
  • Project Organization and Management
  • Project Methodologies

Section 10: Industry Trends

  • Overall Software Industry
  • Enterprise Applications
  • Data Integration
  • Business Intelligence

Section 11: Best Practice Overview

  • Data Integration
  • Business Intelligence

Section 12: Conclusions

  • Highlights
  • References and Resources