Microsoft Power BI Intermediate - 1 Day Course - Sydney

Event Information

Share this event

Date and Time

Location

Location

Odyssey Training

Suite 1

Level 2, 45 Clarence Street

Sydney, NSW 2000

Australia

View Map

Refund Policy

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Event description

Description

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

Date and Time

Location

Odyssey Training

Suite 1

Level 2, 45 Clarence Street

Sydney, NSW 2000

Australia

View Map

Refund Policy

Contact the organiser to request a refund.

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved