Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us
 

Call: +1 416-623-9493 or +1 416-333-3717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

 
Software Quality Assurance Training Business Analysis Training Microsoft BI Training Azure Training Cyber Security SAP Training AWS Data Engineer & Data Analytics Training DevOps Training PMP Training BI Development Tableau Training Informatica Training JAVA Training MICROSOFT .NET Training Power BI Training Big Data & Hadoop Training Scrum Training ORACLE Admin Training

 
 
 
 
 
 
Microsoft BI Training Full Course
     
  COURSE ID   GES-MSBIF
  DURATION   39hrs
  Course Fee   $2100+HST
  DELIVERY METHOD   Class-room and online
  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)and Power BI

  AUDIENCE  
  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

  • You will also learn how to identify the maturity level of your BI solution, and articulate critical elements of your solution to maximize your organizations business opportunities. The facilitator will work with you through a case study in this hands-on training and you will be able to re-apply the template as soon as you are back at work.

  COURSE OUTLINE  

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


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


Introducing Power BI


  • Creation of Report

  • Publishing to CLOUD

  • DAX Introduction

  • Basic Calculation using DAX

  • Measures on Category AXIS

  • DATA Transformations

  • Designing a DASHBOARD

  • Advanced VISUALIZATIONS

  • Advanced Features of POWER BI CLOUD SERVICE

  • Advanced Features of POWER BI DESKTOP CLIENT

  • POWER BI PROJECT 1

  • POWER BI PROJECT 2

  • DATA Types

  • Logical Functions

  • Error Handling

  • Context

  • Context Interactions

  • Context over Relations

  • SCHEMA Relations

  • Table Functions

  • Time Intelligence Functions

  • Rankings

  • GATEWAY and Schedule Refresh

  • SANDDANCE and PERCENTILE

  • Row Level Security

  • POWERBI QUIZ

  •   SOFTWARE   Please contact us for Demo class and Batch Schedules
      CONTACT INFORMATION5  

    Mississauga: 1065 Canadian Place, Suite 201, Mississauga ON L4W 0C2
    Scarborough: 2401 Eglinton Ave E, Suite 304, Scarborough(Eglinton & Kennedy) ON M1K 2M5
    Montreal: 279 Rue Sherbrooke O, Suite 209, Montreal, QC H2X 1Y2 PH: +1-514-664-3900

    Phone: +1 416-623-9493 or +1 416-333-3717

    E-mail: training@globalerp.ca