Power BI - Advanced Level

school

Terms and conditions

Duration:
1 day
Participants:
2 to 10 people
Required level:
Beginner users with little or no knowledge of the tool
Prerequisite:

No

Materials needed:
Computer and Internet connection
Pedagogy:
70% theory 20% practical on identified use cases identified beforehand and/or MCQs + exchanges 10% exchanges, Q/R
Teacher(s):
Business Intelligence Consultant
Modalities:
Distance learning possible Face to face possible Support and course in French
Next sessions:
22/02/2024
euro_symbol

Price

Inter : 600€ / participant

Intra: 1600€

Please contact us to schedule an in-person or remote learning session.

For intras, average delay: 1 month from the signature.

accessible_forward

Disability

We make every effort to make our courses accessible. In order to adapt accordingly, please contact us before any registration.

Learning objectives

  • I can design reports with DAX
  • I can share and refresh reports on all media
  • I can manage and configure security

Program

Designing reports

Introduction to the DAX language

The fundamental principles of DAX

  • The syntax
  • Measures and columns
  • Filter context and line context (SUMX, AVERAGEX, ...)

The variables

  • Variable declarations

Know how to use the main functions

Initiate a calculation

  • CALCULATE

Create a time table

  • The date and time functions
  • CALENDAR, CALENDARAUTO, DATE, DATEIFF, DATEVALUE

How to replace, add or delete the filter context?

  • The filtering functions
  • ALLSELECTED, FILTER, LOOKUPVALUE, SELECTEDVALUE

Determine the conditions of a calculation

  • Logic functions
  • AND, IF, SWITCH

How to manipulate the "virtual" tables?

  • Table manipulation functions
  • ADDCOLUMNS, GROUPBY

Explore "temporal" analyses

  • The functions of Time Intelligence
  • DATEADD, DATESBETWEEN, DATESINPERIOD, PREVIOUSQUARTER, SAMEPERIODLASTYEAR

How to activate or create table relationships

  • Relationship functions
  • CROSSFILTER, RELATED, USERELATIONSHIP

Know the other functions

  • Create a cumulative graph
  • Create a "What If" scenario parameter
  • Calculate forecasts

Share reports

Review of all sharing features including :

  • Share your report on a website / Intranet / Blog...
  • Share with SharePoint / Teams

Interested in our training?

If you would like more information or to register for a session, please write to us here:

    Maximum size 1MB, only pdf or image.