Microsoft BI Certification Online Training

Course Dx Microsoft BI Certification Training is curated by industry professionals will help you master MSBI concepts such as SSIS, SSRS and SSAS using SQL Server 2016 and SQL Server Data tools 2015. Microsoft BI Certification Course is designed to provide insights into different tools in Microsoft BI Suite like SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services.

Choose The Training That's Best For You

LIVE ONLINE TRAINING

  • High-quality content created by industry experts
  • Lifetime access to high-quality self-paced learning and live online class recordings
  • Flexible, affordable options
  • Get complete certification guidance
  • 24×7 assistance and support
  • Attend a MSBI Online Course free demo before signing up

CORPORATE TRAINING

  • Self-Paced / Live Online training options
  • Flexible, affordable options
  • Learn as per full day schedule and/or flexible timings
  • Customize your own course content based on your project requirements
  • Get complete certification guidance
  • 24×7 assistance and support

MSBI Online Training Upcoming Batches

Weekday

20,SEP 2020
Time: 7:00PM IST

Weekend

20,SEP 2020
Time: 7:00PM IST

FastTrack

20,SEP 2020
Time: 7:00PM IST

Don’t find suitable time ?

₹ 18500

SELF-PACED LEARNING

  • 25 hours high-quality video
  • 2 projects
  • 20 downloadable resource
  • Lifetime access and 24×7 support
  • Access on your computer or mobile

1
Introduction to Data Warehousing and MSBI

Learning Objectives: In this module, you will understand the various concepts of Data Warehousing. You will learn why we perform ETL operations before loading data to the Data warehouse. You will get a brief introduction to Business Intelligence.

Topics:

  • Fundamental concepts of Data Warehousing
  • Concepts of Dimensions, Measures, Metadata, Schemas
  • Data Marts and Design approaches
  • Normalization and Denormalization and Schema types
  • Online Analytical Processing and Transactional Processing concepts
  • OLAP Cube
  • Types of Slowly Changing Dimensions
  • Explain ETL process and various tasks involved in it
  • Discuss Business Intelligence concepts
  • How BI works with data-warehouse
  • Describe MSBI as One stop Solution
  • Hands On/Demo:
  • Install SQL Server
  • Install SQL Server Data Tools
  • Create small ETL Tasks

Skills:

  • Understand Data Warehousing Concepts
  • Understand ETL Concepts
  • Understand Business Intelligence Concepts
  • Install SQL server Introduction to Data Warehousing and MSBI

Learning Objectives: In this module, you will understand the various concepts of Data Warehousing. You will learn why we perform ETL operations before loading data to the Data warehouse. You will get a brief introduction to Business Intelligence.

Topics:

  • Fundamental concepts of Data Warehousing
  • Concepts of Dimensions, Measures, Metadata, Schemas
  • Data Marts and Design approaches
  • Normalization and Denormalization and Schema types
  • Online Analytical Processing and Transactional Processing concepts
  • OLAP Cube
  • Types of Slowly Changing Dimensions
  • Explain ETL process and various tasks involved in it
  • Discuss Business Intelligence concepts
  • How BI works with data-warehouse
  • Describe MSBI as One stop Solution
  • Hands On/Demo:
  • Install SQL Server
  • Install SQL Server Data Tools
  • Create small ETL Tasks

Skills:

  • Understand Data Warehousing Concepts
  • Understand ETL Concepts
  • Understand Business Intelligence Concepts
  • Install SQL server
2
Introduction to SSIS

Learning Objectives: In this module, you will understand the need for an Integration tool and its significance in the industry. You will learn the importance of SSIS as an integration tool and get a high-level view of the overall architecture.

Topics:

  • Understand the MSBI Architecture, Import and Export wizard
  • Understand SSIS Architecture
  • Control Flow & its Components (Tasks, Containers, Precedence Constraints)
  • Data Flow & its Components (Source and Destination Connections, different types of Transformations)
  • Scenarios by combining Control Flow and Data Flow components
  • System Variables and User-defined variables

Hands On/Demo:

  • Create tasks and Control Flow task using SSIS
  • Create a data flow task to aggregate the records
  • Create a control flow task to create an index and run the tasks

Skills:

  • Understand SSIS Concepts
  • Understand Control flow and Dataflow
3
Transformations and Use-Cases

Learning Objectives: In this module, you will be able to differentiate between various transformations and understand their usage in various business use-cases.

Topics:

  • Data Conversion transformation
  • Multicast transformation
  • Union all transformation
  • Conditional Split transformation
  • Merge and Merge Join transformation
  • Lookup transformation
  • Cached Lookup transformation
  • Foreach loop and use-cases
  • Advancing Execute SQL Task with Object return type and type of Outputs usage
  • Bulk-insert task
  • Archival process using dynamic variables and FST

Hands On/Demo:

  • Conditional Split transformation
  • Use Foreach loop to repeat Data Flow Task for multiple files
  • Use Foreach loop and File System Task for Data Archival
  • Use Slowly Changing Dimension to insert a new record and update a record

Skills:

  • Understand various transformations
  • Understand their usage in business use-cases
4
Transactions and Event Handling

Learning Objectives: In this module, you will understand how the objects of the core SSIS workflow work and interact with each other to help in security and other key functions.

Topics:

  • Parameters, Event Handling
  • Transaction Options, Check Points, Logging options, Log Provider
  • Configure Error Output and On Error event
  • Package Security: Package Protection Levels

Hands On/Demo:

  • Create Event Handling Task
  • Parameterize a package

Skills:

  • Understand Event Handling
  • Understand Package Security in SSIS
5
SSIS (Configuration, Deployment and Scheduling)

