Power BI - Advanced Features

Course Description

This focused course is designed as an add-on to our Power BI Essentials courses and covers additional topics and features that are used for advanced report generation. Attendees need to be familiar with generating reports in Power BI.
1 Day
€550.00
 

Pre-requisites

Participants should have attended either our one or two-day Power BI course
Familiarity with Power BI, Excel and Database models is required

Learning objectives

Participants will learn:
Advanced features of using the Power Query option in Power BI
Connecting to SQL data sources
Reporting with built-in features
New advanced Data Visuals
Publishing and updating published Data

Power Query Features

Using the Advanced Editor
Data source settings
Creating Parameters
Creating groups
Merging Data
Transpose,Reverse, fill
Creating custom functions
Using custom columns
The M-Language

Data Connectivity

Connecting to New Data sources
Using SQL in Data Sources
DirectQuery,
Odata feeds,
Json and XML files

Power BI Desktop Features

Static Visuals
Themes
Role Level Security
Bookmarks
Filtering
What if Parameters
Drill Through options
Sync Slicers
Performance Analyzer

Power BI Visuals

Date and Date Hierarchy use
Custom formatting
Hierarchy and Grouping fields
New Visuals, Decomposition tree, Q&A, Key Influencers
Geographical Visual Use
Importing new visuals
Forecasting visuals
Data groups

Publishing Data to the Cloud

Scheduling refreshes
Exporting data, Excel, Powerpoint.
Creating Dashboards.
Download .pbix and .rdl
Security and permissions
Publish to public Web
Power QueryPower BIPower BI Data VisualisationsPower BI DesktopPower BI OnlineMicrosoft Power BIMS Power BIDAX