Power BI is an industry leader and one of the largest and fastest growing business intelligence cloud solutions, used by over 35,000 companies world-wide.
Power BI is a suite of Microsoft tools that are used for business analytics, visualisation, and reporting. Power BI delivers supported decision making through actionable insights. It provides interactive reporting and business intelligence capabilities, allowing users to easily connect to, model, and visualise organisational and public data.
Power BI training is designed to provide participants with a fundamental understanding of the tools. Participants will learn how to use the Power BI tools by following a simple workflow that can be used to design, develop, deploy, and share Power BI reports and dashboards.
The Microsoft Power BI fundamentals course is an entry level workshop. If you are looking for a more in-depth technical course on Power BI, see our Microsoft PL-300T00 course.
Important note: Power BI is a Microsoft App that is not currently supported on non-Windows systems (such as Apple Mac).
Request Course Information
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.
What you’ll learn
After completing this workshop, participants will be able to:
Connect to various data sources and extract data
Shape data to ensure that all data is necessary, clean, and transformed appropriately
Model data to add any necessary derived calculations, columns, and tables
Utilise out-of-the-box and custom visualisations to display data appropriately
Publish reports and datasets to the Power BI service
Create dashboards, and use workspaces and apps to share Power BI objects
Microsoft Apps at Lumify Work
Lumify Work is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia's and New Zealand’s first and largest Microsoft Gold Learning Solutions Partner. Join more than 5,000 students who attend our quality Microsoft courses every year.
Stay ahead of the technology curve
Don’t let your tech outpace the skills of your people
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Quality Instructors and Content
Expert instructors with real world experience and the latest vendor-approved in-depth course content.
Partner-Preferred Supplier
Chosen and awarded by the world's leading vendors as preferred training partner.
Ahead of the Technology Curve
No matter your chosen technologies or platforms, we can help you stay one step ahead.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
We have a 30-year history of driving innovative, award-winning learning solutions.
More Courses, More Often
When you train with Lumify Work you get more courses, more often, in more locations, and from more vendors.
Who is the course for?
Microsoft Power BI Fundamentals training is an entry-level two-day workshop designed for anyone who needs to be able to analyse and visualise data using Power BI.
We can also deliver and customise this training course for larger groups – saving your organisation time, money and resources. For more information, please contact us on 1800 U LEARN (1800 853 276)
Students can attend the Power BI course on campus in Sydney, Melbourne, Adelaide, Brisbane, Canberra, Perth, or online.
Course subjects
Module 1: Introduction to Power BI
What is Power BI?
A brief history of Power BI
Power BI components
Power BI Report Server
Power BI architecture
Power BI Workflow
Getting started with Power BI
Power BI Desktop
Power BI Service
Power BI Help
Module 2: Getting Data
Power BI Workflow
Get data process flow
Data Sources
Data Base Data Sources
Data Base Queries
File Sources
Web Pages
Module 3: Shaping Data
Shaping vs Transforming Data
Shaping Data Overview
Where should I do the Shaping?
Shaping Data in SQL
Shaping Data in DAX
Shaping Data in Power Query
The Power Query Editor
First Pass at Shaping
Applied Steps
The Advanced Editor
Advanced Shaping
Module 4: Modelling Data
Relationships
Cardinality
Cross Filter Direction
Role Playing Dimensions
Optimising the Model
Configuring Data for Q&A
Hierarchies
Introduction to DAX
Calculated Columns
Calculated Measures
Module 5: Visualising Data
Visualisations
Charts
Filters
Slicers
Maps
Tables
Tree Maps
Formatting Visuals
Page Layout and Formatting
Mobile Layout
Custom Visuals
Report Themes
Module 6: Publishing to Power BI
Publishing to the service
Dashboards
Dashboards vs Reports
Q&A
Power BI Insights
Apps
Creating Workspaces and Apps
What can you do with an App?
Prerequisites
In order to attend this course you must have Power BI Desktop installed on your local desktop or laptop prior to attendance. Download Power BI Desktop from Microsoft here. Power BI accessed through a browser or Microsoft Teams does not have the features and functionality needed to complete this course. Remote connection to your work desktop or laptop is also not suitable.
In addition you will need to be able to extract compressed (ZIP) files to your desktop or laptop.
We recommend dual monitors, especially if your primary monitor is a laptop screen.
End User Seminars
Seminar-style training is conducted in short sessions of 1-3 hours and is ideal for groups of up to 30 students.
M365 Adoption and Training Plans
Our aim is to help educate and enable your organisation to get the best return on your Microsoft 365 investment.
Terms & Conditions
The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.
Request Course Information
By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.