MSBI Online Training Overview
MSBI Online Course Duration
- 40 Hours (Daily 1 Hour Per Session)
MSBI Course Content
Introduction to SQL Server Integration Services
- SSIS Package Architecture Overview
- Development and Management Tools
- The Import and Export Wizard
Guided tour of Business Intelligence Development Studio [SSDT]
Introduction to Data Flow
- Data Flow Overview
- Data Sources
- Data Destinations
- Data Flow Transformations
Data Sources
- Excel Source
- Flat File Source
- OLE DB 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
- Percentage Sampling Transformation
- Row Count Transformation
- Sort Transformation
- Union All Transformation
Advanced Data Flow
- Lookup Transformation
- Merge Transformation
- Merge Join Transformation
- Slowly Changing Dimension Transformation
- Pivot Transformation
- Export Transformation
- Import Transformation
- Unpivot Transformation
Data Flow Destinations
- Excel Destination
- Flat File Destination
- OLE DB Destination
Introduction to Control Flow
- Control Flow Overview
- Precedence Constraints
- The Execute SQL Task
- The Send Mail Task
- Bulk Insert Task
- Data Flow Task
- Execute Package Task
Advanced Control Flow
- For Each Loop Container
- Sequence Container
Variables and Configurations
- Variables Overview
- Variable scope
- SSIS system variables
- Using variables in control flow
- Using variables in data flow
- Configuration Overview
- Configuration options
- Configuration discipline
Debugging, Error Handling and Logging
- SSIS debugging overview
- Control Flow: The On Error event handler
- Data Flow: Error data flow
- Configuring Package Logging
- Built-in log providers
SSIS Package Deployment
- Configurations and deployment
- The deployment utility
- Deployment options
SSIS Package Management
- Managing packages with SQL Server Management Studio
- Scheduling packages with SQL Server Agent
SQL Server 2008R2 / 2012 Analysis Services
Intermediate SSAS
- Creating KPIs
- Creating Perspectives
- Creating Translations
- Creating Actions
- Advanced SSAS
- Working with Multiple Fact Tables
- Using Advanced Dimension Types
- Working with Changing Dimensions
- Using the Business Intelligence Wizard
Cube Storage and Aggregation
- Basic Storage: MOLAP
- Customized Aggregations
- Advanced Storage: MOLAP, HOLAP, or ROLAP
- Using Partitions: Relational or SSAS
- Cube and Dimensions Processing Options
Beginning MDX
- Understanding MDX
- About Members, Tuples, and Sets
- Common MDX Functions Explained
- New or Updated MDX Functions or Keywords
Intermediate MDX
- Understanding the Calculations Sub tab
- Adding Calculated Members
- Adding MDX Scripts
- Adding Named Sets
Introduction to SSAS Clients
- Using Excel 2007 Pivot Tables
- Using SQL Server Reporting Services
SQL Server 2008R2 / 2012 Reporting Services
SQL Server Reporting Services (SSRS) Architecture
- Report types and formats
- SSRS Web Services
- Report Server
- Report Builder
- Model Designer
- Data sources: SQL Server, Oracle, OLE DB
Authoring Reports
Creating basic reports
- Tabular
- List
- Matrix
- Chart
- Constructing data sources and Datasets
- Inserting a data region, fields and images
Grouping and sorting data
- Grouping to multiple levels
- Sorting the results
- Employing aggregate functions
Implementing Parameters and Filters
Building parameters into reports
- Returning subsets of data with query parameters
- Mapping report parameters to query parameters
- Building cascading report parameters
- Passing parameters to stored procedures
- Exploiting multivalve parameters
Restricting report data with filters
- Enhancing performance with filters
- Filters vs. query parameters
- Localizing tables and queries
Leveraging Advanced Reporting Features
Combining data regions in one report
- Utilizing sequential and nested regions
- Producing master/detail reports