Power BI - Advanced Features

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