Classroom Instructor-led training (CILT) |
Online Instructor-led training ( OILT)
|COURSE OVERVIEW||Microsoft BI Certification Course is designed to provide insights on different tools in Microsoft BI (SQL Server Integration Services, SQL Server Reporting Services).|
Get expertise in SSIS & SSRS concepts and master them.
The course will give you the practical knowledge on Data Warehouse concepts and how these tools help in developing a robust end-to-end BI solution using the Microsoft BI Suite.
|PREREQUISITES||The pre-requisite for this MSBI Training is basic understanding of RDBMS.|
After the completion of MSBI Training you will be able to:
Understand DW concepts including ETL and Multidimensional modeling
SQL Server Integration Service- SSIS
Learning Objectives - In this module, you will understand the need for an Integration tool and its significance in real world. You will learn the importance of SSIS as an integration tool and get a birds-eye-view of the overall architecture.
Topics - Understand the Need of Business Intelligence Understand the MSBI Architecture, Import and Export wizard, Overview of SSIS Package Designer & Environment Installation of SQL Server and SSDT- BI
SQL Server Reporting Services-SSRS
Learning Objectives - In this module, you will understand Reporting Services, its Architecture and how to configure it. You will also learn about the environment where reports are created and also about server where the reports are deployed.
Topics - Reporting Services Architecture & Lifecycle, Report Parameters and MultiValued, Cascading Drop down Parameters, Types of Reports: Table, Matrix, Sub Report, Chart Report (Bar, Pie, Line), Drill-Down Report, Drill Through Report, Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers, Exporting Reports to different formats