Datawarehousing & Business Intelligence Tools

Printer-friendly version
Vendor: 
Other
Subject: 
Accounting/Finance
Overview: 

This instructor-led course exposes the core features and definitions essential to successful business intelligence programs to achieve maximum business value from data warehousing.

Course Contents: 

Introduction to Business Intelligence

  • Definitions and Concepts
  • Business Intelligence Framework
  • Kimball Lifecycle Approach
  • Program/Project Planning and Management
  • Business Requirements for BI
  • Roles and Responsabilities
  • Relational and Dimensional Modeling
  • Exercise: Translate requirements into bus matrix

    Mastering Data Warehouse Modeling

  • Data Warehouse Data Model
  • Step-by-Step Data Warehousing
  • Market Research: Data Modeling Tools
  • Developing the Dimensional Modeling
  • Exercise: Design review to identify common
  • Common Dimensions
  • Exercise: Business Case Scenario

    BI & DW Architecture & Processes

  • Warehousing Definitions
  • Warehousing Data Stores
  • Data`Warehousing Architecture
  • Market Research: ETL Modeling Tools
  • Data`Warehousing Process
  • ETL Workflow
  • Exercise: Business Architecture with Data Architecture tool

    BI Infraestructure

  • Data Profiling Management`
  • Quality Management
  • Exercise: Business Architecture
  • Development Methodologies
  • Market Research: BI Tools
  • Metadata Management
  • Quality Management
  • Exercise: Designing with BI tool
  • BI/DW Best Practices
  • Test
    • Audience: 

    This course is design to appeal to all major roles on a DW/BI project, from project managers to DBAs to data modelers to application developers. It's for anyone new to data warehousing who wants to learn how to do it, or who has been through a project and wants to learn how to do it right.

    Duration: 
    30 hours
    For more information on Datawarehousing & Business Intelligence Tools please feel free to contact us online or call us at 416-513-1535.