Course Duration in Hours
120
Course Category
Request Call Back
Course Details
Introduction to MS - BI:
What is MS-BI
BI/DWH life cycle
ETL and OLAP Tools
Features of MS-BI
Introduction to SSIS:
Package
Tasks
SSIS installation
SSIS Architecture
SSIS Wizard
Control Flow Tasks
Data Flow Task
Variables and Expressions
Errors and Debugging SSIS
Data viewers
Deployment
Manually Executing SSIS Package
Scheduling SSIS Package
Importing and Exporting Packages
Monitoring and Optimizing Packages
Introduction to SQL Server Reporting Services:
Reporting Services Architecture
Reporting Services Terminology
Creating Reports:
Deconstructing Reporting Services
Shared Data Sources
Creating Reports from Scratch
Calculations and Formatting:
Creating Expressions
Using the Global Collection
Grouping and Sorting:
Creating Groups and Calculating Totals and Percentages
Interactive Sorting, Creating Drill-Down Reports
Report Parameters
Creating Report Parameters
Creating Drop-Down Parameters
Multi-Valued Parameters
Debugging Parameter Issues
Creating Matrix Reports and Charts:
Creating a Basic Matrix Report
Matrix Subtotals
Creating a Basic Chart
