Microsoft POWER BI
Improvement
Presentation
For the past few years, Power BI, Microsoft's Business Intelligence solution, has become a must-have for exploring, analyzing, and visualizing data. This set of tools allows you to connect to various data sources and create interactive reports that enhance your data and help you make strategic decisions.
You already use Power BI and want to develop your skills in order to industrialize your approach, this training is for you.
Description
Teaching method and techniques
-
Projected training support documents
-
Practical case with the use of illustrated and didactic exercises.
-
Theoretical presentations
-
A course support will be given to each participant including slides on theory and exercises. A sign-in sheet for each half-day of attendance is provided at the end of the training as well as a certificate of completion of training if the trainee has attended the entire session.
-
Tool used: Microsoft Power BI Desktop
Accessibility for people with disabilities
For any information, please contact our disability representative using the contact methods below:
Sophie Lienard
Goals
-
Build a robust Power BI project using best practices
-
Mastering Advanced DAX Functions and Formulas
-
Leverage advanced features of the Power BI service
Assessment methods
A synthesis exercise in the form of a case study allows the acquisition of skills to be validated.
Audience
-
Analysts
-
Study managers
-
Data Professionals
-
Management controllers
Prerequisites
-
Have completed the introductory training.
-
Or have a good basic command of Power BI
Satisfaction rate
88% in 2023 (18 participants)
The program
Data sources
-
Import identical files from a SHAREPOINT folder
-
Import files from a folder
-
Connect to a database (import or direct query), a cube (import or live connection).
Data preparation
-
Handling errors
-
Edit the M language directly
-
Use Settings
-
Setting up M functions
-
Buffer function
-
Query Folding
-
Use query diagnostics
-
Understanding profiling tools and column quality
Data Modeling
-
Kimball model and modeling
-
Relationship management as a "Many to Many" principle
-
Focus on specific types of modeling
-
Data Model Design: Best Practices
Calculation formulas
-
Master line context, filter context
-
Additive, semi-additive and non-additive measurements
-
Working with the tables
-
Use the DAX view to develop advanced DAX syntaxes
-
Understanding and Using Compute Groups
-
Dynamic formats
Data visualization
-
Avoid pitfalls and bad practices
-
Organize data to make it easier to create visuals
To Data story telling
-
Offering drill-through filters
-
Exploit bookmarks
Visualization in Power BI
-
Use gridlines and object alignment
-
Import and edit a custom theme in Power BI Desktop
-
Adapt visuals for mobile viewing
-
Conditional formatting with DAX queries
-
Go further with the "Map" and "Segment" visuals
-
Identifying Outliers
-
Data aggregation and compartmentalization
-
Use parameterized scenarios ("what if")
Power BI Service
-
Applications
-
Add tiles to dashboards
-
Apply a Line Safety Policy (RLS)
-
Create a Read or Write App Workspace
-
Manage workspace roles and access
-
Handle refresh errors
-
Pipelines
-
Les Dataflows
-
Metrics (or Goals)
Rates
-
Intra-Company €7,200 excl. VAT (up to 8 people max)
Method and time limit of access
Registration link (1 mois)