Microsoft Power BI Training – The Essentials

Microsoft Partner Power BI Logo
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Power BI Training – The Essentials

$1360per person

In Person Virtual

Location: Level 1 Cloisters, 863 Hay Street, Perth WA 6000
Time: 9:00 am to 4:00 pm
Duration: Two consecutive days

Join in-person at our vibrant Perth CBD training centre. Lunch and refreshments are provided for all in-person attendees. Our training centre is centrally located and easily accessible by public transport.

Course Overview

Course Overview

Develop Your Skills with our Comprehensive Power BI Training Course.

This Power BI Essentials 2-day course provides training to develop your skills and become familiar with the key features of Power BI. You will learn how to import data from a wide variety of sources such as Excel, databases and websites and perform powerful data analysis. On completion of Power BI Essential training, you will be able to create stunning interactive data dashboards and interactive reports.

Dates

Book a course

Course Information

Course Content

Overview of Power BI Essential Training

  • A generic Business Intelligence process
  • The Power BI Architecture and Integrations
  • Power BI Desktop, Service and Mobile
  • Roles in BI and the Power BI Architecture
  • Power BI Licencing

BI Process using Power BI

  • Business Analysis
  • Create the required Model (info and structure)
  • Answer the questions
  • Present it in a way people can use
  • Share through Power BI Service

Visualisations

  • Overview of Visualisations
  • Creating and working with Visualisations
  • Chart Visualisations: Bar, Column, Line and Pie
  • Card, Table and Matrix Visualisations
  • Time-based and Formatting Visualistion

Visualisation Interactions and Filters

  • Introducing Visual Interaction
  • Turning Interaction on or off
  • Interacting by Filtering
  • Creating a Slicer
  • Filtering in the Visualisation pane
  • Adding a page level Filter

Working with the Power BI Service

  • Overview of functionality
  • The User Interface
  • Sharing Options

Combining Visualisation in a Report

  • Creating and saving a report
  • Adding pages to your reports
  • Re-using visualisations
  • Building a narrative in your report

Business Analysis – Scenario

  • Introducing the scenario
  • Business Analysis
  • Domain and areas to improve
  • Questions to ask and KPIs to monitor
  • Possible visualisations

Data Structure Theory

  • Data Types and Table Structures
  • Relationship and data normalisation
  • Queries to join data and join types

Data Analysis of Scenario

  • Information required
  • Best structure to provide outcomes
  • Exploration of Data Sources

Data Sources, Importing and Sharing

  • Importing from Structured data sources
  • Importing from Semi-Structured data sources
  • SharePoint and OneDrive
  • Data source sharing

Data Cleaning and Transforming

  • Data Cleaning
  • Common Transformations
  • Unpivoting
  • The M language
  • More complex transformations

Data Modelling: Structuring

  • Creating Relationships
  • Data Storage Vs Data Model
  • The star schema (Fact and Dimension tables)
  • De-normalising data

Data Modelling: Calculations, Measures and DAX

  • Basic DAX concepts
  • Creating calculated columns
  • Calculated Columns with DAX
  • Adding a Date/Calendar table
  • Using Measures with DAX
  • Creating Measures with DAX

Advanced Visualisations

  • Choosing the best visualisation to present your data
  • Comparisons and Rankings
  • Change over time and Trends
  • Spatial Data
  • Downloading and using additional visualisations

Get in touch

Excel in business with our premier Power BI Essentials training and more. Whether you’re looking to upskill through training or need tailored support through our consultancy services, we’re here to help.

To learn more about our Microsoft Power BI course or how we can support your data goals, please contact us today or give us a call on (08) 9218 9059.

By the end of the workshop, participants will be able to:

  • Understand the generic Business Intelligence process
  • Understand the Power BI Architecture and its components
  • Be able to analyse a scenario and work out the best model for output of results
  • Use the Power BI Desktop to import, clean and transform data
  • Use Power Query to create the best model for output of the results
  • Use a variety of visualisations to present the outcomes in an understanding manner
  • Load visualisations into the Power BI Service and share data with others

Completion of a Microsoft Excel Intermediate course or the equivalent knowledge is required.

Also a basic knowledge of how databases work, and database theory would be helpful.

” The course was well structured, and I found the venue and facilities to be of a very high standard. John has extensive knowledge regarding the subject matter of our course and more which really helped him to give us meaningful and realistic examples. I really enjoyed the sessions.” – Beauty from ICWA

“Excellent training – well run and timing was efficient, Good use of timing and breaks to keep focused. Resources/course materials were really helpful. I’ll be able to put into practice my learnings and apply them in the workplace” – Emma from Rio Tinto

“The course was well structured, and I found the venue and facilities to be of a very high standard. John has extensive knowledge regarding the subject matter of our course and more which really helped him to give us meaningful and realistic examples. I really enjoyed the sessions.” – Beauty from ICWA

“Thoroughly enjoyed the 2-day course, Steve made the experience extremely easy to follow along and explained every concept very well. The course content and delivery were 10/10. Thank you” – Nathan from Western Power

“Trainer Steve was very knowledgeable and had the patience of a Saint.  He clearly stepped through each component and took care to ensure we were all keeping up and understood the content.  A somewhat dry topic was quite enjoyable.” – Liza from Legal Aid

“Power BI Essentials was an excellent training, highly insightful, well-paced, and comprehensive. It covered a broad range of topics, and the trainer was engaging and very knowledgeable.” – Natalia from PLS

“Would highly recommend to upcoming Business Managers and Business Analysts” Samantha from WA Country Health Service

“Thank you for an informative course, I will be using a lot of this content to apply to my own work. It was a well planned and presented course with excellent content to work through” – Jessica from Dept. of Education

“Terrific course. This is difficult subject matter to teach and the quality of instruction far exceeded my expectations”Ben from Rio Tinto

“The best feature of this course was the umbrella view of theory and how this would connect to my work”Nigel from Dept. of Education

“Excellent introduction to presenting and analysing data. The software features were well demonstrated and non-repetitive. A lot was covered in the duration”Mike from Duratec Ltd

“The best part of this course was its interactive nature and the opportunity to apply our skills in workshops at the end”Bryan from BHP

“I enjoyed reviewing the examples in detail, and the step by step approach was extremely helpful. This course was set at a good pace”Sue from Dept. of Education

“The trainer was detailed in explaining the course and very patient when answering questions. He also gave us examples to work on together so we could practice our skills” – Novianty from Sage Automation

“A great overview of basic functions and more advanced possibilities. Filled with lots of practical examples and the trainers were helpful in pointing where errors might occur” Vincent from Dept. of Primary Industries and Regional Development

“A well-structured course with good use of examples. It was very helpful to work through examples with the instructor’s screen next to yours”Johan from Davey Bickford Enaex Australia

FAQs

What courses should I take after Power BI Essentials?
Are your courses available online or in person?