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.
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
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.
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
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.
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.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy