MSBI

SSRS – SQL Server Reporting Services

• Understanding Architecture and Introduction to SQL Server Reporting Services
• Installing reporting services
• Designing and Implementation of Reporting Services Projects
• Creating Custom Assembly and configuring with SSRS
• Use report models to implement reporting for business users.
• Configure report publishing and execution settings.
• Implementing subscription for reports

SSIS – SQL Server Integration Services

• Introduction of DW Concepts
• Architecture and Introduction to SQL Server Integration Services
• Import and Export wizard
• Building first package
• Components
• Extracting and Loading Data
• Using Dataflow Transformations
• Control Flow
• Scripting Task
• Debugging
• Managing Package Execution
• Debugging and Managing Package Execution
• Detecting and Handling Processing Errors
• Securing and Deploying SSIS Packages