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.
Duration Learning Credits
2 days – 16 hours of 16 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: AUD 1295.00
Regular Price: AUD 1495.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: AUD 995.00
Regular Price: AUD 1195.00
Private Group/ In-House Learning:
Have a group of 3 or more people?
Register yourself with a special pricing and
request the training exclusively
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
The Power BI training is for all the professionals who are passionate about business intelligence, data visualization, and data analytics.
● Business Analysts
● Business Intelligence Manager
● Statisticians and Analysts
● Data Scientists
● Project Managers
● 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