Learning Objectives: In this module, you will learn advanced SSIS programming features, which will help in handling custom requirements using .Net code. In addition, you will learn to configure and deploy SSIS projects.

Topics:

  • Script Component, Package Configurations (5 types)
  • Debugging & Troubleshooting
  • Executing packages – DTExec and DTExecUI
  • Package Deployment
  • Package Scheduling using SQL Agent
  • Understand Package Performance Tuning
  • Learn SSIS Best Practices
  • Package Performance Tuning
  • SSIS Best Practices

Hands On/Demo:

  • Implement custom code using Script Task
  • Create a control flow task consisting of a Script task to send email

Skills:

  • Understand Custom Code
  • Learn Package Configuration
  • Understand Deployment Models
6
SSAS Cube Design

Learning Objectives: This module will help you in understanding SQL Server Analysis Services Overview and its Architecture. It also covers various types of SSAS models along with designing dimensions and measure groups. You will also learn about SSAS Administration with prime focus on deployment and processing.

Topics:

  • Introduction to SASS
  • It’s Architecture
  • Features of SSAS
  • Modelling in SSAS
  • Tabular Model and Multidimensional Model
  • Data Sources, Data Source Views
  • Identify the Fact and Dimensions
  • Designing Dimensions
  • Dimension Hierarchies
  • Designing Measure Groups
  • Attribute Relationships
  • Storage Modes: MOLAP, ROLAP, HOLAP, Partitions

Hands On/Demo:

  • Create dimensions and hierarchies
  • Define a cube
  • Create Data Source and Data Source Views

Skills:

  • Understand SSAS Concepts
  • Learn Data Modelling Concepts
  • Design Dimension and Measure Groups
  • Import Data in SSAS from various data sources
7
SSAS Deployment and MDX, DAX

Learning Objectives: In this module, you will learn the basics of MDX & DAX and get to know the step by step approach of basic SSAS Performance Tuning and Troubleshooting. You will also learn the concepts of Ad-hoc Reporting and the creation of a report against SSAS as a data source.

Topics:

  • SSAS Deployment
  • Methods of database deployment
  • Named Calculations and Named queries
  • Aggregation, KPIs, Actions, Perspectives, Translations
  • Cube Processing
  • Different Processing Options
  • Explain MDX and DAX Queries
  • Loading Data into DW using SSIS, MDX queries, DAX Queries
  • Performance Optimization of cube and Dimension, Best Practices
  • Schedule the Cube processing

Hands On/Demo:

  • Retrieve tabular data using DAX
  • Schedule the Cube processing
  • Retrieve data from a Cube using MDX query

Skills:

  • Understand SSAS Deployment and Cube Processing
  • Learn MDX and DAX Queries
  • Explain Performance Optimization
8
SSRS Reporting

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 the server where the reports are deployed.

Topic:

  • SSRS Features
  • Reporting Services Architecture & Lifecycle
  • Report Parameters and Multi-Valued
  • Cascaded Parameters
  • Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drill through, Sub reports
  • Creating Groups, Filters, Expressions Sort and Interactive Sort, Alternate Row Colors, Repeating Row Headers and Column Headers
  • Describe Mobile report publisher
  • Exporting Reports to different formats

Hands On/Demo:

  • Create grouping in table
  • Use interactive sort on a table
  • Create a report based on Annual Sales
  • Export report as a PDF

Skills:

  • Understand SSRS Concepts
  • Understand various types of Reports
  • Export Reports to different Formats
9
SSRS: Web Portal

Learning Objectives: In this module, you will learn about different kinds of reports and their functionalities along with best practices to be followed. You will also learn about various SSRS Administrative activities.

Topics:

  • Web Portal
  • Deploying Reports and Data Sources
  • Securing Access to Reports (Role based Security)
  • Aspects of security
  • Data Source Security, Caching Report and Snapshot Report
  • Report Subscriptions: Standard, Data-Driven
  • Managing Subscriptions, Ad-Hoc Reporting with Report Builder
  • Integration of Power BI with SSRS

Hands On/Demo:

  • Assign roles to a group or a user
  • Create a Linked report
  • Enable the users from various locations to access the same project
  • Deploy and access the project using Web Portal

Skills:

  • Understand Web Portal
  • Configure Data Source Security
  • Develop SSRS report using MDX
10
Integration of SSIS, SSAS and SSRS

Learning Objectives: In this module, you will understand how MSBI ecosystem components work together in a Business Intelligence environment to solve the Organizational data problems. This module covers end to end implementation from Data Retrieval --> Data Transformation --> Data Loading into DWH --> Data Modeling --> Report Delivery.

Topics:

  • End to End Business Intelligence Business Scenario involving SSIS, SSAS, SSRS and MDX.
  • MS BI Best Practices

Hands On/Demo:

  • Case study to implement a scenario using SSIS, SSAS, SSRS and MDX

Skills:

  • Implement scenarios using SSIS, SSAS and MDX
Yes, you can schedule your Microsoft BI Training online in all Time Zones. We also offer training sessions with the US, UK, Australia, & Europe based trainers on Weekends and Weekdays respectively.
Yes, our trainer will provide the server access to the MSBI Training Online aspirants. You will get practical and live classes that will cover all your course needs with a Project explanation support.
Our MSBI trainer is a certified consultant with a good experience. Currently, he is working on a project in this technology and he has an industry experience also.
Yes, we will help you in getting MSBI training certification easily with good knowledge and you would also get the certificate.
Our expert MSBI trainer will explain to you the subject and project work on the software itself in live mode. Each batch of students is a software team within our online training program and project work is given to them. After the completion of the project, your training will come to end. So, Students can feel the real-time IT company experience during their online training, where our trainer is a Team Leader for them.

Be the first to add a review.

Please, login to leave a review
Add to Wishlist
Lectures: 10