Power BI: Core features 2

  • Course types: Calendar course / In company
  • Version: Office 2013/2016
  • Takes place in: Antwerp, Brussels
  • Duration: 2 days
  • Price: € 950 VAT excl. / Cheaper course?

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.

Choose a date and location

Objectives

After this training, you’ll know how to:

  • use query editor features that aren’t available through the interface
  • write your own query functions
  • use parameters in queries
  • work with (bi)directional relationships in the model
  • add measures and calculated columns to the model
  • use custom visuals in Power BI reports
  • share reports and dashboards with colleagues via Apps
  • integrate Power BI into other Office applications
  • set up data security, so that the end user can only see the data they’re allowed to see
  • ...

Target Group

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

Prerequisites

You’ve followed the ‘Power BI: Core Features 1’ training.

Content

Part 1 Queries

  • Pros and cons of different connection types: import, direct connection, live connection
  • Define parameters
  • Query folding
  • Introduction to M, the Power Query language (defining constant values, generating lists, using features that aren’t accessible through the interface, referring to other steps or queries)
  • Generate a dynamic date table

Part 2 Data Modeling

  • Relationships between tables (single versus cross-filtering, active versus non-active relationships)
  • Optimise Q&A with synonyms
  • Optimise a model (star diagram, snowflake diagram/vertipaq (xVelocity in-memory analytical engine))
  • Define hierarchies

Part 3 Calculations (DAX)

  • Context (tow context and filter context)
  • Functions (amount of functions depends on time and interest)
  • Filter functions (e.g. All, Allexcept, Allselected, Calculate, Filter, etc.)
  • Date and time intelligence functions (e.g. DateAdd, DatesYTD, Parallelperiod, Sameperiodlastyear, etc.)
  • Logical functions (e.g. If, Switch)
  • Text functions (e.g. Concatenatex, Blank)
  • Other (e.g. SelectedValue)
  • 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 workspaces
  • 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

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 950 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com

Associated courses