Centre for Continuing Education

Power BI Course: Intermediate

Data analysis and analytics. Uncover insights and transform your organisation.

COVID-19 update: arrangement of our courses

We are now delivering courses both online and in-person. Please check the delivery format for each class before you enrol.

Please note that course materials for all classes (excluding prescribed textbooks) are shared electronically within 48 hours of a course starting. Printing is not available.


This Power BI Intermediate course will expand on your knowledge and skills, showing you how to create more complex data models, which in turn will result in enhanced visuals and more interactive dashboards.

Using custom slicers, defined functions and calculated measures we will move beyond the basics and build your confidence in connecting, cleansing, and presenting your data in a variety of enriched and valuable formats.

You will also learn the language behind Power Query – allowing you to engineer more complex queries and extract results from a variety of data sources.

Finally – it is important that shared reports are both flexible and secure. We will show you options for sharing and collaborating on dashboards and reports with stakeholders securely via the Power BI cloud Service.

Aims

We want to elevate your dashboards and take your reports to the next level with custom visuals and data transformations from multiple sources. You will also learn to protect and secure the business intelligence that you build, analyse and share with your colleagues.

Outcomes

By the end of this course, you should be able to:

  • break down the basic syntax of the M Power Query language
  • develop functions & keyword structure
  • connect to data from multiple sources
  • comprehend M transformations
  • implement ‘merge’ and other combining queries
  • use multiple queries in an advanced transformation
  • compare differences between calculated columns and measures
  • gain familiarity with standard DAX patterns
  • gain familiarity over the use of Power BI custom visuals
  • share dashboards and reports with a variety of secure methods.

Content

Getting started with M (Power Query language)

  • Power BI M Language overview
  • Basic data import and transform
  • Introduction to text functions
  • Create and apply degenerate dimensions.

Advanced M transformations

  • Power BI M key transformations
  • Power BI M merge types
  • Complex transformation
  • Create budget fact using multi query approach.

DAX calculated columns and measures

  • DAX Level set and foundations
  • Calculated column
  • RELATED function
  • CALCULATE function
  • Default summarisation
  • Measures, including quick measures.

Custom visuals

  • Import custom visuals
  • Custom slicers
  • Create a custom visual
  • Pin a live report as a dashboard.

Sharing and security on the service

  • Share a dashboard or report internally and externally
  • Manage permissions to access a dashboard, report or dataset
  • Collaborate with co-workers to create meaningful reports and dashboards in workspaces
  • Bundle dashboards and reports into apps and distribute them
  • Create shared datasets that your co-workers can use as the basis for their own reports in their own workspaces
  • Embed a report in Microsoft Teams
  • Print reports
  • Embed reports in secure portals such as SharePoint, or public web sites.

Intended audience

Anyone interested in data visualisation.

Prerequisites

No prior knowledge of programming languages is required. It is recommended that you are comfortable with the learning outcomes equivalent to our Microsoft Excel Course: Level 2. In particular, the use of Tables.

Delivery style

Delivery options:

  • Presenter-taught, computer-based training in a computer lab on University premises. Follow along step-by-step as the facilitator demonstrates key concepts and gives you practical exercises to attempt at your computer.
  • Online training via the platform Zoom.

Materials

You will be provided with an electronic copy of the course workbook and exercise files.

Additional information

Face-to-face classes

These classes run in a computer lab and you do not need to bring your own device.

Please bring a USB flash drive to class if you would like to make a copy of your work or any relevant class materials. Alternatively, you can save these to a cloud storage space or email them to your personal email address.

Online classes

If you are attending an online class, you will need your own device with a Windows operating system. Power BI desktop only runs on a Windows operating system. It does NOT operate on Mac.

You will be provided with a login to Power BI pro – the cloud application. However, you can choose to use your own Power BI pro license if you have one.

Features

  • Expert trainers
  • Central locations
  • Course materials – yours to keep
  • CCE Statement of Completion

Power BI Course: Intermediate

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI Intermediate course will expand on your knowledge and skills, showing

...
Power BI Course: Intermediate

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI Intermediate course will expand on your knowledge and skills, showing

...
Power BI Course: Intermediate

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI Intermediate course will expand on your knowledge and skills, showing

...
Power BI Course: Intermediate

<p>{block name:“Course Tagline - Data Analysis and Analytics”}</p><p>{block name:“Block - COVID 19 updates”}</p><p>This Power BI Intermediate course will expand on your knowledge and skills, showing

...
We acknowledge the tradition of custodianship and law of the Country on which the University of Sydney campuses stand. We pay our respects to those who have cared and continue to care for the Country.