Platform Access

Ultimate Beginner's Guide to

Power BI

Premium Power BI training for individuals looking to develop their analytical thinking and capabilities. This course aims to teach you how you can achieve this yourself through utilising the key features within the Power BI suite.

Enroll in course for FREE
Ultimate Beginners Guide for Power BI, power bi for beginners

Here's What You'll Get

With The Course

3 hours of course video content

Demo data set

to practice with

Advanced Power BI model & report

Quiz to test your knowledge

Ultimate Beginners Guide for Power BI

Get an overview on all the introductory concepts of how to use Power BI as an analytical tool

  • Step-by-step work through a real-world scenario so you can understand how data can start from its rawest form and be developed into a compelling analytical solution using Power BI
  • Help you find valuable insights that can drive decision making within organisations

Details Of What You Will Learn

During This Course

  • Learn - how to use Power BI as an analytical engine, turning raw data into unmatched insights

  • Save - mountains of time by learning how to automate analysis and reporting

  • Learn - how to look at raw data and then apply Power BI and DAX to find answers

  • Learn - how to find the insights that make a difference and add value to decision making

  • Develop - compelling visualizations that showcase insights that will add value to business discussions and actions
Ultimate Beginners Guide for Power BI

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

This course is designed for those who have little to no knowledge of Power BI but are working in data-driven environment.


Utilize the key features within the Power BI suite

Ultimate Beginners Guide for Power BI 3 screens
  • Develop a best practice Power BI model
  • Plan Power BI development before you start
  • Query, transform and load data
  • Create a data model
  • Write DAX measures
  • Develop compelling reports and visualizations
  • Publish to the Power BI online service
  • Create dashboards
  • Use the Q&A feature
  • Use other online service features

Course Curriculum

1. Introduction

  • How to get Certified for this course?
  • Data & resource downloads
  • Course Intro
  • What is DAX and why do you need to learn it?
  • A review of the data scenario
  • Setting up your Power BI model

2. Querying & Transforming Data

  • Query editor explained
  • Simple transformations
  • Creating a date table
  • Organising your queries
  • Advanced transformations

3. Data Modelling

  • What is data modeling?
  • Relationships between tables

4. DAX Calculations

  • What is DAX?
  • Measure groups
  • Simple measures
  • Measure branching
  • Advanced DAX

5. Reports & Visualisations

  • Visualisation options
  • Colour and themes
  • Custom visuals
  • Visualisation best practices

6. Online Service

  • Publish to online service
  • Dashboards & Apps
  • Natural language query
  • Distribution features

What our Students Say

Your Instructor

Sam McKay

Sam very early on saw the immense opportunity of using Power BI to create analytical solutions. After years of developing some advanced analysis and tools in excel, he was amazed that he could re-create most of those things in about 10% of the time with Power BI.

He is the founder and CEO at Enterprise DNA, a business intelligence training & consultancy business primarily focused on driving better decision making within organisations by empowering individuals and teams to transform raw data into unmatched insights using Microsoft's Power BI suite of tools.

Sam has a strong history in Finance, previously working at ANZ, PIMCO, and Fonterra. He is also a CFA charter holder, achieving the designation in 2011.

He has a passion for building highly scalable analytical solutions within organisations, and wants to see others learn how to do the same.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or For Business access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business. To learn more, see here.

Get full access to unparalleled training

& skill-building resources

For Individuals

Enterprise DNA


Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace