Microsoft Power BI Fundamentals

Power BI Fundamentals training Melbourne

Overview

Microsoft Power BI training course in Melbourne and across Australia.  Face-to-face Power BI training or Live online Power BI training courses available.

Learn how to analyse large amounts of data from different data sources and then create powerful interactive dashboards, charts and a range of visualisations to display data in a user friendly way.

What you’ll learn:

  • Gain insight into business intelligence and how to use Power BI.
  • Create a range of interactive visualisations including a range of charts, tables, matrixes and maps.
  • How to publish and share your data.

Power Bi Fundamentals Course Outline

File size: 304 kb

Power BI Fundamentals exercise files

File size: 2 mB

Inclusions

  • Live instructor led training
  • Comprehensive training manual
  • Training certificate

Course prerequisites

Due to some similarities between Excel and Power BI, participants will need to be familiar with Excel to an Advanced level, including a good understanding of Charts, Tables and PivotTables.

No previous experience with Power BI is required.

What's covered

Getting started
  • Power BI Environment
  • Using Power BI
  • The building blocks of Power BI
  • Overview Power BI Service, Desktop, Mobile
Getting data and creating reports
  • Getting started with Power BI Desktop
  • Upload various data types to Power BI
  • Creating a Report
  • Navigating a Report
  • Publish a Report • View a Published Report in Power BI Service
  • Connect to data sources in Power BI Desktop
Clean Data with the Query Editor
  • More advanced data sources and transformation
  • Cleaning irregularly formatted data
Modelling in Power BI
  • Introduction to modelling your data
  • Database relationships
  • Create calculated columns
  • Optimising data models
  • Create calculated measures with introductory DAX
  • Create calculated tables
  • Working with time-based data
Create visualisations
  • Create charts
  • Create Table visualisations with drag and drop
  • Create a Treemap
  • Combination charts
  • Using Slicers
  • Map visualisations
  • Matrixes and tables
  • Gauge visualisation
Modify visualisations and reports
  • Modify colours in charts and visuals
  • Adding shapes, text boxes, and images
  • Page layout and formatting
  • Group interactions among visualisations
  • Duplicate a report page
  • Show categories with no data
  • Summarisation and category options
  • Rearrange visualisations
  • Visual hierarchies and drill-down
Power BI Service - create and view dashboards
  • Introduction to the Power BI service
  • Pin visualisations to a dashboard
  • Create and configure a dashboard
  • Share dashboards with your organisation
  • Display visuals and tiles full-screen
  • Edit tile details and add widgets
  • Display dashboard in full screen
  • Publishing and sharing
  • Publish Power BI Desktop reports
  • Print and export dashboards and reports
  • Manually republish and refresh your data

PRIVATE SESSION

Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.

from $198 per person
Course Length: 1 day

PUBLIC SESSION

Join a public course session conducted LIVE ONLINE via Microsoft Teams.

$385 per person

Public session Available dates:

May 06
0
9:00 am - 4:30 pm

Learn how to analyse large amounts of data from different data sources and then create powerful interactive dashboards, charts and a range of visualisations to display data in a user friendly way.

Our Microsoft Power BI training course can be delivered face-to-face in Melbourne or live online across Australia.

Get a quote for a group

Enquire

Enrol

Private Session

Link partner: max77 gopek178 ondel4d sirkuit4d spade88 slot188 qqmobil area188 sky77 bro138 slot5000 luxury333 batman138 bos88 roma77 indobet zeus138jaya.org ligaplay88 toto togel slot88 warungtoto pokerseri autowin88 vegas77 vegasslot77 mantra88 sensa gaming