Microsoft Data Warehouse and Business Intelligence

Microsoft Data Warehouse and Business Intelligence is an intensive course to present out very deep level, hands-on knowlege and experience on what every SQL Server 2005 user needs to know to create business intelligence with SSAS, SSIS, SSRS, and other BI tools.

The course not only covers Microsoft BI but also builds essential concepts and knowledge on Data Warehouse, BI Methodology, and Data Mining.

Career Opportunities


  • SQL Server, Data Warehouse, ETL Developer
  • SQL DBA
  • Software architect and designer

Duties & Responsibilities


  • Business Intelligence Introduction
    • Business Intelligence Road
    • Data Warehouse Basic Concept
    • Data Warehousing Part1-introduction
  • Business Intelligence Methodology 1
    • Data Integration - ETL
    • OLAP Modeling - Part 1
    • OLAP Modeling - Part 2
  • Business Intelligence Methodology 2
    • Data Mining
    • DataWarehousing Part2 - Datawarehouse LifeCycle
    • DataWarehousing Part3 - DataWarehouse Maintainance and optimizing

  • Understand Microsoft SQL SERVER 2005 Database
    • Relational Database Basic Concept
    • T-SQL Introduction
    • T-SQL Advanced and Stored Procedure

  • Admin Microsoft SQL SERVER 2005 Database
    • SQL Server 2005 Overview
    • Basic Operations & Working with SQL Server
    • Administering a SQL Server System

  • SQL SERVER 2005 BI Essential
    • SSIS 2005 Foundation
    • SSAS 2005 Foundation
    • SSRS 2005 Foundation

 

Request More Information Now
Free English Class
spacer
Academy of Learning Toronto Information Technology Programs: Microsoft Data Warehouse and Business Intelligence
Your Success
is Our Priority