Microsoft Power BI Introduction

Ready to turn data chaos into clarity? Welcome to our “Microsoft Power BI Introduction” course, where we’ll transform you from a spreadsheet survivor into a data visualisation virtuoso!

Ever stared at endless rows of numbers hoping they’d magically make sense? Maybe you’ve watched colleagues create stunning dashboards and thought, “How do they do that?” Well, get ready to unleash your inner data detective and discover the power of business intelligence!

Whether you’re new to data visualisation or transitioning from Excel, this course will give you the confidence to create dashboards that tell your data’s story. Think of it as getting X-ray vision for your business data; you’ll learn to spot trends, patterns, and insights that were invisible before. By the end of the day, you’ll be connecting to data sources, crafting interactive visualisations, and sharing insights that will make your colleagues wonder if you’ve secretly been a data scientist all along!

Microsoft Power BI Introduction

Welcome to the “Microsoft Power BI Introduction” course, a comprehensive one day workshop that transforms Excel users into confident data visualisation specialists through mastery of essential Power BI features and dashboard creation techniques. This foundational course teaches you to connect, analyse, and visualise data effectively, enabling you to create interactive, insightful dashboards that transform complex data into clear, actionable business intelligence.

What You'll Get With This Course

Live Instructor-Led Training

Highly experienced and approachable trainers

Guaranteed to Run Courses

Book with confidence, guaranteed to go ahead

Outrageous Money Back Guarantee

Not satisfied? If we can’t fix it, get a refund

FREE Repeat Option

Retake within 6 months at no cost

Small Classes

No more than 6 people per class

Comprehensive Materials

PDF manual and training files included!

eCertificate of Completion

Proudly recognise your achievement

Lifetime Support

Expert help, always within reach

Microsoft Power BI Introduction Course Content

Introduction to BI

  • What is Business Intelligence?
  • Components of BI Software
  • The Power BI Product Family

Power BI Desktop Orientation

  • What is Power BI Desktop?
  • Setting up Power BI Desktop
  • The Desktop Window
  • Navigating Power BI Desktop

Connecting to your Data

  • Getting Data
  • Connecting to Databases
  • Connecting to Website Data
  • Connecting to Excel Spreadsheets

Transforming your Data

  • About the Power Query Editor
  • Removing and Filling Blanks
  • Setting Column Headings
  • Removing Columns
  • Replacing Values
  • Changing Data Types
  • Trimming Text
  • Editing Applied Steps

Data Modelling

  • About Relationships and Data Modelling
  • Viewing Relationships
  • Removing, Creating & Managing Relationships
  • Hiding Tables
  • Working with DAX
  • Creating Calculations

Creating Visualisations

  • About Visualisations
  • Using the Visualisations Pane
  • Adding Report Pages
  • Creating Tables
  • Creating Cards
  • Building Charts
  • Working with Maps
  • Custom Visualisations

Using Filters

  • Highlighting & Filtering Visualisations
  • Defining Visual Interactions
  • Using Spotlight & Focus Modes
  • Setting Filter Levels
  • Top N Filters

Publishing Reports

  • About Publishing
  • Publishing a Report
  • Using Power BI Service
  • Sharing Reports

*Our outlines are a guide to the content covered in a typical class.
We may change the course topics to meet the objectives of a particular class.

Prior Knowledge

This course assumes no prior knowledge of Microsoft Power BI. It is suitable for complete beginners who want to learn how to import, analyse, and visualise data effectively using this business intelligence tool. While experience with Excel is helpful, it is not required.

Required Software

You will need Microsoft Power BI Desktop installed on your computer. A free version is available for download from Microsoft’s website, or it can be accessed through a Microsoft 365 subscription.

Course Materials

All necessary exercise files will be provided during the training session. You don’t need to prepare any materials beforehand.

Note About Different Versions

As Power BI is regularly updated, the features covered in this course reflect the latest version available. While core concepts remain consistent, new features and improvements are regularly added to the platform. We will highlight any significant recent changes during the training session.
Is this the right course for me?
Visit our main course page to take a quick, anonymous Microsoft Power BI skills test. You’ll discover your true proficiency level in minutes, no registration required.

Why Bring Your Own Laptop?

Training is most effective when you’re working in a familiar environment. By bringing your own laptop to our training sessions, you’ll maximise your learning experience in several important ways.

Personal Comfort and Efficiency

Working on your own laptop means you’ll be instantly familiar with your keyboard layout and system preferences. No need to spend 20 minutes figuring out why the volume button is launching the calculator instead. This familiarity allows you to focus entirely on learning new skills rather than wondering why someone set the desktop background to dancing hamsters.

Access to Your Complete Work Environment

Your laptop comes with your personal setup of applications, customised settings, and existing files. Think of it as bringing your digital home with you, minus the dirty dishes in the sink. This means you can immediately apply what you learn to your real work documents and seamlessly integrate new skills into your daily workflow.

Practical Setup

During the training, you’ll enjoy the best of both worlds, your personal laptop connected to our professional training setup. Each workspace is equipped with a 27-inch monitor (perfect for those who squint at their phones even with reading glasses), full-size USB-A keyboard, and USB-A mouse.

Software Accessibility

With your own laptop, you’ll have immediate access to your licensed software and saved preferences. This is particularly important for applications where having your existing login credentials readily available ensures a smooth training experience. No need to remember that complex password you created after your third coffee of the day.

Don’t Have A Laptop?

Bring Your Enthusiasm!

We provide the coffee and biscuits, but your enthusiasm is the one program we can’t install for you. Don’t worry, our trainers are experts at generating enough energy to power a small city!
Brendon Farrell Co Founder Facilitator Keystroke Learning

Brendon Farrell

Co-Founder / Facilitator

From my early days wrestling with DOS commands to navigating today’s cloud-based world, I’ve dedicated my career to demystifying technology for others.

As a certified Microsoft and eLearning specialist, there’s nothing I enjoy more than seeing that spark of understanding when a student masters a new skill.

Outside of the training room, my passions run deep, whether I’m spending quality time with my wife and son, sharing my four decade love of lacrosse with junior players as their coach, or cycling around Melbourne’s on either my road bike or mountain bike.

Mark Finney Co Founder Facilitator Keystroke Learning

Mark Finney

Co-Founder / Facilitator

With a coffee in hand and a passion for problem solving in my heart, I’ve made it my mission to turn tech frustrations into success stories. Through years of hands-on experience, I understand the challenges learners face.

Being both a co-founder and trainer at Keystroke Learning lets me combine my love for teaching with creating innovative learning solutions that actually work in the real world.

When I step away from the keyboard, find me strumming my favorite tunes on guitar, relaxing with my wife watching movies on the couch, or tending to my garden.

Upcoming Public Courses

Price:  

$385.00

1 Day Training Course

Course Location & Dates

Still Need Approval?

This course is for
Group Bookings Only

Our Clients