Microsoft Power BI Intermediate

Overview

Microsoft Power BI Intermediate 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:

  • Advanced Power Query data cleanup techniques.
  • M Functions in Power Query
  • Use DAX formulas and Functions for custom visualisations.
  • Add Page Navigation with Bookmarks and Drilldown
  • Custom Tooltips
  • Working with Dates
  • Workspaces and Apps

Power BI Intermediate Course Outline

File size: 785 kb

Inclusions

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

Course prerequisites

Power BI Fundamentals or equivalent is prerequisite for the course.

What's covered

Power Query Editor
  • Advanced data transformation
  • Cleaning irregularly formatted data
  • Adding Columns
  • Merge and Append Queries
  • Query from a Folder
  • View and Edit M Code
M Functions
  • Text and dates Date functions
  • Column from Examples
  • Custom Column Functions
  • Blank queries
Modelling in Power BI
  • Database relationships
  • Create calculated DAX columns
  • Create calculated measures with DAX
Dates
  • Create Date tables
  • CALENDERAUTO function
  • Working with time-based data
  • Date based data comparisons with DAX
  • SAMEPERIODLASTYEAR function
  • TOTALYTD and TOTALMTD functions
DAX
  • Columns and Measures
  • CALCULATE
  • SUMX, AVERAGEX etc.
  • FILTER
  • ALL, ALLEXCEPT, ALLSELECTED
  • IF, SWITCH, FIND
  • RELATED
  • Manage Measures
  • DAX Structure
DAX in Visualisations
  • Use Measures to populate Fields in Visualisations
  • Conditional Formatting
User Navigation
  • Bookmarks
  • Buttons
  • Hyperlinks
Custom Tooltips
  • Tooltip Page
  • Page Settings
  • Applying Tooltips
Power BI Service - Workspaces and Apps
  • Creating a Workspace
  • Managing Workspace Access
  • Publish to a Workspace
  • Create and Publish an App

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.

$390 per person

Public session Available dates:

May 28
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.

Extend your learning by diving into DAX to create formulas and functions for custom data analysis.

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