Previously Excel Consulting

power bi courses nexacu

Power BI Training - Beginner Course

Learn Power BI to create and collaborate on reports and interactive data visualisations. 

Learn how to create powerful interactive dashboards, custom reports, analyze data and share insights on our One-day course. After the completion of this course you will be able to create rich dashboards available on every device, which will allow you to monitor your business and get answers quickly.

View our full Power BI Beginner course outline below.

 

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Brisbane
Date
Course
City
Status
Fri 31-Jan-20
Power BI Beginner
Brisbane
Sold Out
Tue 4-Feb-20
Power BI Beginner
Brisbane
Confirmed
Thu 6-Feb-20
Power BI Beginner
Brisbane
Sold Out
Mon 17-Feb-20
Power BI Beginner
Brisbane
Sold Out
Thu 20-Feb-20
Power BI Beginner
Brisbane
Scheduled
Wed 26-Feb-20
Power BI Beginner
Brisbane
Sold Out
Thu 5-Mar-20
Power BI Beginner
Brisbane
Scheduled
Wed 11-Mar-20
Power BI Beginner
Brisbane
Scheduled
Thu 12-Mar-20
Power BI Beginner
Brisbane
Few Seats
Wed 18-Mar-20
Power BI Beginner
Brisbane
Scheduled
Wed 25-Mar-20
Power BI Beginner
Brisbane
Scheduled
Mon 30-Mar-20
Power BI Beginner
Brisbane
Scheduled
Thu 2-Apr-20
Power BI Beginner
Brisbane
Scheduled
Thu 9-Apr-20
Power BI Beginner
Brisbane
Scheduled
Tue 14-Apr-20
Power BI Beginner
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Fri 31-Jan-20
Power BI Beginner
Sydney
Scheduled
Thu 6-Feb-20
Power BI Beginner
Sydney
Confirmed
Mon 17-Feb-20
Power BI Beginner
Sydney
Confirmed
Wed 26-Feb-20
Power BI Beginner
Sydney
Scheduled
Tue 3-Mar-20
Power BI Beginner
Sydney
Scheduled
Thu 12-Mar-20
Power BI Beginner
Sydney
Scheduled
Wed 18-Mar-20
Power BI Beginner
Sydney
Scheduled
Wed 25-Mar-20
Power BI Beginner
Sydney
Confirmed
Mon 30-Mar-20
Power BI Beginner
Sydney
Scheduled
Thu 9-Apr-20
Power BI Beginner
Sydney
Scheduled
Tue 14-Apr-20
Power BI Beginner
Sydney
Scheduled
Tue 21-Apr-20
Power BI Beginner
Sydney
Scheduled
Tue 28-Apr-20
Power BI Beginner
Sydney
Scheduled
Wed 13-May-20
Power BI Beginner
Sydney
Scheduled
Mon 25-May-20
Power BI Beginner
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Thu 6-Feb-20
Power BI Beginner
Parramatta
Few Seats
Tue 18-Feb-20
Power BI Beginner
Parramatta
Scheduled
Mon 2-Mar-20
Power BI Beginner
Parramatta
Scheduled
Tue 17-Mar-20
Power BI Beginner
Parramatta
Scheduled
Fri 20-Mar-20
Power BI Beginner
Parramatta
Scheduled
Wed 1-Apr-20
Power BI Beginner
Parramatta
Scheduled
Tue 14-Apr-20
Power BI Beginner
Parramatta
Scheduled
Mon 20-Apr-20
Power BI Beginner
Parramatta
Scheduled
Mon 27-Apr-20
Power BI Beginner
Parramatta
Scheduled
Tue 12-May-20
Power BI Beginner
Parramatta
Scheduled
Wed 27-May-20
Power BI Beginner
Parramatta
Scheduled
Tue 9-Jun-20
Power BI Beginner
Parramatta
Scheduled
Thu 25-Jun-20
Power BI Beginner
Parramatta
Scheduled
Melbourne
Date
Course
City
Status
Fri 31-Jan-20
Power BI Beginner
Melbourne
Confirmed
Thu 6-Feb-20
Power BI Beginner
Melbourne
Few Seats
Thu 13-Feb-20
Power BI Beginner
Melbourne
Sold Out
Mon 17-Feb-20
Power BI Beginner
Melbourne
Few Seats
Wed 26-Feb-20
Power BI Beginner
Melbourne
Few Seats
Tue 3-Mar-20
Power BI Beginner
Melbourne
Scheduled
Thu 12-Mar-20
Power BI Beginner
Melbourne
Scheduled
Wed 18-Mar-20
Power BI Beginner
Melbourne
Scheduled
Wed 25-Mar-20
Power BI Beginner
Melbourne
Scheduled
Mon 30-Mar-20
Power BI Beginner
Melbourne
Scheduled
Thu 9-Apr-20
Power BI Beginner
Melbourne
Scheduled
Tue 14-Apr-20
Power BI Beginner
Melbourne
Scheduled
Tue 21-Apr-20
Power BI Beginner
Melbourne
Scheduled
Tue 28-Apr-20
Power BI Beginner
Melbourne
Scheduled
Wed 13-May-20
Power BI Beginner
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Thu 6-Feb-20
Power BI Beginner
Canberra
Scheduled
Tue 18-Feb-20
Power BI Beginner
Canberra
Confirmed
Tue 25-Feb-20
Power BI Beginner
Canberra
Sold Out
Mon 2-Mar-20
Power BI Beginner
Canberra
Scheduled
Tue 17-Mar-20
Power BI Beginner
Canberra
Scheduled
Fri 20-Mar-20
Power BI Beginner
Canberra
Scheduled
Wed 1-Apr-20
Power BI Beginner
Canberra
Scheduled
Tue 14-Apr-20
Power BI Beginner
Canberra
Scheduled
Thu 16-Apr-20
Power BI Beginner
Canberra
Scheduled
Mon 27-Apr-20
Power BI Beginner
Canberra
Scheduled
Thu 14-May-20
Power BI Beginner
Canberra
Scheduled
Mon 25-May-20
Power BI Beginner
Canberra
Scheduled
Tue 9-Jun-20
Power BI Beginner
Canberra
Scheduled
Mon 22-Jun-20
Power BI Beginner
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Thu 6-Feb-20
Power BI Beginner
Adelaide
Few Seats
Mon 10-Feb-20
Power BI Beginner
Adelaide
Confirmed
Tue 18-Feb-20
Power BI Beginner
Adelaide
Few Seats
Mon 2-Mar-20
Power BI Beginner
Adelaide
Scheduled
Tue 17-Mar-20
Power BI Beginner
Adelaide
Scheduled
Fri 20-Mar-20
Power BI Beginner
Adelaide
Scheduled
Wed 1-Apr-20
Power BI Beginner
Adelaide
Confirmed
Tue 14-Apr-20
Power BI Beginner
Adelaide
Scheduled
Thu 16-Apr-20
Power BI Beginner
Adelaide
Scheduled
Mon 27-Apr-20
Power BI Beginner
Adelaide
Scheduled
Tue 12-May-20
Power BI Beginner
Adelaide
Scheduled
Mon 25-May-20
Power BI Beginner
Adelaide
Scheduled
Tue 9-Jun-20
Power BI Beginner
Adelaide
Scheduled
Mon 22-Jun-20
Power BI Beginner
Adelaide
Scheduled
Perth
Date
Course
City
Status
Fri 31-Jan-20
Power BI Beginner
Perth
Sold Out
Tue 4-Feb-20
Power BI Beginner
Perth
Few Seats
Thu 6-Feb-20
Power BI Beginner
Perth
Confirmed
Tue 18-Feb-20
Power BI Beginner
Perth
Scheduled
Tue 3-Mar-20
Power BI Beginner
Perth
Scheduled
Tue 17-Mar-20
Power BI Beginner
Perth
Scheduled
Thu 26-Mar-20
Power BI Beginner
Perth
Scheduled
Wed 1-Apr-20
Power BI Beginner
Perth
Scheduled
Tue 14-Apr-20
Power BI Beginner
Perth
Scheduled
Mon 20-Apr-20
Power BI Beginner
Perth
Scheduled
Tue 28-Apr-20
Power BI Beginner
Perth
Scheduled
Wed 6-May-20
Power BI Beginner
Perth
Scheduled
Thu 14-May-20
Power BI Beginner
Perth
Scheduled
Wed 20-May-20
Power BI Beginner
Perth
Scheduled
Wed 27-May-20
Power BI Beginner
Perth
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 10, 333 Adelaide St, Brisbane QLD 4000
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 37 Pitt Street, Sydney NSW 2000
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 90 Phillip Street, Parramatta NSW 2150
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 466 Little Lonsdale St, Melbourne VIC 3000
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 3, 97 Pirie Street, Adelaide SA 5000
microsoft_gold

