Date Days Time
August 16 Sat & Sun
Weekend batch
Filling Fast
8:00 PM to 11:00 PM (IST)
August 22 Sat & Sun
Weekend batch

8:00 PM to 11:00 PM (IST)
August 29 Sat & Sun
Weekend batch

8:00 PM to 11:00 PM (IST)
September 5 Sat & Sun
Weekend batch

8:00 PM to 11:00 PM (IST)

Program Price

$149/- $258/-

40% off limited period offer.

Program Syllabus

  • ● Introduction to ETL
  • ● The main steps involved in the process of ETL
  • ● Extract
  • ● Transform
  • ● Load
  • ● Using a user’s email ID to read a flat file
  • ● Extracting the User ID from email ID
  • ● Loading the data into a database table


  • ● What are Connection Managers?
  • ● Logical presentation of a connection
  • ● Different types of Connection Managers
  • ● Loading the DB faster with OLE DB
  • ● Understanding Bulk Interest
  • ● Working with Excel Connection Managers and troubleshooting the problems


  • ● Learning the process of how new data is written over old data and best practices
  • ● Detail explanation of three types of SCDs –Type1, Type2 and Type3, and their differences


  • ● Discussing the difference between Fuzzy Lookup Transformation and the Lookup Transformation
  • ● We will also discuss the concept of Fuzzy matching


  • ● Error rows configuration
  • ● Package Logging
  • ● Package Defining
  • ● Package Configuration
  • ● Discussing different Constraints
  • ● Understanding Event Handlers


  • Module 1: Introduction to SSRS
  • ● Introduction to SSRS
  • ● Understanding the Architecture of SSRS
  • ● Different Components of SSRS Reporting (Report building tool)
  • ● Discussing the data flow in different components


  • ● Introduction to Matrix and Tablix
  • ● Why and when to use Matrix and Tablix
  • ● Working with Text Box
  • ● Learning about formatting, row/column grouping
  • ● Understanding sorting, formatting, concepts of header, footer, totals, subtotals and page breaks


  • ● What are Parameters?
  • ● Filter and visibility expression
  • ● understanding drill-through and drill-down
  • ● Understanding variables
  • ● Creating Custom code


  • ● Introduction to Matrix and Tablix
  • ● Why and when to use Matrix and Tablix
  • ● Working with Text Box
  • ● Learning about formatting, row/column grouping
  • ● Learn how to build a Dashboard with Sparklines
  • ● Data Bars
  • ● Map Charts
  • ● Gauge Charts and drilling into reports
  • ● Basics of ad hoc reporting
  • ● Indicator and Gauge Chart
  • ● Map Chart
  • ● Report Drilling


  • ● Understanding Report Cache
  • ● Authorization
  • ● Authentication and Report Snapshot
  • ● Learning about Subscriptions and Site Security


  • Module 1: Kick start with SSAS
  • ● Discussing essential basics of SSAS
  • ● Understanding Multi-dimensional analysis
  • ● Architecture of SSAS and its benefits
  • ● Understanding Cube
  • ● Tables and OLAP Databases
  • ● Discussing about the Data Sources
  • ● Working with Dimension Wizard and Dimension Structure
  • ● Attribute, flexible and rigid relationships


  • ● Discussing the Process Dimensions
  • ● Creating the Cube
  • ● The Process database
  • ● Understanding the Cube Structure and browsing in cube
  • ● What are Product and Customer Keys?
  • ● Understanding Column Naming
  • ● Discussing the process of deploying a Cube
  • ● Advanced concepts on creating a report with the Cube


  • ● The Data Dimensions and its benefits
  • ● Discussing the various Relationships
  • ● Performing the Data Partitions and Data Aggregations
  • ● Creating the Cube
  • ● The Process database
  • ● Understanding the Cube Structure and browsing in cube


  • ● Discussing about SSAS Cube
  • ● Different types of Cubes
  • ● Advanced concepts in various cubes and comparing them with Data Warehouse


  • ● Understanding the different operations in Cube
  • ● Advantages of using cube
  • ● Different challenges in Cube
  • ● Different limitations in OLAP Cubes


  • ● Deploying cube with the existing data warehouse capabilities
  • ● Using the above skill for obtaining self-service business intelligence
  • ● Understanding the in-memory analytics of cube
  • ● Discussing how architecture of in-memory analytics work
  • ● Discussing about the in-memory architecture and its advantages


  • ● Logical model schema model used in the cube
  • ● Discussing different attributes and its Hierarchies
  • ● Different key/value pairs
  • ● Understanding Metadata reload, logical keys and role-based dimensions
  • ● Creating role-based dimensions


  • ● Discussing the Measure in Cube
  • ● Analyzing the Measure
  • ● Understanding the relationship between Measure and Measure Group
  • ● Cube features and Dimension usage
  • ● Practical with Cube Measures
  • ● Deploying analytics in Cube
  • ● Working with the Key Performance Indicators
  • ● Deploying actions and drill-through actions on data
  • ● Make partitions in data
  • ● Working on data partitions, aggregations, translations and perspectives


  • ● What is Multidimensional Expression Language or MDX?
  • ● Different MDX queries for retrieving data
  • ● Clause
  • ● Set
  • ● Tuple
  • ● Filter condition
  • ● Discussing MDX hierarchies
  • ● Functions used in MDX
  • ● Ancestor
  • ● Ascendant
  • ● Descendant function
  • ● Performing Data ordering – ascending and descending order


  • ● What is DAX Language?
  • ● Using the EVALUATE and CALCULATE Functions
  • ● Performing Filtering using queries
  • ● Creating Calculated Measures
  • ● Data Analysis with DAX


  • ● Designing a tabular model and publishing it
  • ● Designing relationships in:
  • ● Measures
  • ● Hierarchies
  • ● Partitions
  • ● Perspectives
  • ● Calculated Columns


  • ● Read data using R Server from SAS, Txt, excel formats
  • ● Converting data to XDF format
  • ● Summarizing data
  • ● rxCrossTabs and rxCube
  • ● Extracting quantiles by using rxQuantile
  • ● Visualizing data (rxSummary and rxCube, rxHistogram and rxLinePlot)
  • ● Processing data with rxDataStep
  • ● Performing transforms using functions transformVars and transformEnvir
  • ● Processing text using RML packages Building predictive models with ScaleR
  • ● Performing in-database analytics by using SQL Server
  • ● Analyzing Data with SQL Server Reporting Services


  • You work as BI consultant in an Aqua cultural organization that imports and exports fish products. You are responsible for loading the data from databases to Data Warehouse in proper format. Then you must analyze the data in Data Warehouse to create dimensions and measures to deploy a cube. This cube is then used for creating reports. You have data in flat file and excel. You must cleanse the data and load it to SQL Server. Tasks to be performed are: Create three Data Flow tasks. Load Export table to SQL Server Database named AquaCulture. Load Import table to SQL Server Database named AquaCulture. Load Sales and Discount data to SQL Server Database named AquaCulture. Create a new column to insert month name derived from the TIMEPERIOD column. Sort the data based on year and month fields. Join Geography Description data with the three respective sources to insert the Geography Description field to the target.



