Terms and conditions
- Duration:
- 2 days
- Participants:
- 2 to 10 people
- Required level:
- Basic knowledge of Power BI. Ideally trained in Essentials.
- Prerequisite:
-
No
- Materials needed:
- Computer and Internet connection
- Pedagogy:
- 60% theory 30% 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:
- Contact us for future sessions.
Price
Inter : 1000€ / participant
Intra: 3200€
Please contact us to schedule an in-person or remote learning session.
For intras, average delay: 1 month from the signature.
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 clean, enrich and transform data with Power Query
- I can design reports with DAX
- I can share and refresh reports on all media
- I can manage and configure security
Program
Reminders and best practices
Introduction to the Power BI in Power BI : Prepare, design, publish/share, administer/secure.
Power Query and the M
-
Connect to data
-
Clean up, transform and enrich your data
-
Discover the M language
- Managing errors
The DAX language and its advanced functions functions
The fundamental principles of DAX :
- The syntax
- Measures and columns
- Filter context and line context (SUMX, AVERAGEX, ...)
Variables :
- Variable declarations
Initiate a calculation :
- CALCULATE
The different types of functions .
- Simple aggregation functions (SUM, AVERAGE, MIN, MAX, COUNT)
- Filter functions (ALLSELECTED, FILTER, LOOKUPVALUE, SELECTEDVALUE)
- Logic functions (AND, IF, SWITCH)
- Relationship functions (CROSSFILTER, RELATED, USERELATIONSHIP)
- Information functions (ISBLANK)
Exploiting Time Intelligence
- Date and time functions (CALENDAR, CALENDARAUTO, DATE, DATEDIFF, DATEVALUE)
- Time Intelligence functions
(DATEADD, DATESBETWEEN, DATESINPERIOD, PREVIOUSQUARTER, SAMEPERIODLASTYEAR)
Visualizing and interacting with data
Create a customized visual theme.
Build interactive reports with dynamic filters.
Use filter and selection tabs.
Navigate using bookmarks and storytelling.
Integrate and use images to enhance visual understanding.
Customize tooltips for quick analysis.
Create specific visuals with the Synoptic Panel.
Know the other functions
Create a "What If" scenario parameter
Create a field parameter
Share reports
Review of all sharing features, including .
- Share your report on a website / Intranet / Blog...
- Share with SharePoint / Teams