Microsoft BI Training

COURSE ID

 GES-MSBI
DURATION 52 hrs
DELIVERY METHOD 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.

COURSE OBJECTIVES

After the completion of MSBI Training you will be able to:

Understand DW concepts including ETL and Multidimensional modeling
Install and configure end-end MSBI system
Implement end-to-end ETL system using SQL Server Integration Services
Gain insight on Multidimensional model and its importance
Create multiple types of reports and visualizations using SSRS/PowerView etc.
Understand the concept and need for ad-hoc reports
Apply Microsoft tools like Report Builder, Power View
Give an end-to-end picture how Microsoft BI suites various tools work
Integrate various BI tools to build a complete BI solution

1.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

  • Need for MSBI Process and Workflow Management
  • Control Flow and Data flow Tasks
  • Data Modeling Requirements
  • ETL with non-SQL Server sources
  • Variables and Dynamic SSIS Configurations
  • Advanced Control Flow Tasks
  • Error Handling and Event Handling
  • Incremental Data Load and Buffer Management
  • SSIS Transactions, Isolation Levels and Checkpoints
  • SCD, DQS and SCRIPT Operations
  • Custom SSIS Components (CHECKSUM) and Data Profiling
  • SSIS Catalog (SQL Server 2012) versus MSDB Deployments
  • SSIS Deployment Wizard and ISPAC Management
  • SSIS Tuning and Issue based Troubleshooting tips

    •  

    2.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

  • Reporting life Cycle and SSRS Workflow
  • Report Filters and Dynamic Parameters
  • Chart Based Reports
  • List and Rectangle Reports
  • Sub Reports and Linked Reports
  • Gauges Reports and Dundas Report Control Operations
  • Cube Reports with MDX and DAX
  • Report Tuning and Schedules
  • Report Caching, Refresh and Snapshot Options
  • Data Driven Subscriptions
  • Managing Reporting Services
  • Report builder Applications
  • Security Management
  • Report Delivery and Hosting
  • SSRS Tuning and Issue based Troubleshooting tips
    • 3.SQL Server Analysis Services-SSAS

    Intermediate SSAS

    Cube Storage and Aggregation

    Beginning MDX

    Intermediate MDX

    SSAS Administration

    Introduction to SSAS Clients

    popular courses
    softwarebug
    QA view

    microsoft-net
    .net view

    java
    Java view

    oracle
    Oracle view
    vmware
    Sap view

    Recent comments

    Mike V

    "Good course with great content, presentations, real time examples and knowledgeable Instructor... Recommended to give a try and one of the best training's i ever had.."

    Alex

    "Woked with the Global ERP Solutions team they have serviced as outstanding job. I recommend to Global ERP Solutions as a technology driven complete solution for current market driven companies."

    Vivek

    "Thanks for giving excellent training for MSBI Course."