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 Free Preview

Feedback

Some of the great feedback we've had about the course

This feedback 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?

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
3. Download the Exercises
4. Offer to host your report!
  FREE PREVIEW
1. Critical Lesson - Setting things up
2. Familiarising ourselves with Power BI desktop
1. Importing Data with Power Query
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. Stage 1 - Importing and Organising the data
3. Stage 2 - Adjusting the Calendar Table, building the column charts
4. Stage 3 - DAX Iterator Functions and VAR to get Daily Averages
5. Stage 4 - Cards and Small Multiples
6. Stage 5 - Comparison v Prior Year and Button Slicer
7. Stage 6 - Creating a Slicer with Images ( + using OneDrive as storage )
8. Stage 7 - Conditional Formatting including Measure Driven
9. Stage 8 - Tooltips with Year on Year Comparison Chart
10. 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)
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
103 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

Buy Now!

Includes access to Forum and hosting of a showcase dashboard

$299.00

USD

Let's go

Access Analytic Training

Power BI Essentials

Feedback

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?

Buy Now!

$299.00