Power BI Beginner Course Details

Price
$385
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
Level 1, 140 St Georges Tce, Perth WA 6000
microsoft_gold

Power BI Course Outlines

Other Courses
  • Microsoft Office 365 Training Courses
  • Microsoft Excel Training Courses
  • Microsoft Excel Specialist Training Courses
  • Microsoft SharePoint Training Courses
  • Microsoft PowerApps Training Courses
  • Microsoft Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
  • Microsoft Project Training Courses
Course Rating
Microsoft Power BI Training Courses

4.70 5 Microsoft Power BI Training Courses
4.70 out of 5
4914 Student Reviews

Contact Us

What do I need to know to attend?

  • No prior Power BI experience needed
  • Basic understanding of data and visualisation concepts (charts, figures)
  • Intermediate Excel usage (create Excel Tables and have knowledge of Pivot tables)
  • Knowledge of business Intelligence is an advantage but not necessary to benefit from the course
  • Attendees are encouraged to try out Power BI before attending, however also not necessary

Power BI Beginner Learning Outcomes

  • Understand self-service Business Intelligence
  • Build informative dashboards
  • Create many different visualisations
  • Run “Quick Insights” on a dashboard

 

  • Create interactive visuals
  • Design Mobile friendly Dashboards
  • Build a data model
  • Expand Datasets

