MS BI Online Training

MSBI (ssis,ssas,ssrs) Online Training Course

MicroSoft – BI

(SSIS, SSAS, SSRS)

SSIS–Objectives:

• Plan data transfer and staging solutions for an ETL operation.
• Plan an SSIS Solution
• Design and implement data flows
• Incorporate logging, error handling, and reliability into a package.
• Optimize an SSIS solution
• Deploy and operate an SSIS solution.

SSAS – Objectives:

• Describe how SQL Sever Analysis Service can be used to implement Analytical Solutions.
• Create multidimensional analysis solutions with SQL Server Analysis Services.
• Implement dimensions in an Analysis Services Solution.
• Implement measure and measure group in an Analysis Services Solution.
• Query a multidimensional Analysis Service Solution.
• Customize an Analysis Service cube.
• Deploy and Secure an Analysis Service database.
• Maintain a multidimensional Analysis Service Solution.
• Implement a Data Mining Solution.

SSRS – Objectives:

• Describe SQL Server Reporting Services and its Components.
• Create a Reporting Services report.
• Enhance a Reporting Service report.
• Create and manipulate data sets.
• Use report models to implement reporting for business users.
• Configure report publishing and execution settings.
• Implementing subscription for reports.
• Implement custom Reporting Services applications.