Overview

Microsoft Business Intelligence (MSBI) Certification Training

An industry-oriented course designed by experts. Master MSBI from basics to advance with this course filled with real-world projects, assignments, and hands-on.

Key Features

  • 5+ Projects, hands-on, and case studies

  • 36+ Hours of interactive learning

  • 30+ Hours of exercise and project work

  • Lifetime access to LMS

  • Attend as many batches for lifetime

  • 24/7 Technical Support

  • Resume Building

  • Placement Assistance

  • Dedicated Learner Delight Team

About Course

SSIS package, ETL, OLEDB, SQL Server, Azure Analysis Services, SSRS Reports and authenticity, SSAS, SSAS Cube, OLAP Cubes, MDX, DAX language, and more


Freshers, anyone willing to build a career as a MSBI Developer.


No prerequisite. We teach everything from scratch.


Hiring Companies

Source : Indeed

Our Learners Work For

Course Completion Certificate

What People Think

Train Your Employees

We offer flexible and cost-effective group membership for your business, goverment organization.

Connect Now

FAQ

Eduranz offers a unique online MSBI Certification course for professionals who are willing to build a career in this rousing domain. There are many reasons to choose Eduranz: Interactive online instructor-led live classes conducted by SMEs
Personal mentors who will keep a stage track of your progress in the course
A Substantial LMS which allows the users to view their recorded sessions from their live classes along with the self-recorded courses
Real-time exercises, assignments, industry-based use cases and real-world projects
24/7 learning support by the Eduranz’s dedicated tech support team
Large community of learners from across the globe
Industrially as well as globally recognized certificate by Eduranz
Personalized job support, resume and interview preparation

You never miss any lecture at Eduranz, because you will be provided with the recorded sessions of the live class on your LMS within 24 hours and despite that, you can also attend any different live session to cover up the missed topic and ask your doubts from the trainer or you can simply reschedule your batch and get yourself a new batch assigned.

Live Virtual Classes or Online Classes. With online class training, you can access courses via video conferencing from your desktop to increase productivity and reduce work time and personal time.

Eduranz offers a 24/7 request solution and you can pick up your tickets at any time from our dedicated support team. You can use email support for all your questions. If your request is not answered via email, we can also arrange one-on-one discussions with the faculty. You will be glad to know that you can switch to Eduranz support after completing the training. We also don’t limit the number of tickets you can collect when solving questions and doubts.

Yes, Eduranz has a dedicated placement assistance team. Our job assistance program will help you reach the job you have been seeking. Under this program, we help you by building your professional resume and then sharing it across our network companies that we have tie ups with.

Eduranz offers the most up-to-date, relevant and valuable projects in the real world as part of the training program. In this way, you can integrate what you have learned in the real industry. Each training is delivered with various projects where you can thoroughly test your skills, learning and practical knowledge so that you are well prepared for the industry. They work on very interesting projects in the fields of high technology, e-commerce, marketing, sales, networking, banking, insurance and more. After successfully completing your project, your skills will be counted as a result of six months of intensive industry experience.

After completing the Eduranz Training Program along with all real projects, tests and assignments and achieving at least 60% points in the qualification exam; you will receive an industrial recognized certificate by Eduranz. This certification is recognized by companies all across the industry, which includes a lot of top MNCs worldwide.

Our job assistance program will help you reach the job you have been seeking. Under this program, we help you by building your professional resume and then sharing it across our network companies that we have tie ups with. You will also be prepared for interviews through mock sessions. However, Eduranz is not a recruitment agency. We do not guarantee you a job. After we share your profiles with the companies, the further process depends upon your performance and their decision.

All of our highly qualified instructors are industry experts with minimum 10-12 yrs. of relevant IT experience. Each of them underwent a rigorous selection process that included screening profiles, teaching assessments, and training demonstrations.



Career Related Program

Artificial Intelligence Masters

Artificial Intelligence Masters

Read more

Artificial Intelligence Masters
Azure Masters Program

Azure Masters Program

Read more

Azure Masters Program
Cloud & Devops Architect

Cloud & Devops Architect

Read more

Cloud & Devops Architect
Data Science Architect

Data Science Architect

Read more

Data Science Architect
AWS Solutions Architect

AWS Solutions Architect

Read more

AWS Solutions Architect
Data Science with R

Data Science with R

Read more

Data Science with R
Azure 300-301

Azure 300-301

Read more

Azure 300-301
Python

Python

Read more