Microsoft BI Certification Course | MSBI Training | Edureka

Microsoft BI Certification Training

Preview this course

Edureka's 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. 
11K+ satisfied learners Read Reviews
Why should you take Microsoft BI Certification course ?

MSBI is a Leader in 2018 Gartner Magic Quadrant for Business Intelligence & Analytics Platforms ( 9th Consecutive Year )

​According to PCMag, Microsoft BI caters to most of the top requirements from an impressive BI tool

The median salary for a Microsoft BI job role is $102K -

Instructor-led Microsoft BI Certification live online classes

16 th  Feb
Sat & Sun(5 Weeks) Weekend Batch Timings : 10:00 AM - 01:00 PM (EST)
Sold Out
22 nd  Mar
Fri & Sat (5 Weeks) Weekend Batch Timings : 09:30 PM - 12:30 AM (EST)
Filling Fast

Course Price

350 389
10% OFF
    Expires in
  • 00 D
  • 00 H
  • 00 M
  • 00 S

EMI starts at 4498 / month.

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. 


  • 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

  • Understand Data Warehousing Concepts
  • Understand ETL Concepts
  • Understand Business Intelligence Concepts
  • Install SQL server

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.

  • 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

  • Understand SSIS Concepts
  • Understand Control flow and Dataflow

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


  • 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

  • Understand various transformations
  • Understand their usage in business use-cases

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.


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

Hands On/Demo:
  • Create Event Handling Task
  • Parameterize a package

  • Understand Event Handling
  • Understand Package Security in SSIS

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.


  • 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

  • Understand Custom Code
  • Learn Package Configuration
  • Understand Deployment Models

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.

  • 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

  • Understand SSAS Concepts
  • Learn Data Modelling Concepts
  • Design Dimension and Measure Groups
  • Import Data in SSAS from various data sources

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. 


  • 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

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

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.


  • SSRS Features
  • Reporting Services Architecture & Lifecycle
  • Report Parameters and Multi-Valued
  • Cascaded Parameters
  • Types of Reports: Parameterized, Linked, Snapshot, Cached, Ad hoc, Clickthrough, Drillthrough, Subreports
  • 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

  • Understand SSRS Concepts
  • Understand various types of Reports
  • Export Reports to different Formats

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.


  • 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

  • Understand Web Portal
  • Configure Data Source Security
  • Develop SSRS report using MDX

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.


  • 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

  • Implement scenarios using SSIS, SSAS and MDX
Like the curriculum? Enroll Now
Structure your learning and get a certificate to prove it.

Edureka's Microsoft BI Certification Course is designed to provide insights into different tools in Microsoft BI Suite (SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services). Companies are looking for expertise in SSIS, SSAS & SSRS concepts. This Edureka's course will give you the practical knowledge of Data Warehouse concepts and how these tools help in developing a robust end-to-end BI solution using the Microsoft BI Suite.

Edureka's  MSBI training is designed to make you a certified Business Intelligence Analyst by providing you rich hands-on training on Microsoft's business intelligence tool. This course is the stepping stone towards your Analyst journey by work on various industrial projects.

Business Intelligence is one of the accelerating and most promising fields in considering all the technologies available in the IT market today. In order to take benefit of these opportunities, you need a structured training with an updated curriculum as per current industry requirements and best practices.

Besides strong theoretical understanding, you need to work on various real-life BI projects using different Microsoft BI tools and concepts as a part of solution strategy.

Additionally, you need the advice of an expert who is currently working in the industry tackling real-life Analytics challenges.

After the completion of MSBI Training at Edureka, you will be able to:
  • Discuss DW concepts including ETL and Multidimensional modelling
  • Implement end-to-end ETL system using SQL Server Integration Services
  • Create Cubes and administer them in SSAS
  • Create multiple types of reports and visualizations using SSRS
  • Discuss the concepts and need for ad-hoc reports
  • Load data using MDX and DAX queries
  • Integrate various BI tools to build a complete BI solution

There are no prerequisites for edureka's MSBI training. Basic understanding of RDBMS would be an advantage.

MSBI Training will hone your skills by offering you comprehensive knowledge of Business Intelligence, and the required hands-on experience for solving real-time industry-based projects. 

During MSBI Certification course you will be trained by our expert instructors to:
  • Analyze data sets and software programs and you'd be able to see connections and make meaning out of the data that are presented
  • Implement ETL system using SQL server integration services
  • Model, process and visualize your data in a lucid manner
  • Design enterprise-level reporting, and modifying data warehousing
  • Get expert in Microsoft's tools like report builder, power view
  • Integrate various BI tools to build a complete BI solution
  • Solve Industry based Project on Analytics

The market for Analytics is growing across the world and this strong growth pattern translates into a great opportunity for all the IT Professionals. Our MSBI Training helps you to grab this opportunity and accelerate your career. It is best suited for:

Software or Analytics professionals having background/experience of any RDBMS, ETL, OLAP or reporting tools are the key beneficiaries of this MSBI course.

Edureka’s Microsoft Business Intelligence Analyst Certificate Holders work at 1000s of companies like

5000 Total number of reviews
4.57 Aggregate review score
80% Course completion rate
No data found
Woubamlak Wassie

I have taken two courses from Edureka Online Training. The classes were Fantastic. Training materials were well organized and provided good case studies. Instructors were extremely professional and pleasant to learn from. I would strongly recommend Edureka to any other student.

