Microsoft BI (MSBI)

Microsoft Business Intelligence (Data Warehouse, SSIS, SSAS, SSRS, Sharepoint).

The pre-request of this SSRS class is SQL Server 2008 (Or Oracle SQL 101)

Computer requirement: 64-bit, 4GB RAM, Hard Disk > 100GB, 

Course content:

Install MS Windows Server 2008 Enterprise Edition into your LapTop/PC
Install MS SQL Server 2008 Enterprise Edition onto Windows 2008 server on your LapTop/PC

Install MS SharePoint into Windows 2008 Server on your your LapTop/PC 

Introduction to Data Warehouse and Business Intelligence
 -- What is and why Business Intelligence?
 -- Data Warehouse Star Schema
 -- Dimensional Modeling
 -- Fact Table Modeling

SQL Server Integration Services (SSIS)
 -- Understanding SSIS
 -- Using the Control Flow
 -- Using the Data Flow
 -- Solving Common SSIS Scenario
 -- Loading Dimension Table Data
 -- Loading a Fact Table Data
 -- Deploying SSIS Packages

SQL Server Analysis Services (SSAS)
 -- Understanding SSAS
 -- Configuring a Data Source and Data Source View
 -- Using the Cube Wizard
 -- Editing Your Dimension
 -- Editing Your Cube
 -- Adding New Dimensions and Measure Groups
 -- Introduction to Data Mining
 -- Administering the SSAS Instance

SQL Server Reporting Services (SSRS) 
 -- Understanding SSRS
 -- Using Report Wizard
 -- Building a Matrix Report
 -- Building a Report with Parameter
 -- Building Reports on Your Cube
 -- Building a Dashboard
 -- Deploying and Administering SSRS

Sharepoint
 -- Understanding SharePoint for Business Intelligence
 -- Deploying and Using Reporting Services in SharePoint 2010
 -- Building PerformancePoint Dashboards in SharePoint 2010
 -- Deploying and Using Excel Services
 -- Deploying and Using PowerPivot in SharePoint
 -- Managing SharePoint Business Intelligence