Power BI Course (Level 2A)

by The University of Sydney Claim Listing

This intermediate Power BI 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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

The University of Sydney Logo

img Duration

8 Hours

Course Details

This intermediate Power BI 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:

  • understand procedures related to data acquisition and transformation

  • comprehend the concept of DAX hierarchies

  • comprehend necessity and procedure for creating a date table

  • identify the purpose of the Calculate and Related DAX functions

  • work with DAX measures

  • work with aggregations

  • work with Custom Visuals to gain BI insights

  • work with the Power BI service to share datasets and reports

  • embed reports in SharePoint

  • embed reports in MS Teams

  • publish and export reports in different formats including CSV, PDF & XLSX.

 

Content

Getting Data and Key Transform Mechanisms

  • Accessing Various Data Sources

  • Basic Data Import and Transform

  • Introduction to Text Functions

  • M Language Overview

Advanced Transformations

  • Key Transformations

    • Power Query Editor

    • Remove Top Rows

    • Pivot Columns

    • UnPivot Columns

    • Combining Tables

  • Profiling Data

  • Evaluate and Change Column Data Types

Calculated Columns and Measures

  • DAX Hierarchies

  • Manually Creating Hierarchies

  • Create a Date Table

  • Calculated Columns

  • Creating Measures

  • Default Summarisation

Working with Custom Visuals

  • Import Custom Visuals

  • The Q & A Visual

  • Decomposition Tree Visual

  • Work with Custom Slicers

  • Pin a Live Report as a Dashboard

Sharing Reports Securely using the Power BI Service

  • What is a Workspace?

  • Creating a Workspace

  • Assign Workspace roles

  • Creating and Sharing a Dashboard

  • The Power BI Service Portal

  • Creating and Sharing a Dashboard

  • Sharing Our Report Internally

  • Sharing Our Reports Externally

  • Manage Permissions to a Report

  • Sharing Dashboards

  • Sharing Datasets

  • Publish Shared Datasets as Apps

  • Embed a Report in MS Teams

  • Publish and Export Reports

  • Embed Reports in SharePoint

 

Intended Audience

  • Anyone interested in data visualisation.

 

Prerequisites

It is recommended that you are comfortable with the learning outcomes equivalent to our Power BI Course: Level 1.

 

Delivery Modes

  • Face-to-face, presenter-taught training

  • Online training via the platform Zoom

 

Delivery Style

  • Face-to-face classes (CCE, Newtown)

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

  • Face-to-face classes (external venue including PARKROYAL, Cliftons and CBD)

These classes run in a classroom and you need to bring your own device with a Windows operating system.

  • Online classes

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.

 

Materials

  • A course workbook and exercise files is distributed electronically.

 

Before The Course

Please ensure Power BI Desktop is installed on your device before class. It can be downloaded from the Microsoft Website.

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.

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.

  • Sydney Branch

    160 Missenden Rd, Sydney

Check out more Power BI courses in Australia

UTS (University of Technology Sydney) Logo

Advanced Data Visualization

Designed for professionals with some experience in data visualisation, this microcredential introduces advanced techniques to visualise varied nd complex data sets.

by UTS (University of Technology Sydney) [Claim Listing ]
ILX Group Australia Logo

Power BI

It provides interactive visualisations with self-service business intelligence capabilities, so you can create reports and dashboards by yourself, without having to depend on IT staff or database administrators.

by ILX Group Australia [Claim Listing ]
Odyssey Training Logo

Microsoft Power BI Introduction

Anyone wanting to create powerful interactive dashboards, chart and a range of visualisations to display data in a user friendly way from a range of sources.

by Odyssey Training [Claim Listing ]
Access Analytic Logo

Power BI Essentials

All the key aspects you need to know to begin developing Power BI reports for your business. Before you proceed, just to let you know, we sometimes find that people would be better learning the Power BI features that are already built into Exce

by Access Analytic [Claim Listing ]
Dynamic Web Training Logo

Power BI Essentials Course

This Power Bi Beginner course is suitable for the people who have no or very little understanding of Microsoft Power BI tool. To get the most out of this course, some expertise in using Microsoft Excel is necessary especially with VLOOKUP and Pivot table. An understanding of key business constructs

by Dynamic Web Training

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy