Microsoft BI

$389.00 $252.85

Our Microsoft BI online training helps you master MSBI concepts like ETL, SSIS, SSAS and SSRS using SQL Server 2014 and SQL Server Data tools 2013. This training will also help you earn an MSBI certification

Choose TimeZone:

About The Course
Microsoft BI course is designed to provide insights on different tools in Microsoft Suite (SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services). It also gives the practical knowledge on DW concepts and how these tools help in developing a robust end-to-end BI solution.

Course Objectives
After the completion of Microsoft BI course at Edureka, you will be able to: 

1. Understand DW concepts including ETL and Multidimensional modelling 
2. Install and configure end-end MSBI system 
3. Implement end-to-end ETL system using SQL Server Integration Services 
4. Gain insight on Multidimensional model and its importance 
5. Create Cubes and administer them in SSAS 
6. Create multiple types of reports and visualizations using SSRS/PowerView etc. 
7. Understand the concept and need for ad-hoc reports 
8. Apply Microsoft tools like Report Builder, Power View 
9. Give an end-to-end picture how Microsoft BI suites various tools work 
10. Integrate various BI tools to build a complete BI solution

Who should go for this course?
This course is designed for professionals aspiring to make a career in Business Intelligence. 
Software or Analytics professionals having background/experience of any RDBMS, ETL, OLAP or reporting tools are the key beneficiaries of this course.

The pre-requisite for this course is basic understanding of RDBMS.

Why learn MSBI?
As we move from experience and intuition based decision making to factual decision making, it is increasingly important to capture data and store it in a way that allows us to make smarter decisions. This is where Data warehouse/Business Intelligence comes into picture. There is a huge demand for Business Intelligence professionals and this course acts as a foundation which opens the door to a variety of opportunities in Business Intelligence space. Though there are many vendors providing BI tools, very few of them provide end-end BI suite and huge customer base. Microsoft stands as leader with its user-friendly and cost effective Business Intelligence suite helping customers to get a 360 degree view of their businesses.
Edureka Certification Process:
At the end of your course, you will work on a real time Project. You will receive a Problem Statement along with a dataset to work.

Once you are successfully through with the project (reviewed by an expert), you will be awarded a certificate with a performance based grading.

If your project is not approved in 1st attempt, you can take additional assistance to understand the concepts better and reattempt the Project free of cost.

We partnered with Edureka. We provide up to 35% discount from the actual course fee.

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

1. MSBI and SSIS Architecture Overview
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 

2. SSIS Control Flow and Data Flow
Learning Objectives - In this module, you will understand the SSIS designing environment and gain in-depth knowledge of the SSIS Control flow & Data flow.

Topics - 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

3. SSIS (Transactions, Error 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, restartablity and other key functions.

Topics - Parameters, Expressions, Event Handling, Transaction Options, CheckPoints, Logging options (5 types), Configure Error Output and OnError event, Package Security: Package Protection Levels

4. 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. Also you will learn the way to configure and deploy SSIS projects.

Topics - Custom code using Script Task, Script Component, Package Configurations (5 types), Debugging & Troubleshooting, Executing packages – DTExec and DTExecUI, Package Deployment, Package Scheduling using SQL Agent

5. SSIS Advance Topics & DWH Basics
Learning Objectives -  In this module you will learn SSIS advanced concepts such as SSIS Performance Tuning & its Best Practices. You will also learn Introduction to Datawarehouse and its Architecture, Loading Data into DW using SSIS as well as Introduction to Dimensional Modeling. This will be base for understanding SSAS features. 

Topics -  Package Performance Tuning, SSIS Best Practices, Need for DW & Business Intelligence, OLTP vs. OLAP, DW Architecture, Dimensional Modeling, Schemas: Star, Snowflake

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 - Tabular Model and Multidimensional Model, Data Sources, Data Source Views, Identify the Fact and Dimensions, Named Calculation and Named Queries, Designing Dimensions, Dimension Hierarchies, Designing Measure Groups, Dimension Usage with Measure Group,Attribute Relationships, Storage Modes: MOLAP, ROLAP, HOLAP, Partitions, Aggregations,KPIs, Actions, Translations and Perspectives

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

Topics -  SSAS Deployment and Cube Processing, Different Processing Options, Loading Data into DW using SSIS, MDX queries, DAX Queries, Performance Optimization of cube and Dimension, Best Practices, 
Schedule the Cube processing

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

9. SSRS: Report Manager
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 -  Report Manager, Deploying Reports and Data Sources, Securing Access to Reports (Role based Security), Data Source Security, Caching Report and Snapshot Report, Report Subscriptions: Standard, Data-Driven 
Managing Subscriptions,Ad-Hoc Reporting with Report Builder,Develop SSRS Report using MDX

10. Putting the Pieces Together
Learning Objectives -  In this module you will understand how MSBI ecosystem components work together in a Business Intelligence environment to solve the Organizations 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 case study involving SSIS, SSAS, SSRS and MDX.

On Demand Course
  • Contct Us, If you want to Enroll!
  • +1 309 733 4646

Course Features:

10 live classes of 3 hrs each by Industry practitioners

Personal assistance/installation guides for setting up the required environment for Assignments / Projects

Live project based on designing and developing an end-to-end BI solution using MSBI Suites (SSIS,SSAS,SSRS)

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Edureka certified 'MSBI Expert' based on your project performance, reviewed by our expert panel

Need Help?
  • +1 309 733 4646

Related Courses