Power BI Advanced (2 days)

Introduction

Become an expert in Power BI with this advanced training! Learn how to create sophisticated analyses with DAX, how to efficiently import data from a SQL Server database, and how to share and secure your Power BI reports. 

Topics

Data Importing (ETL / PowerQuery)

• Importing data from:
  • SQL Server (SQL)
  • DirectQuery vs Import

Model Creation

• Creating a Data Model (star schemas): Best practices

DAX Formulas

• Difference between Row context and Filter context.
• Calculated Columns and Measures: when to use what? 
• Complex Logic: IF + SWITCH
• Looking up values in other tables: LOOKUPVALUE, RELATED + RELATEDTABLE
• Modifying Filter Context with: CALCULATE + FILTER 
• Time Intelligence functions: DATESADD, PREVIOUSMONTH, PARALLEPERIOD + DATESYTD 
• Custom Time Intelligence: Moving Average + Parameters
• Benchmarking: RANKX + TOP

Reporting 

• Creating a KPI Dashboard
• Branding: Page Layouts + Themes
• Drillthroughs + Bookmarks

Deployment

• Publishing to Power BI Cloud Service
• Shared Datasets
• Data refresh: On-Premises Data Gateway

Security

• App Workspace Roles
• Publishing as an App
• Row-level Security

Target Audience

This 2-day course is a follow-up to the module "Power BI Introduction" and is suitable for anyone who wants to elevate their Power BI skills to a higher level.

Prerequisites

You have a good knowledge of Power BI. The topics covered in "Power BI Introduction" are assumed to be known.

Information

Interested in this training? Click here for more information.