Previously Excel Consulting

power bi courses nexacu

Microsoft Power BI Training - Beginner

Create visuals, collaborate on reports and interactive dashboards. 

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.

 

Brisbane
Sydney
Parramatta
Melbourne
Canberra
Adelaide
Perth
Upcoming Courses:
Brisbane
Date
Course
City
Status
Thu 14-Nov-19
Power BI Beginner
Brisbane
Sold Out
Mon 18-Nov-19
Power BI Beginner
Brisbane
Sold Out
Tue 19-Nov-19
Power BI Beginner
Brisbane
Few Seats
Fri 22-Nov-19
Power BI Beginner
Brisbane
Sold Out
Wed 27-Nov-19
Power BI Beginner
Brisbane
Scheduled
Mon 2-Dec-19
Power BI Beginner
Brisbane
Confirmed
Tue 10-Dec-19
Power BI Beginner
Brisbane
Confirmed
Wed 18-Dec-19
Power BI Beginner
Brisbane
Confirmed
Mon 6-Jan-20
Power BI Beginner
Brisbane
Scheduled
Fri 10-Jan-20
Power BI Beginner
Brisbane
Scheduled
Mon 20-Jan-20
Power BI Beginner
Brisbane
Scheduled
Fri 31-Jan-20
Power BI Beginner
Brisbane
Scheduled
Thu 6-Feb-20
Power BI Beginner
Brisbane
Scheduled
Mon 17-Feb-20
Power BI Beginner
Brisbane
Scheduled
Wed 26-Feb-20
Power BI Beginner
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Thu 14-Nov-19
Power BI Beginner
Sydney
Few Seats
Mon 25-Nov-19
Power BI Beginner
Sydney
Few Seats
Mon 2-Dec-19
Power BI Beginner
Sydney
Few Seats
Tue 10-Dec-19
Power BI Beginner
Sydney
Confirmed
Wed 18-Dec-19
Power BI Beginner
Sydney
Scheduled
Mon 6-Jan-20
Power BI Beginner
Sydney
Scheduled
Fri 10-Jan-20
Power BI Beginner
Sydney
Scheduled
Tue 21-Jan-20
Power BI Beginner
Sydney
Scheduled
Fri 31-Jan-20
Power BI Beginner
Sydney
Scheduled
Thu 6-Feb-20
Power BI Beginner
Sydney
Scheduled
Mon 17-Feb-20
Power BI Beginner
Sydney
Scheduled
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
Parramatta
Date
Course
City
Status
Mon 18-Nov-19
Power BI Beginner
Parramatta
Confirmed
Wed 18-Dec-19
Power BI Beginner
Parramatta
Scheduled
Mon 6-Jan-20
Power BI Beginner
Parramatta
Scheduled
Tue 21-Jan-20
Power BI Beginner
Parramatta
Scheduled
Thu 6-Feb-20
Power BI Beginner
Parramatta
Scheduled
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
Melbourne
Date
Course
City
Status
Tue 12-Nov-19
Power BI Beginner
Melbourne
Sold Out
Thu 14-Nov-19
Power BI Beginner
Melbourne
Sold Out
Wed 20-Nov-19
Power BI Beginner
Melbourne
Confirmed
Fri 22-Nov-19
Power BI Beginner
Melbourne
Sold Out
Mon 2-Dec-19
Power BI Beginner
Melbourne
Few Seats
Tue 10-Dec-19
Power BI Beginner
Melbourne
Scheduled
Wed 18-Dec-19
Power BI Beginner
Melbourne
Scheduled
Mon 6-Jan-20
Power BI Beginner
Melbourne
Scheduled
Fri 10-Jan-20
Power BI Beginner
Melbourne
Scheduled
Tue 21-Jan-20
Power BI Beginner
Melbourne
Scheduled
Fri 31-Jan-20
Power BI Beginner
Melbourne
Scheduled
Thu 6-Feb-20
Power BI Beginner
Melbourne
Scheduled
Mon 17-Feb-20
Power BI Beginner
Melbourne
Scheduled
Wed 26-Feb-20
Power BI Beginner
Melbourne
Scheduled
Tue 3-Mar-20
Power BI Beginner
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Tue 3-Dec-19
Power BI Beginner
Canberra
Confirmed
Wed 18-Dec-19
Power BI Beginner
Canberra
Scheduled
Fri 10-Jan-20
Power BI Beginner
Canberra
Scheduled
Tue 21-Jan-20
Power BI Beginner
Canberra
Scheduled
Thu 6-Feb-20
Power BI Beginner
Canberra
Scheduled
Tue 18-Feb-20
Power BI Beginner
Canberra
Scheduled
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
Adelaide
Date
Course
City
Status
Mon 18-Nov-19
Power BI Beginner
Adelaide
Few Seats
Tue 3-Dec-19
Power BI Beginner
Adelaide
Few Seats
Wed 4-Dec-19
Power BI Beginner
Adelaide
Scheduled
Wed 18-Dec-19
Power BI Beginner
Adelaide
Scheduled
Fri 10-Jan-20
Power BI Beginner
Adelaide
Scheduled
Tue 21-Jan-20
Power BI Beginner
Adelaide
Scheduled
Thu 6-Feb-20
Power BI Beginner
Adelaide
Scheduled
Tue 18-Feb-20
Power BI Beginner
Adelaide
Scheduled
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
Scheduled
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
Perth
Date
Course
City
Status
Wed 13-Nov-19
Power BI Beginner
Perth
Few Seats
Mon 18-Nov-19
Power BI Beginner
Perth
Sold Out
Tue 3-Dec-19
Power BI Beginner
Perth
Confirmed
Wed 18-Dec-19
Power BI Beginner
Perth
Scheduled
Mon 6-Jan-20
Power BI Beginner
Perth
Confirmed
Tue 21-Jan-20
Power BI Beginner
Perth
Scheduled
Thu 6-Feb-20
Power BI Beginner
Perth
Scheduled
Tue 18-Feb-20
Power BI Beginner
Perth
Scheduled
Mon 2-Mar-20
Power BI Beginner
Perth
Scheduled
Tue 17-Mar-20
Power BI Beginner
Perth
Scheduled
Fri 20-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
Mon 27-Apr-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
Level 1 (Ethos House) 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 CBD, WA, 6000
microsoft_gold