Rajesh Rao link SSIS Developer , TEKSystem

I took the MSBI course with Edureka recently. It was fantastic for several reasons: 1. The class outline and structure were clearly laid out. You knew where you were headed. 2. The class ALWAYS began and ended on time. For me this was very important due to time zone issues. Additionally you did not experience any surprise cancellations in the last minute. This was unlike what I had experienced elsewhere. 3. The quality of the sessions in terms of the sound and video was also very good. 4. The instructor knew MSBI in and out and also clearly explained things. I especially liked the fact that he also took great pains to see to it that our questions were answered. I think this is the best part of these classes. Being able to ask questions and clear up things. 5. One other thing - Edureka is great in that if you have an issue or question about anything related to them - not just the class you are taking - then you can raise a ticket - and Edureka is very prompt in getting back to you. You don't sit around twiddling your thumbs waiting for an answer. I will be taking Edureka classes again in the future and definitely recommend them.


The MSBI course curriculum is really good and the training was awesome.Interactive learning classes, knowledgeable instructors and great support staff is the added advantage for people.

Amit Vij link HRSSC HRIS Senior Advisor at DLA Piper

I am not a big fan of online courses and also opted for class room based training sessions in past. Out of surprise, I had a WoW factor when I attended first session of my MSBI course with Edureka. Presentation - Check, Faculty - Check, Voice Clarity - Check, Course Content - Check, Course Schedule and Breaks - Check, Revisting Past Modules - Awesome with a big check. I like the way classes were organised and faculty was far above beyond expectations. I will recommend Edureka to everyone and will personally revisit them for my future learnings.

Shaitender Singh link Assistant Manager - IT at WNS Global Services

I had a awesome experience with Eduerka, started my learning with MSBI and got comprehensive understanding of each topics, would definitely like to give more than 5 stars to Edureka and I'm am planning to take Big data and spark course. Keep doing the good work and keep rocking

Gnana Sekhar Vangara link Technology Lead at

Edureka Data science course provided me a very good mixture of theoretical and practical training. The training course helped me in all areas that I was previously unclear about, especially concepts like Machine learning and Mahout. The training was very informative and practical. LMS pre recorded sessions and assignmemts were very good as there is a lot of information in them that will help me in my job. The trainer was able to explain difficult to understand subjects in simple terms. Edureka is my teaching GURU now...Thanks EDUREKA and all the best.

Sunil Bhardwaj link Solution Architect

The courses are too good.These courses are providing live instruction so-that any time , we can play and learn. Also it provides labs so-that we can practice and implement live.I have joined AWS , R and Tableau which provides me great learning as they provides previous videos sessions , which provides great help before going in main session.Edureka courses provides lifetime access for the courses so that any time we can start playback session and learn and if any problem in any courses then we can also take live class without giving any fees further.

Loved reviews? Enroll Now
Structure your learning and get a certificate to prove it.
The requirement for this course is a system with Intel i3 processor or above, minimum 4GB RAM and 20 GB HDD Storage.
For the practical work in our Microsoft BI Certification, we will help you set-up the Microsoft BI development environment. The detailed step by step installation guides will be present in your LMS which will help you to install and set-up the required environment. In case you come across any doubt, the 24*7 support team will promptly assist you.
Edureka MSBI Training includes multiple real-time, industry-based projects, which will hone your skills as per current industry standards and prepare you for the upcoming Business Intelligence roles. At the end of the course, you will work on a Live Project which will be an end to end Business Intelligence case study involving SSIS, SSAS, SSRS and MDX.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes. Weekend Class: 10 sessions of 3 hours each.
Weekday Class: 15 sessions of 2 hours each.

Real-life Case Studies

Live project based on any of the selected use cases, involving the implementation of the various Microsoft BI concepts.


Each class will be followed by practical assignments which will aggregate to a minimum of 20 hours.

Lifetime Access

You get lifetime access to the Learning Management System (LMS) where presentations, quizzes, installation guide & class recordings are there.

24 x 7 Expert Support

We have a 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.


Towards the end of the course, you will be working on a project. Edureka certifies you as a "Microsoft Business Intelligence Analyst" based on the project.


We have a community forum for all our customers that further facilitates learning through peer interaction and knowledge sharing.
"You will never miss a lecture at Edureka! You can choose either of the two options:
  • View the recorded session of the class available in your LMS.
  • You can attend the missed session, in any other live batch."

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You can give us a CALL at +91 88808 62004/1800 275 9730 (US Tollfree Number) OR email at

For payments done using credit cards, to make this a No Cost EMI offer, the interest amount will be discounted from the price of the course. Your card will be charged for the course price minus the discounted interest. The total amount you will pay to the bank (excluding GST) will be equal to the price of the course. The bank will charge GST on the interest amount. For payments done using Razor Pay EMI, the price will not be discounted upfront. Instead, you will not be charged any interest for a No Cost EMI offer.
Be future ready. Start learning
Structure your learning and get a certificate to prove it.

Checkout our Business Intelligence Masters Program

Business Intelligence Masters Program makes you proficient in tools and systems used by Business Intelligence Professionals. It includes in-depth training on Data Warehousing and BI, Teradata, Informatica, Microsoft BI and Tableau. The curriculum has been determined by extensive research on 5000+ job descriptions across the globe.

Explore Business Intelligence Masters Program
Business Intelligence Masters Program
You are here