4.9 (520 reviews)
Power BI Essentials
Power BI provides tools to perform data analysis and output results in visual reports. This course provides an in-depth, hands-on introduction to the Microsoft Power BI tool using data from Excel spreadsheets, databases and websites to create interactive reports. You will learn to
connect and use data from multiple sources
transform data into workable data sets
build powerful interactive visuals
This instructor-led course will teach you how to get data from almost any source and present it in a meaningful, visually appealing, and easy-to-understand format using Power BI's abundant features including how to create comprehensive interactive dashboard-style reports.
Course Overview
Audience:
The course has been designed for new users of Power Bi who wish to develop interactive and visually appealing reports.
Prerequisites:
Participants must be familiar with Microsoft Excel including creating charts.
Learning Outcomes
- Connecting a data source to Power BI
- Creating Visualisations
- Querying and shaping data
- Using the Query Editor
- Working with visual interactions
- Creating Reports
Course Content
Overview of Power BI
- Overview of Business Intelligence and Power BI
- Power BI Desktop, Power BI Service, Power BI Mobile
- Getting started with Power BI Desktop
- Data Sources
Power BI Desktop
- Interface
- Visualizations and Fields panes
- Power Query Editor
- Getting data from data sources
- Excel
- SQL database
- Online data services - Uploading Excel data to Power BI
- Working the the views - Report View, Data View and Model View
Transforming, Cleansing and Shaping Data
- Opening Power Query
- Removing rows from the top
- Using First Row as header
- Removing columns
- Choosing relevant column data types
- Renaming columns
- Cleansing data
- Adding Year column for filters
- Filtering data
- Unpivoting data
- Removing duplicates
- Copying queries
- Merge and Append queries
- Organising queries
- Checking column quality and data profiles
Power BI Data Model
• Using the Data model
• Relationships
• Adding calculations (Measures)
• Creating calculated columns (DAX)
Visualizations
• Creating and working Visualizations
• Chart types
- Bar chart
- Column chart
- Line chart
- Pie charts
- Map
- Matrix
- Bubble map
• Basic formatting of Visualizations
• Creating a Table Visualization
Power BI Reports
• Designing a report
• Adding pages to a report
• Adding text boxes and shapes to a report
Visual Interactions
• Turn interactions on/off
• Interacting by Filtering
Delivery Options
Public Courses
Live online - learn by doing.
Our Live Online courses are conducted through a dedicated learning platform that enables us to provide instructor-led, hands-on training to develop real skills, in real time. Each participant logs into their own virtual environment setup specifically for the course. This is a fully interactive experience - just like in a classroom. No passive lectures. No videos to follow - real time hands-on practice with your instructor guiding you every step.
Instructor:
- provides real-time live hands-on instruction and demonstration,
- provides step-by-step practical activities for participants,
- can assist participants on their screen, if necessary,
- can share participant screens to enhance discussion.
Participants:
- receive hands-on instruction, step-by-step exercises and skill-builder activities,
- see the instructor screen while working on their own environment,
- can interact with the instructor and the group of participants,
- can ask questions at any time,
- join the course from any location with internet using a Course Invitation.
- no need for any software, just a computer with internet and a browser.
- no downloads on installs necessary on the participant computer.
Inclusions:
- E-Book Training Manual/activity booklet will be provided
- Certificate of Completion
- Post-course support to the level of the course
- Access to any training exercises used during the session
Session Times:
- Full Day Course: 9:00 am-4:30 pm
- Half Day Course: 9:00 am-12:30 pm or 1:30 pm-5:00 pm
Private Courses
Private sessions can be arranged through our Live Online platform for group training. Group training content and duration can also be tailored to your needs. To discuss your training requirements, contact our Course Scheduling team.
Classroom
Classroom sessions are delivered at a nominated location (Private courses only).
Requirements:
If training is being delivered on your site:
- A computer is required for each participant, configured with appropriate software (if necessary).
- If participants are using laptops, ensure power cords are provided for use during the session.
- The instructor will bring their own laptop - please provide power
- Screen/Projector for trainer to connect their laptop to. Please indicate the connection method - hdmi or wifi.
Inclusions:
- Training Manual/activity booklet
- Certificate of Completion
- Post-course support for queries relating to the course content.
Power BI Essentials
| Event | Event Date | Location | Individual Price | Register |
|---|---|---|---|---|
| Power BI Essentials | 19-03-2026 | Live Online | $440.00 | |
| Power BI Essentials | 23-04-2026 | Live Online | $440.00 | |
| Power BI Essentials | 28-05-2026 | Live Online | $440.00 | |
| Power BI Essentials | 02-07-2026 | Live Online | $440.00 |
Brochure