Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.
Microsoft Power BI Comprehensive Training
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
Hands on lab practices
Day 2: Mastering in DAX and Data 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?
What experience does Instructor has?
All our Instructors are Certified & Industry Experts and they have years of experience in the same filed.