Microsoft Power BI Comprehensive Training


Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.


Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning.


Our Corporate training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.


High quality training from Certified & Industry Experts

Earn 16 PDUs

Course Completion Certificates

Extensive documentation provided

Reimbursement guaranteed if the training is not satisfied

Our approach is both practical and inspirational. Our training is carefully designed and tested to develop the key skills and confidence needed while being highly participatory and fun

Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.

Day 1: Power BI for Report Developers

Overview of Power BI (Desktop & Service)

Architecture modes: Import, Direct Query, Composite and Live

Data cleansing, shaping and transformation

Using M language in Power Query

Dimensional modelling concept – Star schema

Power BI data modelling

Measure and calculated column

DAX aggregator and iterator formulas

Developing reports by standard and custom visuals

Advanced visualisation tricks: Bookmark, Q&A, colour themes,

Sharing and collaborating reports in Power BI Service

Creating Dashboard

Hands on lab practices


Day 2: Mastering in DAX and Data Modelling

Dimensional modelling

Star schema – Snowflakes

Data modelling scenarios

Tables relationship scenarios

Slowly changing dimension

Introduction to DAX

DAX Evaluation, Filter and Row contexts

DAX functions – Aggregator/Iterator

Deep dive to Calculate function

DAX Time Intelligence

DAX table functions

Querying data by DAX

Hands on lab practices

  • Understand primary features of a self-service Power BI solution
  • Utilize Power BI and its data sources
  • Combine, analyze, model, shape, and visualize data
  • Report data using rich dashboards

Once after the training you receive course completion certificate from Mangates

Power BI training is for all professionals who are passionate about business intelligence, data visualization, and data analytics.

  • Business Analysts
  • Business Intelligence Manager
  • Statisticians and Analysts
  • Data Scientists
  • Project Managers

What Does Mangates provide me on the day of the course?

We provide Course Materials, Course Completion Certificate and Refreshments

What experience does Instructor has?

All our Instructors are Certified & Industry Experts and they have years of experience in the same filed. © 2019 . All rights reserved.