Published on HiTech Institute (http://www.htinstitute.com)

Home > Datawarehousing & Business Intelligence Tools

Datawarehousing & Business Intelligence Tools

Vendor: 
Other [1]
Subject: 
Accounting/Finance [2]
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

    Business Analysis (BA)

    Business Analysis (IIBA) Courses
    About IIBA
    CBAP Certification
    CCBA Certification
    Business Analysis Certification Benefits
    Business Analysis Training at HiTech Institute

    -->

    Source URL: http://www.htinstitute.com/courses/datawarehousing-business-intelligence-tools

    Links:
    [1] http://www.htinstitute.com/vendors/other
    [2] http://www.htinstitute.com/htnteam/accounting/finance