Advanced Microsoft Power BI Training in New Zealand

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports. You are already using Microsoft’s cloud reporting and business analytics suite, Power BI, to analyze your organizations data and share insights and are now ready to learn the advanced techniques that you, your business analysts, and your stakeholders need to create complex information from projects, program, and portfolio reporting to utilizing time-phased data and, potentially, data from your enterprise’s other line-of-business tools. Attendees of this course will gain practical examples from the experienced instructor who has deployed and configured Power BI reporting in a wide variety of businesses.

The Power BI boot camp course is a pre-requisite for the course. Alternatively, delegates should have at least 3 months experience in using Power BI Desktop for creating reports and dashboards.

• Create Advanced Power BI Reports
• Advanced understanding of the data schemas and extracting data
• Perform advanced transformations of data or any data schema
• Utilize time-phased data in the creation of complex analyses
• Create new measures using DAX
• Filter data using row-level security
• Create and deploy content packs
• Explore Data Visualizations
• Create and publish Reports

1.  Introduction

• What you should know 
• Our project: Creating an advanced Power BI dashboard

2. Working with Data

• Importing online data sources
• Uploading from a folder of data 
• Querying a database
• Importing and transferring data imported from an Excel, CSV, or TXT file

3. Query Editor 

• Introducing Query Editor steps  
• Transposing data tables 
• Splitting fields and columns         
• Formatting data with text formulas
• Creating conditional formulas
• Creating calculated formulas

4. DAX Language              

• Introducing DAX               
• Introducing DAX measures          
• Understanding DAX measure logic           
• Evaluating DAX measures             
• Leveraging the CALCULATE functionality               
• Understand how filters work in CALCULATE function       
• Leveraging the ALL function
• Understanding the FILTER functionality

5. Introduction to DAX Formulas               

• Creating a separate table for measures 
• Creating a table using GENERATESERIES formula
• Leveraging the POWER function
• Leveraging the DIVIDE function
• Utilizing the X factor (SUMX, COUNTX, etc.) for ranges
• Utilizing quick measures

6. Advanced DAX Calculations

• Creating a date table using a formula
• Filtering between tables               
• Utilizing IF statements with conditional functions
• Introducing the DATEDIFF measure         
• Working with disconnected tables           
• Leveraging the BLANK function 
• Using variables in formulas
• DATESBETWEEN and the X functions       
• Introducing the DATEADD date calculations         
• Introducing the MTD, QTD, and YTD date calculations

At Bilginç IT Academy, we combine our strong presence in both the UK and Türkiye to deliver high-quality, practical training solutions for organizations worldwide.

International Presence with Local Expertise
With operations in the United Kingdom and Türkiye, we bring together global standards and local market understanding to deliver effective training experiences across regions.

Expert Instructors with Real-World Experience
Our courses are delivered by certified trainers with extensive industry experience, ensuring you gain practical knowledge that can be applied immediately.

Corporate-Focused Training Approach
We specialize in training corporate teams, tailoring our programs to meet your organization’s goals, technologies, and project requirements.

Flexible Training Delivery Worldwide
We offer classroom, virtual classroom, and onsite training options globally, tailored to your organization’s needs.

Hands-On, Practical Learning
Our training sessions include real-world scenarios, case studies, and interactive exercises to ensure lasting understanding and skill development.

Proven Track Record
With over 10 years of experience, we have successfully trained professionals from leading organizations across different industries and regions.