MSBI stands for Microsoft Business Intelligence. This powerful suite is composed of tools which helps in providing best solutions for Business Intelligence and Data Mining Queries. This tool uses Visual studio along with SQL server. It empower users to gain access to accurate and up-to-date information for better decision making in an organization. It offers different tools for different processes which are required in Business Intelligence (BI) solutions.
msbi Course Modules
Course Agenda
- SQL Server 2008R2 Integration Services (SSIS)
|
- SQL Server 2008R2 Analysis Services (SSAS)
|
- SQL Server 2008R2 Reporting Services (SSRS)
|
|
Introduction to Data Flow
- Data Flow Overview
- Data Sources
|
- Data Flow Transformations
- Data Destinations
|
|
|
Data Sources
- Excel Source
- Flat File Source
|
|
|
|
Data Flow Transformations
- Aggregate Transformation
- Audit Transformation
- Character Map Transformation
- Conditional Split Transformation
- Copy Column Transformation
|
- Derived Column Transformation
- Data Conversion Transformation
- Multicast Transformation
- OLE DB Command Transformation
- Union All Transformation
|
- Percentage Sampling Transformation
- Row Count Transformation
- Sort Transformation
|
|
Advanced Data Flow
- Lookup Transformation
- Merge Transformation
- Merge Join Transformation
|
- Slowly Changing Dimension Transformation
- Pivot Transformation
|
- Import Transformation
- Unpivot Transformation
- Export Transformation
|
|
Data Flow Destinations
- Data Reader Destination
- Excel Destination
|
|
|
|
Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Bulk Insert Task
- The File System Task
|
- The FTP Task
- The Send Mail Task
- Bulk Insert Task
- Data Flow Task
- Execute DTS 2000 Package Task
|
- Execute Package Task
- Execute Process Task
- Web Service Task
- XML Task
|
|
Variables and Configurations
- Variables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
|
- Using variables in data flow
- Using variables to pass information between packages
- Property expressions
|
- Configuration Overview
- Configuration options
- Configuration discipline
|
|
Debugging, Error Handling and Logging
- SSIS debugging overview
- Breakpoints in SSIS
- Data Flow: Error data flow
|
- Control Flow: The On Error event handler
|
- Configuring Package Logging
- Built-in log providers
|
|
Extending SSIS through Custom Code – Scripting
- Introduction to SSIS scripting
- The SSIS script editor
|
- The SSIS object model
- Script in Control flow: The Script Task
|
- Script in Data flow: The Script Component
- Introduction to SSIS component development
|
|
SSIS Package Deployment
- Configurations and deployment
- The deployment utility
|
- Deployment options
- Deployment security
|
- Executing packages – DTExec and DTExecUI
|
|