Power BI Beginner Course Content

  • Introduction
  • A quick history of Business Intelligence
  • The development of Self Service Business Intelligence
  • Introducing the Power BI suite
  • Power BI Service, Power BI desktop & Power BI Mobile
  • Free versus Pro
  • Signing up to the Power BI online service
  • What sources of Data can I use?
  • Online Services
  • Azure & SSAS

 

  • Working with an Excel Workbook
  • Understanding the data you import
  • Creating Tables of data to put into the Power BI service
  • Where your workbook file is saved makes a difference
  • Uploading your Workbook data into Power BI
  • Importing your Workbook data into Power BI

 

  • Working with the Power BI service
  • The User Interface
  • My Workspace
  • Menus
  • The Fields Pane
  • Field Icons
  • Visualisations Pane

 

  • Visualisations
  • Overview of Visualisations
  • Creating and working with Visualisations
  • Creating a Bar Chart Visualisation
  • Creating a Column Chart
  • Visualisation
  • Creating a Line Chart Visualisation
  • Some basic formatting of Visualisations
  • Consistency of Style
  • Focus Mode
  • Creating a Card Visualisation
  • Giving Cards some impact
  • Creating a Table Visualisation
  • Creating a Matrix Visualisation

 

  • Working with Formats in a Visualisation
  • Axes
  • AData Labels
  • Titles
  • Sizing & Alignment
  • Data Colours, Backgrounds and Borders

 

  • Moving from Visualisations to Reports
  • Saving a Report
  • Adding Pages to your Reports
  • Renaming Report Pages
  • Re-using Visualizations
  • Building Narrative in your report
  • Editing & Reading Modes
  • Pie Chart Visualisations
  • Text Boxes
  • Shapes

 

  • Using Visual Interactions
  • Introducing Visual Interaction
  • Turning interaction On or Off
  • Interacting by Filtering, Highlighting or None

 

  • Working with Filters
  • Creating a Slicer
  • Filtering in the Visualisation pane
  • Creating a Visual Field filter
  • Creating a Top N Filter
  • Adding a page level Filter
  • Creating pages from page level filters
  • Add a report level Filter

 

  • Working with Reports
  • Printing your Reports
  • Export your Report to PowerPoint
  • Using a Power BI created PowerPoint file
  • Publishing to the Web – embed codes
  • Interacting with a Power BI created web page
  • Generating a QR code
  • Pasting and scanning a QR code
  • Possible uses for a QR code versus a web-link

 

  • Working with Dashboards
  • Adding Visualisations to your dashboard
  • Adding Visualisations from multiple reports
  • Pinning a Live Page
  • Web Content tiles
  • Text box Tiles
  • Video tiles
  • Generating Alerts from Cards and KPIs
  • Renaming Dashboards
  • Favourite Dashboards
  • Featured Dashboard
  • Printing Dashboards
  • Generating Alerts from Cards and KPIs

 

  • Q & A and Quick Insights
  • Making Visualisations with natural language queries
  • Create a Visual using Q&A
  • Modify a Q&A
  • Activating Quick Insights
  • Using Related Insights
  • Analyse data in a visual

 

  • Power BI Publisher for Excel
  • Installing Power BI Publisher for Excel
  • The Power BI Publisher for Excel ribbon
  • Connecting to your Power BI Profile
  • Pinning Ranges
  • Updating Pinned Ranges
  • Creating new Power BI Dashboards from inside Excel
  • Make a connection from your data in Power BI back to Excel

 

  • Sharing Dashboards
  • Sharing a Dashboard
  • Sharing Permissions
  • Sharing Links
  • Modifying Access to a shared Dashboard
  • Generating a QR code to share a Dashboard

 

  • Power BI Mobile
  • Installing the Power BI mobile apps Settings
  • Signing into your profile
  • Accessing samples
  • Interacting with Dashboards
  • Favourite Dashboards
  • Interacting with Reports
  • Pages in Reports
  • Annotating Reports
  • Sharing a Dashboard
  • QR Scanner

 

  • Refreshing Your Data
  • Refreshing your Datasets
  • Upload file to OneDrive
  • Load data from OneDrive file
  • Scheduled refresh on OneDrive
  • Updating data after changes

 

  • Data Normalisation
  • Overview of Data Normalisation
  • Normalising a dataset
  • Model
  • Using Query
  • Editor in Microsoft Excel
  • Fact and Dimension Tables

 

  • Power BI Desktop
  • Introducing Power BI Desktop
  • Connecting to a database
  • Building a Data Model
  • Using Query Editor
  • Formatting and Properties of Data types and their uses
  • Loading Individual Tables Relationships
  • Creating Relationships.
  • Deleting Relationships.

 

  • More Complex Visualisations
  • Create a Bubble Map Visualization
  • Create a Filled Map Visualization
  • Create a Gauge Visualization
  • Create a Tree Map Visualization
  • Choosing the right Visualisations

 

  • Using Custom Visual
  • Custom Visualisations Gallery
  • Installing a Custom Visualisation
  • Word Cloud
  • Chiclet Slicer
  • Enlighten Aquariuml

 

  • Access Databases and Power BI
  • Access Database & Power BI
  • Importing an Access Database
  • Data Relationships
  • Stacked Column Chart
  • Sorting an Existing Visualisation
  • Adding Depth to your Report
  • Focusing on Key Points of Interest
  • Calculated Columns
  • Adding a Calculated Column
  • Using a Calculated Column in a Calculation
  • Displaying Calculated Columns in a Visualisation

 

  • Content Samples
  • Viewing some content samples
  • Working through the Retail Analysis
  • Sample Pack

 

  • Getting Help
  • The official Microsoft Sources
  • Other sources of help

 

  • Extended Exercise – More Visuals
  • World Flag Slicer
  • Count Down Timer
  • Cards with States
  • Scroller
  • Data Normalisation Appendix
  • The Normal Forms
  • 1st Normal Form
  • 2nd Normal Form
  • 3rd Normal Form
  • Primary Keys
  • Relationships

