1300 888 724 8.30am to 5:30pm AEST (Mon-Fri) info@dynamicwebtraining.com.au

Power BI Essentials Course

(4.82 out of 5) 637 Student Reviews

About the Course

During this 1-day course, you will learn how to develop and share reports and dashboards using Microsoft Power BI. During the course, students will use excel data sets as examples to explore various features and functionalities of MS Power BI and learn the underlying concepts that make Power BI Desktop such a powerful Business Intelligence tool. Upon completion of this course, students will gain a solid foundational and practical knowledge of the tool which will prepare you for more advanced courses.

Who should do this course?

This course is suitable for excel users who wants to implement BI to create reports and dashboard or SQL Server report creators who are interested in alternative methods of presenting data.

Prerequisites

This Power Bi Beginner course is suitable for the people who have no or very little understanding of Microsoft Power BI tool. To get the most out of this course, some expertise in using Microsoft Excel is necessary especially with VLOOKUP and Pivot table. An understanding of key business constructs such as revenue, profitability, and financial reporting is desirable but not necessary.

Course Details

  • $385 incl GST
  • Duration: 1 Days
  • Max. Class Size: 10
  • Avg. Class Size: 5
  • Study Mode: Classroom Online Live
  • Level: Beginner
  • Times: 9.00am to 5.00pm approx
  • Download Course PDF
  • Enquire Book Now
    Pay later

Online Live - Course Dates

  • Online Live Class Dates

    Book Now
    19 Apr 21 Mon Online Live
    03 May 21 Mon Online Live
    19 May 21 Wed Online Live
    02 Jun 21 Wed Online Live
    18 Jun 21 Fri Online Live
    29 Jun 21 Tue Online Live
    16 Jul 21 Fri Online Live
    26 Jul 21 Mon Online Live
    11 Aug 21 Wed Online Live
    27 Aug 21 Fri Online Live
    08 Sep 21 Wed Online Live
    23 Sep 21 Thu Online Live
  • To inquire about Online Live Classes, please

    Call 1300 888 724

In-Class - Course Dates

  • Sydney Class Dates

    Book Now

    Level 11, 32 Walker Street, North Sydney , NSW 2060

    13 Apr 21 Tue Classroom
    19 Apr 21 Mon Online Live
    03 May 21 Mon Online Live
    04 May 21 Tue Classroom
    19 May 21 Wed Online Live
    25 May 21 Tue Classroom
    02 Jun 21 Wed Online Live
    11 Jun 21 Fri Classroom
    18 Jun 21 Fri Online Live
    24 Jun 21 Thu Classroom
    29 Jun 21 Tue Online Live
    12 Jul 21 Mon Classroom
    16 Jul 21 Fri Online Live
    26 Jul 21 Mon Online Live
    04 Aug 21 Wed Classroom
    11 Aug 21 Wed Online Live
    25 Aug 21 Wed Classroom
    27 Aug 21 Fri Online Live
    06 Sep 21 Mon Classroom
    08 Sep 21 Wed Online Live
    23 Sep 21 Thu Online Live
    29 Sep 21 Wed Classroom
  • Melbourne Class Dates

    Book Now

    Level 12, 379 Collins Street, Melbourne , VIC 3000

    19 Apr 21 Mon Online Live
    30 Apr 21 Fri Classroom
    03 May 21 Mon Online Live
    12 May 21 Wed Classroom
    19 May 21 Wed Online Live
    25 May 21 Tue Classroom
    02 Jun 21 Wed Online Live
    09 Jun 21 Wed Classroom
    18 Jun 21 Fri Online Live
    23 Jun 21 Wed Classroom
    29 Jun 21 Tue Online Live
    30 Jun 21 Wed Classroom
    16 Jul 21 Fri Online Live
    23 Jul 21 Fri Classroom
    26 Jul 21 Mon Online Live
    05 Aug 21 Thu Classroom
    11 Aug 21 Wed Online Live
    16 Aug 21 Mon Classroom
    27 Aug 21 Fri Online Live
    03 Sep 21 Fri Classroom
    08 Sep 21 Wed Online Live
    14 Sep 21 Tue Classroom
    23 Sep 21 Thu Online Live
    30 Sep 21 Thu Classroom
  • Brisbane Class Dates

    Book Now

    Level 6, 371 Queen Street, Brisbane , QLD 4000

    19 Apr 21 Mon Online Live
    27 Apr 21 Tue Classroom
    03 May 21 Mon Online Live
    17 May 21 Mon Classroom
    19 May 21 Wed Online Live
    02 Jun 21 Wed Online Live
    11 Jun 21 Fri Classroom
    18 Jun 21 Fri Online Live
    28 Jun 21 Mon Classroom
    29 Jun 21 Tue Online Live
    15 Jul 21 Thu Classroom
    16 Jul 21 Fri Online Live
    26 Jul 21 Mon Online Live
    06 Aug 21 Fri Classroom
    11 Aug 21 Wed Online Live
    24 Aug 21 Tue Classroom
    27 Aug 21 Fri Online Live
    08 Sep 21 Wed Online Live
    23 Sep 21 Thu Online Live
    24 Sep 21 Fri Classroom
  • Canberra Class Dates

    Book Now

    Level 4, 54 Marcus Clarke Street, Canberra , ACT 2601

    19 Apr 21 Mon Online Live
    03 May 21 Mon Online Live
    19 May 21 Wed Online Live
    02 Jun 21 Wed Online Live
    18 Jun 21 Fri Online Live
    29 Jun 21 Tue Online Live
    16 Jul 21 Fri Online Live
    26 Jul 21 Mon Online Live
    11 Aug 21 Wed Online Live
    27 Aug 21 Fri Online Live
    08 Sep 21 Wed Online Live
    23 Sep 21 Thu Online Live
  • Adelaide Class Dates

    Book Now

    19 Young Street, Adelaide , SA 5000

    19 Apr 21 Mon Online Live
    03 May 21 Mon Online Live
    10 May 21 Mon Classroom
    19 May 21 Wed Online Live
    02 Jun 21 Wed Online Live
    18 Jun 21 Fri Online Live
    25 Jun 21 Fri Classroom
    29 Jun 21 Tue Online Live
    16 Jul 21 Fri Online Live
    23 Jul 21 Fri Classroom
    26 Jul 21 Mon Online Live
    11 Aug 21 Wed Online Live
    18 Aug 21 Wed Classroom
    27 Aug 21 Fri Online Live
    08 Sep 21 Wed Online Live
    13 Sep 21 Mon Classroom
    23 Sep 21 Thu Online Live
  • Perth Class Dates

    Book Now

    Level 1, 140 St Georges Terrace, Perth , WA 6000

    19 Apr 21 Mon Online Live
    03 May 21 Mon Online Live
    19 May 21 Wed Online Live
    02 Jun 21 Wed Online Live
    18 Jun 21 Fri Online Live
    29 Jun 21 Tue Online Live
    16 Jul 21 Fri Online Live
    26 Jul 21 Mon Online Live
    11 Aug 21 Wed Online Live
    27 Aug 21 Fri Online Live
    08 Sep 21 Wed Online Live
    23 Sep 21 Thu Online Live

Course Units

Expand full topic list

Unit 1: Understanding Business Intelligence

  • Why is Data Analytics Important?
  • Why is conventional Data Analysis Process inefficient?
  • What is Business Intelligence?
  • Steps & concepts involved in Business Intelligence
  • Other BI Tools in the Market
  • What is Self Service BI?

See more

Unit 2: Understanding Power BI

  • Power BI (Desktop Vs Mobile Vs Service)
  • Licenses (Free Vs Pro Vs Premium)
  • What makes Power BI different from other BI Tools?
  • Frequent Updates and Changes
  • BI Steps in Power BI
  • Languages Involved in Power BI (Power Query, DAX, R)

See more

Unit 3: Getting Started with Power BI

  • Setting up Office 365 Enterprise E3 trial account
  • Signing up for Power BI
  • Upgrading to Power BI PRO
  • Downloading Power BI Desktop

See more

Unit 4: Getting Data in Power BI Desktop

  • Understanding Power BI Navigation
  • Exploring Different Data Sources in Power BI
  • Getting Data from Web
  • Getting Data from Azure SQL Data base
  • Getting Data from Azure SQL Database using SQL statement
  • Getting Data from Access File
  • Getting Data from Excel

See more

Unit 5: Data Transformation

  • Navigating Query Editor
  • What is Query?
  • What is Data Transformation?
  • Removing empty rows
  • Removing irrelevant Columns
  • Renaming Columns
  • Changing Data Types
  • Duplicating Columns
  • Splitting Columns
  • Merging Columns
  • Correcting Spelling Mistakes
  • Changing cases
  • Trimming & Cleaning

See more

Unit 6: Introduction to Power Query (M Formula Language)

  • Exploring Applied Steps
  • Introducing idea of repeatable workflows
  • Updating Applied Steps
  • Deleting Applied Steps
  • Renaming Applied Steps
  • Understanding the Code behind every step
  • Automating Data Transformation process via repeatable workflows
  • Exploring Advanced Editor
  • Loading and Applying Data

See more

Unit 7: Data Modelling

  • Understand Navigation of Relationship view
  • What is Data Model?
  • What is a unique Identifier?
  • Creating a new relationship
  • Editing a relationship
  • Updating a relationship
  • Understanding Cardinality
  • Understanding Cross Filter Direction
  • Why is Data Model more efficient than a Flattened Data Set?

See more

Unit 8: Introduction to DAX

  • What can we calculate using DAX?
  • What is Calculated Columns and Calculated Measure?
  • How is DAX different from Excel Functions?
  • Calculating a column using DAX
  • Calculating a measure using DAX
  • Formatting Data types
  • Changing property of a Data Type

See more

Unit 9: Data Visualization

  • Understand Navigation of Report View
  • Creating a Bar Chart
  • Formatting a Bar Chart
  • Changing Chart Type
  • Creating and Formatting a Column Chart
  • Creating and Formatting a Line Chart
  • Creating and Formatting a Pie Chart
  • Creating and Formatting a Tree Chart
  • Creating and Formatting a Card
  • Creating and Formatting a Matrix
  • Creating and Formatting a Table
  • Creating and Formatting BubbleMap Visualization
  • Creating a Filled Map Visualization

See more

Unit 10: Creating Custom Visuals

  • Getting Custom Visuals from the Store
  • Creating Sankey Chart
  • Creating Radar Chart

See more

Unit 11: Visual Interaction

  • Understanding Visual Interaction
  • Turning visual interaction on and off

See more

Unit 12: Exploring Filters

  • Cross Filtering through visuals
  • Creating a slicer
  • Visual level filter
  • Page Level Filter
  • Report Level Filter
  • Drill through filter
  • Top N Filter

See more

Unit 13: Creating Custom Slicers

  • Getting Custom Slicer From Store
  • Creating Enlighten Word Flag Slicer
  • Creating Chiclet Slicer
  • Inserting Images in Chiclet Slicer

See more

Unit 14: Exploring Power BI Desktop Features

  • Exploring visual options (focus mode, show data, spotlight, export)
  • Create and Duplicate New Pages
  • Create image, text boxes and shapes
  • Switch between phone and web layout
  • Save the report
  • Print the report
  • Publish report to Power Bi Service

See more

Unit 15: Power Bi service Features

  • Log in to Power Bi Service
  • Understand Navigation
  • Opening and Editing your report in Power BI service
  • Publishing to web
  • Converting report to a Power Point
  • Generating a QR Code
  • How to get Data directly into Power Bi Service
  • Importing Data Vs Uploading Data

See more

Unit 16: Dashboard

  • Pin visuals from report to dashboard
  • Difference between report and dashboard
  • Why visual interaction isn't supported in Dashboards
  • Resizing and moving a visual
  • Creating a video tile
  • Creating an image tile
  • Applying alert on Card
  • Pinning complete report to Dashboard
  • Customizing dashboard for mobile view
  • Sharing dashboard with colleagues
  • Viewing Shared Reports

See more

Unit 17: Natural Language Query

  • What is NLQ and why is it a breakthrough
  • Create a Card using NLQ
  • Create a Table Using NLQ
  • Create Bar Visual Using NLQ
  • Pin the visuals directly to your dashboard

See more

Unit 18: Power Bi publisher for excel

  • Installing the Add-in
  • Activating this Add-in in Excel
  • Connect your Excel Workbook with Power Bi
  • Pin a chart from Excel to Power Bi Dashboard
  • Pin a pivot table from Excel to Power Bi Dashboard
  • Update the Chart in Power Bi Dashboard from Excel

See more

Unit 19: Quick Insights

  • What is Quick Insight Tool?
  • How to create quick insights of a dataset
  • Explore visuals created by this option
  • Pin a visual to dashboard

See more

Unit 20: Sample Reports and Dashboard

  • Getting the Sample reports and Dashboard
  • How samples are very helpful?
  • Editing sample reports and dashboard

See more

Unit 21: Power Bi mobile

  • Downloading power bi mobile app and logging in
  • Understand Navigation
  • How to see underlying reports
  • Annotate visuals and share using other apps
  • How to see our own dashboard
  • How to see dashboard shared with us
  • See report using QR scanner
  • Exploring mobile sample reports

See more

Related Courses

Course Reviews

(5.00 out of 5) Liz M [ 01 April, 2021 ]
Great course and very clear presentation. Good examples and the ability to come back and resit for support.
(5.00 out of 5) Jessie S [ 01 April, 2021 ]
Really enjoyable and engaging session - Very evident that Adam is extremely knowledgeable. There could be value in allowing time or offering a separate session for students to use their own data.
(5.00 out of 5) Anna F [ 15 March, 2021 ]
With fairly limited exposure to the use of Power Bi, I have vastly increased my understanding of data sets and how to set these up to properly run reports. I found Adam to be a great facilitator and explained everything really clearly and at a great pace.
(5.00 out of 5) Supreethi P [ 15 March, 2021 ]
Very Informative and well Structured. Instructor, Adam has been extremely helpful and patient in explaining every question using different examples.

Read all course reviews

Enquire Now

Fill in your details to have a training consultant contact you to discuss your training needs.

Your details

Other Ways To Get In Touch

You can also Book Online or call us on 1300 888 724

Back to Top