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.
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
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
These classes run in a computer lab and you do not need to bring your own device.
These classes run in a classroom and you need to bring your own device with a Windows operating system.
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
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.
If you wish to learn English at the University of Sydney, consider enrolling in an English course with CET. CET contributes to the University of Sydney's efforts to support international students through the provision of preparatory English language courses.
Our English teachers are highly qualified above and beyond the stringent standards of the Tertiary Education Quality and Standards Agency (TEQSA). CET is a fully accredited English school.
Designed for professionals with some experience in data visualisation, this microcredential introduces advanced techniques to visualise varied nd complex data sets.
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.
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.
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
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
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy