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

Business Analytics

With tremendous growth in the amount of data being generated by organisations, governments and society, it’s crucial that the leaders of tomorrow understand the tools required to make evidence-based decisions. Learn the foundational skills of business analytics to improve your decision-making

by UTS (University of Technology Sydney) [Claim Listing ]
Logitrain Logo

Microsoft Power BI Course

It is a Business intelligence tool which is used to analyze data and develop insights to draw vital insightful information from it. This is an amazing cloud-based tool which helps in visualizing the data and develop reports.

by Logitrain
Lumify Group Logo

Microsoft PL-300T00 - Microsoft Power BI Data Analyst

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualising, and analysing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and

by Lumify Group [Claim Listing ]
The Quill Consultancy Logo

Microsoft Power BI Data Analyst

Microsoft Power BI Data Analyst course is offered by The Quill Consultancy. Quill training courses are conducted only by highly professional trainers, particularly with Microsoft applications for both PC and Mac.

by The Quill Consultancy [Claim Listing ]
Priority Management Logo

Microsoft Power BI

Microsoft Power BI is a suite of business intelligence (BI) services for performing sophisticated data analysis and creating interactive reports and dashboards. The Power BI suite comprises several products and services, primarily: Power BI Desktop and the Power BI Service.

by Priority Management [Claim Listing ]

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