Skip to main content

Post an event

Sign in

Disclaimer: Due to the current uncertainty regarding coronavirus, many events are being cancelled. Please contact the event organiser directly via the contact details on the listing if you are unsure.

Microsoft Power BI Intermediate - 1 Day Course -Brisbane

  • Tue 1st Dec 2020, 9:00 AM - 4:00 PM
  • Santos House, Level 1/60 Edward St, Brisbane City QLD 4000
  • Book Tickets
  • View Website

This course is ideal for

This intermediate course is ideal for those seeking to create a solid dataset underlying Power BI’s reports and dashboards.

What you will learn

    • Pull data from a variety of sources

    • Transform a poorly formed data source into a clean source

    • Create a variety of more advanced visuals, including maps

    • Use a variety of DAX functions to create more complex measures, columns and tables

    • Determine the right method of data refresh for a data source

    • Share via Power BI workspace apps

Topics covered in this training course

Import from various data sources

  • web data

  • SharePoint data

  • SQL server database

  • manual data refresh

Query editor transformations

  • promoting headers

  • removing rows from tables

  • creating columns

  • filtering data

  • filling null area with values

  • replacing values

  • parsing dates – year, qtr, month

  • removing duplicates

  • working with applied query steps

Calculated dates

  • tables

  • using CALENDARAUTO to create a date table

  • DAX date functions

  • FORMAT function

  • CONCATENATE function

Advanced measures with DAX functions

  • quick measures

  • IF function and logical operators

  • SWITCH function

  • RELATED function

  • SUMX AVERAGEX functions

More complex visualisations

  • requirements for map visuals

  • bubble map

  • filled map

  • conditional formatting

  • insights

  • visuals with Q & A

  • analytics pane

Power BI Service workspaces

  • sharing in Power BI service

  • collaborate in workspaces

  • creating an app workspace (updated workspaces)

  • publishing to an app workspace

  • create and publish an app

  • embed a SharePoint page

Category Business