Power BI Training

Power BI Essentials

Passionate expertise and a decade of experience has lead to the creation of this practical, hands-on Power BI course. Perfect for beginners and self-taught people that want to start their Power BI journey being led by a true expert.

Buy now ( Lifetime Access ) Free Preview

Welcome

I'm Wyn Hopkins (your tutor), and this is an amazing Power BI course. I've been teaching Power BI for 8 years and receive rave reviews.
You may have seen me on the Access Analytic YouTube channel, where I have 100k subscribers and over 6 million views.
I love to help people and when not on YouTube I'm at conferences, meetups, and answer questions on forums. Microsoft have recognised this contribution by awarding me Microsoft MVP status every year since 2017.
I know you'll love this course. It will set you up for great success!

What people are saying...

Some of the wonderful feedback we've had

This below is from the in-person delivery of this course

Why Choose Access Analytic

Find out more

Why Access Analytic is the right choice

Passionate expertise and a decade of experience has lead to the creation of this practical, hands-on course.

Download the Why Access Analytic PDF

Checklist

Do other courses have these credentials?

Lifetime Access (no time limit)
Money Back Guarantee
Free Hosting of your Showcase Report
Subject Matter Expert Instructor ( Microsoft MVP )
A decade of classroom experience
Focussed - Highly Relevant Content

Course curriculum

Price in USD

1. Welcome - What is Power BI?
  FREE PREVIEW
2. How to get the latest version of Power BI Desktop
  FREE PREVIEW
3. Download the Exercises
4. Offer to host your report!
  FREE PREVIEW
1. Critical Lesson - Setting things up
  FREE PREVIEW
2. Familiarising ourselves with Power BI desktop
  FREE PREVIEW
1. Importing Data with Power Query
  FREE PREVIEW
2. Initial understanding of column Data Types and removing rows
3. A sneak peak of adding visuals to the page
4. Power Query Magic Part 1 - Column From Examples
  FREE PREVIEW
5. Power Query Magic Part 2 - Transforming Text
6. Power Query Magic Part 3 - Adding an Age column and choosing what to import
7. Final Steps - Data Quality and Data Visualisation
8. Adding a DAX Measure
9. What if your data source is moved or renamed?
10. Publishing and Licencing
  FREE PREVIEW
11. Quiz: Introduction to the basics
1. Recap on the introduction
  FREE PREVIEW
2. An overview on the aim of this exercise
3. Cleaning up the Project Cost Data
4. Adding Dimension (Lookup) Tables
5. Explaining Relationships and How Dimensions Filter Facts
6. The Calendar Table
  FREE PREVIEW
7. Formatting your visuals for a clean look
8. Unpivoting and comparing against Budget
9. Editing Visual Interactions
10. Creating a Map visual and debugging errors
11. Quiz: Building a multi table semantic model
1. Adding Columns in Power Query to assist your analysis
  FREE PREVIEW
2. Using Columns in Visuals
1. DAX Measures: Variance and formatting negatives
2. Create a MyMeasures table to organise your measures
3. Date Based DAX: Year To Date - Cumulative Totals
4. Date Based DAX: Full Year Budget - Introducing CALCULATE and explaining the Filters
5. Date Based DAX: Prior Period Comparisons - including chart
6. Closing Thought: You MUST use Measures
7. DAX Tips Card - Access Analytic
8. Quiz: Power Query and DAX
1. Creating a Template File for all future reports
2. Recommended YouTube: Hiding Icons and Hiding Notes Page
1. Introducing the Practical Build Session
  FREE PREVIEW
2. Importing Data with Power Query and Building the Data Model
3. Actual v Plan , Card, Stacked Column and Line
4. Modern Card and Slicer
5. Table, Actual v Plan, YTD and Top 5
6. Formatting Visuals and Conditional Formatting
7. SELECTEDVALUE, ISFILTERED, Concatenated List Quick Measure
8. Conditional Background, Icons, Filter using Power Query Helper Column
9. Session Recap
10. Quiz: Building a report from scratch
1. Introduction to Simplifying your Model using Merge
  FREE PREVIEW
