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.
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.
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: DATEADD, PREVIOUSMONTH, PARALLELPERIOD + 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