Power BI Beginner Course Outlines

  • Power BI Beginner
  • Power BI Intermediate
  • Power BI Advanced
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 Project Training Courses
  • Microsoft Visio Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
Course Rating
Microsoft Power BI Training Courses

4.69 5 Microsoft Power BI Training Courses
4.69 out of 5
4200 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 16337 Reviews
Excellent introduction to Macro's Great run through pivots -Excel Advanced Brisbane
Clinton - Excel Advanced, .
Very useful. I wish we could cover more. -Excel Advanced Brisbane
Corinne - Excel Advanced, .
data consolidation was good -Excel Advanced Brisbane
Ashlee - Excel Advanced, .
Very good and highly informative. Lots of new information that I can now experiment with. -Excel Advanced Brisbane
Stuart - Excel Advanced, .
Excellent course, learnt a lot that will help me with my job -Excel Advanced Brisbane
Amy - Excel Advanced, .
The pace was good and the instructor remained aware of who was keeping up which is nice. I learnt a few things I didn't know but I guess about half of the content was known to me. good day thank you -Power BI Advanced Brisbane
Bonnie - Power BI Advanced, .
Great course. Afternoon content especially interesting. -Power BI Advanced Brisbane
Jennifer - Power BI Advanced, .
Good course. -Power BI Advanced Brisbane
Esther - Power BI Advanced, .
Good course. Learnt a lot. -Power BI Advanced Brisbane
Sarah - Power BI Advanced, .
great step by step instructions and also note to take home -Power BI Advanced Brisbane
Priyal - Power BI Advanced, .
Really good, will be implementing quite a few of the things i learnt today when i get back to work tomorrow. Good pace, clear instructor. -Power BI Advanced Brisbane
Gihan - Power BI Advanced, .
Well structured course. -Power BI Advanced Brisbane
Glen - Power BI Advanced, .
I found Jacqui to be an enthusiastic and very knowledgeable tutor. she was keen to make sure all the class not only worked at their own pace, but ensured that they were able to complete all exercise tasks - she is a great asset to your company -Project Beginner Adelaide
Chris - Project Beginner, .
excellent -Excel Advanced Melbourne
patelharshal1011@gmail.com - Excel Advanced, .
Great new tools - Excel Advanced Melbourne
Sabrina - Excel Advanced, .
Very good -Excel Advanced Melbourne
Sophea - Excel Advanced, .
A great course -Project Beginner Canberra
ivan - Project Beginner, .
Tim is professional and helpful with questions -Excel Advanced Melbourne
Anna - Excel Advanced, .
Very interesting to learn new functions. -Excel Advanced Melbourne
Taihla - Excel Advanced, .
Clear, concise and relevant. -Excel Advanced Melbourne
Suzanne - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia