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