Why choose Nexacu?

Valued by Individuals

 

4.8/5
Over 18460 Reviews
Course was very good with practical applications covered extremely well. Steven was a very good presenter and covered all the requirements very well -PowerPoint Level 2 Brisbane
Mark - PowerPoint Level 2, .
Thanks Nexacu. Ben did a great job explaining things clearly and answering our individual questions. This was a great day. Many thanks. -Word Intermediate Brisbane
Tempe - Word Intermediate, .
Very helpful course. Teacher was lovely and patient This course is going to help me in my work. Thank you. -PowerPoint Level 2 Brisbane
Loren - PowerPoint Level 2, .
A lot of new information. Lots of info hard to take in everything. Learnt lots -PowerPoint Level 2 Brisbane
Gloria - PowerPoint Level 2, .
Covered a good range of topics and exercises. The course was very interactive which was great. I feel like the course needs to be longer to allow more time to build and practice skills or perhaps offer a beginner and advanced course. There is an awful lot that the software can do. It would be useful to be able to follow along with the manual as I'm worried I'll get lost when I try this in practice. -SharePoint Site Owner Adelaide
Sarah - SharePoint Site Owner, .
Great break down and summary with each section covered. Easy to follow with good examples. Facilitator was able to adjust the course to the different levels within our group. Inspired to try and test my knowledge back in the office. -SharePoint Site Owner Adelaide
Kristine - SharePoint Site Owner, .
It was a very complex topic which got confusing at times but I ended up taking away a lot of new knowledge which will be very useful in my work. -SharePoint Site Owner Adelaide
Cindy - SharePoint Site Owner, .
Fantastic couple of days. Very informative and I appreciate your patience training style. -SharePoint Site Owner Adelaide
Christine - SharePoint Site Owner, .
Jagg explained things well and made the course easy to understand. He is light and entertaining and made the days go fast. Thanks -SharePoint Site Owner Adelaide
Natalie - SharePoint Site Owner, .
Very interesting course -SharePoint Site Owner Adelaide
Jade - SharePoint Site Owner, .
Thank you, this was a very useful course. It is finally tying in all the bits I needed to have a full view of this product. -Power BI DAX Sydney
Wendy - Power BI DAX, .
Very helpful, thanks -Power BI DAX Sydney
Kate - Power BI DAX, .
Good pace and useful content -Office365 Intermediate Parramatta
Linda - Office365 Intermediate, .
was great and very informative. makes using PP seems so easy -PowerPoint Level 2 Melbourne
Fleur - PowerPoint Level 2, .
John was a great trainer. Very easy to follow and understand. I have left today definitely feeling like I have learnt something. Thank you. -PowerPoint Level 2 Melbourne
Jamie - PowerPoint Level 2, .
I thought it was very informative I learnt a lot and would highly recommend -PowerPoint Level 2 Melbourne
Jason - PowerPoint Level 2, .
Great trainer, very informative session. -PowerPoint Level 2 Melbourne
Rachael - PowerPoint Level 2, .
Knowledgeable. Able to answer my queries. -PowerPoint Level 2 Melbourne
Efrat - PowerPoint Level 2, .
Comprehensive course with knowledgeable trainer. -PowerPoint Level 2 Melbourne
Sai - PowerPoint Level 2, .
Very usufull -Excel Advanced Melbourne
wasantha - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia