- 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
Online
5 Weeks
₹ 17,995 19,995
Quick facts
particular | details | ||
---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekends
|
Course overview
The MSBI Certification Training is a five-week course designed to introduce you to the concept of Business Intelligence and Data Warehousing. The course curriculum will have a brief introduction to different Microsoft BI concepts and business intelligence.
An online instructor-led programme, the course primarily introduces the candidates to MSBI architecture as well as the importance of SSIS as a tool for data integration. The certification course contains lessons on the flow of data and its components as well.
The MSBI Certification Training online course also teaches you to successfully differentiate between different transformations such as Data Conversion, Multicast, Union, and many others. Besides, the certification course also covers how to use Foreach loop as a Hands-on/Demo.
Furthermore, the curriculum includes modules which are specially designed to provide insights into the different tools of the Microsoft BI Suite. Upon completion of the MSBI Certification Training course by Edureka, you will have a practical understanding of data warehousing and how to use MSBI tools efficiently.
The highlights
- 5 weeks course
- Instructor-led Sessions
- Assignments based
- "Microsoft Business Intelligence Analyst" certification
- Community Forum for learner discussions
- Real-life Case Studies
- Lifetime Access to the LMS
- 24x7 Expert Support
Program offerings
- Microsoft bi analyst certification
- Instructor-led sessions
- Live classes
- Real-life case studies
- Online community forum
- 24x7 expert support
Course and certificate fees
Fees information
The MSBI Certification Training course fee has two ways of payment: lump sum and EMI. However, anyone wishing to enroll in the program can avail of variable discounts which are available from time to time.
MSBI Certification Training Fee Structure
Training Option | Fee in INR |
Instructor-led Sessions | Rs. 19,995 |
*No Cost EMI is also available
certificate availability
certificate providing authority
Eligibility criteria
There are no prerequisites for the MSBI Certification Training course by Edureka. But a basic understanding of RDBMS can prove helpful for a smooth experience.
Certificate Qualifying Details
In order to qualify for the certificate, candidates must complete a certification project to implement the learning from the course. Candidates will have to mail the required project to the Edureka support team within two weeks from the date of the course completion. A panel of industry experts will evaluate and give the grades for the certification project following which the candidate will receive the certificate for the course.
What you will learn
Once you complete the MSBI Certification Training programme, you will gain the following skills:
- Successful implementation of end-to-end ETL system using SQL integration services
- Developing a business intelligence solution by integrating different Microsoft BI tools
- Using SSRS to present data through multiple types of reports and visualisations
- Understanding various Data Warehousing concepts such as ETL and multi-dimensional modelling
Who it is for
The MSBI Certification Training programme is a perfect fit for professionals interested in pursuing a career in Business Intelligence using Microsoft’s tools. Also, the course is highly suitable for individuals such as:
- IT Professionals
- Analytics or Software Professionals
- Professionals with a background in RDBMS, ETL, OLAP or other reporting tools
- Freshers who wish to pursue a career in Business Intelligence
Admission details
Candidates who want to enrol in the Microsoft BI Certification Training programme should follow these steps:
- Go to the official website of Edureka: https://www.edureka.co/
- Look for the “Microsoft BI Certification Training” webpage on the website.
- Scroll down, and on the bottom-right side of the page, you will find the “Enrol Now” button. As you click on the button, you will be asked to fill your email and phone number.
- Now, you need to select a batch for the live online classes.
- Once you have chosen a course batch, pay the applicable course fee to complete the process.
Filling the form
Candidates willing to take MSBI Certification Training online course will have to fill in personal contact details like name and phone number. After filling this, you need to choose a batch after which, you can make the payment for submitting the application form successfully.
The syllabus
Introduction to Cloud Computing and Salesforce Platform
Topics
Hands-on
- Install SQL Server
- Install SQL Server Data Tools
- Create small ETL Tasks
Introduction to SSIS
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
- 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
Transformations and 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
- 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
Transactions and Event Handling
Topics
- Parameters, Event Handling
- Transaction Options, CheckPoints, Logging options, Log Provider
- Configure Error Output and OnError event
- Package Security: Package Protection Levels
Hands-on
- Create Event Handling Task
- Parameterize a package
SSIS (Configuration, Deployment and Scheduling)
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
- Implement custom code using Script Task
- Create a control flow task consisting of a Script task to send email
Salesforce Security Model Object, Record and Field Level features
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
- Create dimensions and hierarchies
- Define a cube
- Create Data Source and Data Source Views
SSAS Deployment and MDX, DAX
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
- Retrieve tabular data using DAX
- Schedule the Cube processing
- Retrieve data from a Cube using MDX query
SSRS Reporting
Topics
- 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
- Create grouping in table
- Use interactive sort on a table
- Create a report based on Annual Sales
- Export report as a PDF
SSRS: Web Portal
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
- 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
Integration of SSIS, SSAS and SSRS
Topics
- End to End Business Intelligence Business Scenario involving SSIS, SSAS, SSRS and MDX
- MS BI Best Practices
Hands-on
- Case study to implement a scenario using SSIS, SSAS, SSRS and MDX
How it helps
The MSBI Certification Training course by Edureka teaches you primary concepts of business intelligence and effective techniques of data warehousing. The certification course also contains modules which will help you grasp Microsoft BI concepts such as SSIS, SSRS and SSAS.
Once you finish the training programme, you will be well-versed with Microsoft’s Business Intelligence tools. As a certified MSBI Analyst, you can earn an annual salary of up to $1,02,000 annually.
FAQs
The MSBI Training course by Edureka contains numerous modules on business intelligence and data warehousing with SSIS, SSAS, and SSRS as crucial elements in data analytics.
Yes, you need to submit a certification project at the end of the training course. The project will be reviewed and graded by a panel of industry experts. You will receive the course certificate based on your project performance.
You need an MSBI development environment to perform the practical assignments. You will receive a step-by-step guide to install the platform in the LMS upon enrolment.
The MSBI Certification Training programme will give you extensive knowledge about the core concepts of business intelligence and data analytics. As a certified Microsoft BI Analyst, you can find ample work opportunities across industries.
You will study real-time business intelligence case-studies, which are based on the current industry standards involving SSIS, SSAS, SSRS and MDX.