Power BI: Core features II

Classical courses

Version: Microsoft 365
Duration: 2 days (09:00-17:00)
Price training (excl. VAT) starting at: €3300
Number of people: 1-12p

Description

You’ve followed the introductory course ‘Power BI: Core Features 1’, so you know that Power BI is a very powerful tool. You’re familiar with its basic features, but there are still some aspects you’d like to know more about. During this two-day training, we’ll walk you through the phases again, but we’ll start where we left off in Part 1. The queries are more complex, which allows us to optimise our model. The calculations in the model will be more complex as well and we’ll discuss additional features. We won’t focus on the ways in which you can create an attractive report, but on how you can prepare data in Power Query and on calculations via DAX.

Objectives

After this training, you’ll know how to:

  • Use functions in the query editor that are not available through the interface
  • Write your own query functions
  • Use parameters in queries
  • Point out the advantages/differences between a star scheme and a snowflake scheme
  • Optimize a model

Target Group

Everyone who knows the basics of Power BI and wants to learn more.

Prerequisites

You have completed the course “Power BI: Core Features 1” or have a solid basic knowledge of Power BI.

Content

Part 1 Power Queries

  • Pros and cons of the different connection types: import, direct connection and live connection
  • Defining parameters
  • Query folding
  • Introduction to M: the language of Power Query (define constant values, generate lists, use of functions not accessible through the interface, references to other steps or queries)
  • Generating dynamic date tables

Deel 2 Data Modeling

  • Star schema versus Snowflake schema
  • Relationships between tables (single versus cross-filtering, active versus non-active relationships)
  • Model optimization (Vertipaq engine /xVelocity in-memory analytical engine, setting custom sort order, data categories, default summarizations…)
  • Defining hierarchies
  • Composite models
  • When to use multiple date tables

Part 3 Calculations (DAX)

  • Context (tow context and filter context)
  • Functions (amount of functions depends on time and interest)
  • Variables in measures
  • What if-parameters

Part 4 Reports

  • Custom visuals

Part 5 Security

  • Row-level security (limit data in a file to what a specific viewer is allowed to see in a report)

EXTRA TOPICS

Part 1 Queries

  • Import data with different regional settings
  • Write your own functions

Part 2 Calculations (DAX)

  • Quick measures

Part 3 Reports

  • Power BI-templates

Part 4 Sharing

  • App work spaces
  • Create and update Apps

Part 5 Power BI Service

  • Set up a personal/enterprise gateway
  • Quick insights

Part 6 Office integration

  • Analyse datasets in Excel
  • Publish Excel data directly on dashboards

Book this training

Let's start a conversation!

Team Xylos is ready to meet you