2. Merging Dimensions to go from Snowflake to Star Schema
3. Handling Multiple Date Fields with USERELATIONSHIP
4. Quiz - Simplifying your model
5. Practice Challenge & Solution - Contract Report
1. Introducing From Folder
2. Consolidating Files from a Folder
3. From SharePoint Folder and 10 Million Rows Loaded to Excel
4. Recommended YouTube : Multiple Sheets from Multiple Files
5. Recommended YouTube : Combine files with inconsistent Headers
6. Quiz : From Folder
1. Intro to Usability Features
2. Drillthrough and Tooltips
3. Buttons and Bookmarks
4. Field Parameters (User Driven display options)
5. Small Multiples, Decomposition Tree, Q&A, Custom Visuals
6. Recommended YouTube: Beginners Guide to Deneb
7. Quiz: Usability Features
1. Intro to Connecting to SharePoint and Scheduling Refreshes
2. Connecting to files on OneDrive and Scheduling Refreshes
3. Quiz: Connecting to a file on SharePoint
1. Introduction to Workspaces and Apps
2. Creating a workspace and explaining Licences
3. Sharing your reports the best way - Apps
4. Dataflows - centralising your Power Query tables
5. Download, Embed, Connect, Subscribe, Usage Metrics and Dashboards
6. Quiz: Pro Features and Sharing
1. Introduction to Row Level Security
2. Row Level Security
3. Quiz: Row Level Security
1. The report you are going to build
  FREE PREVIEW
2. Updated Download for this Session (4 June 2025)
3. Stage 1 - Importing and Organising the data
4. Stage 2 - Adjusting the Calendar Table, building the column charts
5. Stage 3 - DAX Iterator Functions and VAR to get Daily Averages
6. Stage 4 - Cards and Small Multiples
7. Stage 5 - Comparison v Prior Year and Button Slicer
8. Stage 6 - Creating a Slicer with Images ( + using OneDrive as storage )
9. Stage 7 - Conditional Formatting including Measure Driven
10. Stage 8 - Tooltips with Year on Year Comparison Chart
11. Stage 9 - Finishing Touches and Final Comment
1. Practice Data Sets
2. Links to More Practice Data
1. Conditional Formatting
2. Slicers
3. Paginated Reporting & Exporting Data
4. Power Query
5. DAX
6. Visual Level Calculations (DAX)
7. DAX User Defined Functions
8. Calendar Options for new DAX Time Intelligence
1. Connecting to a SQL database - Import v Direct Query and Query Folding
2. Fabric Explained
3. Power BI (Fabric) Adoption Roadmap
1. Congratulations
2. Feedback

About this course

$299.00
106 lessons
Quizzes and Downloads
Certificate on Completion
World Class Instructor

Bonus material

In addition to in-depth hands-on video tutorials and quizzes we have also included

Downloads

Downloadable Exercises for you to follow along with a hands on learning experience
Curated External Videos

Curated lists of YouTube content directly relevant to lessons learned
Discussion Panel and Free Community

Post questions and review other student comments in the discussion panel for each course section | plus all students get Free Access to our Power BI community to ask questions and share experiences

Curious?

Check out some of the free content

Try preview lessons

60-day money back guarantee

If, within 60 days of completing the course and receiving your certificate, you don't save hours and make an impact then we'll refund you fully, no questions asked

Buy Now!

Lifetime Access plus free membership to our Power BI Community and Forum and hosting of a showcase dashboard

$299.00

USD

Let's go

Helping people learn

100k subscribers and 7 million views

Our trainer, Wyn Hopkins, has been helping people learn Power BI and Excel for 10 years via YouTube, Conferences, Meetup groups and forums. He will help guide you throughout this amazing online course.

Follow Wyn on YouTube

Access Analytic Training

Power BI Essentials

Welcome

What people are saying...

Why Choose Access Analytic

Find out more

Checklist

Course curriculum

Introduction

First Look at Power BI

Introduction to the basics

Building a multi table data model and report

Adding Formula Based Columns in Power Query

Introducing DAX Essentials

Setting up a template file

Practical Build Session - Building a report from scratch

Simplifying your model - Star Schema and Inactive Relationships

Consolidating Multiple Files from a Folder

Usability Features

Publishing and Scheduling a Refresh

Workspaces - Pro Features & Sharing Best Practice

Row Level Security

The Final Build - A Beautiful Energy Report

Practice Data Sets

Recommended Additional YouTube Content

Additional Links and Information

Congratulations on completing the course

About this course

Bonus material

Downloads

Curated External Videos

Discussion Panel and Free Community

Curious?

60-day money back guarantee

Buy Now!

$299.00

Helping people learn