Power BI
This course is designed for advanced users who already have experience with the basics of Power BI. With this course, take your skills to the next level by exploring advanced techniques and gaining a deeper understanding of the tool’s most advanced features.
This training course is designed for users wishing to master the fundamentals of POWER BI, the Business Intelligence suite of analytical tools, that enables them to create reports easily, collaborate on dashboards and share insights. With this training course, master the basics of this tool and discover all its specific features with the assistance of our expert trainers.
All our training courses are led by experienced consultant-trainers recognized by their peers. Our trainers are certified in each of their areas of expertise and share their consulting experience through the training sessions.
50% of the training is dedicated to case studies
Provision of a learner account on our
e-learning platform
Digital training documentation provided
during training
Attendance is recorded at each session.
Competence is assessed throughout the training course through practical exercises.
A MCQ will be submitted at the end of the day to validate the skills acquired during the course.
An assessment of learner satisfaction is at the end of the course, and a follow up evaluation 3-4 months after the end of the course.
Training certificate issued to the learner.
Reminder and advanced features
– Reminder of the Power BI report design cycle
– Organize tables and relationships, define metrics, visualize.
– Understanding star organization, fact or dimension tables.
– Merge queries to reduce flakes.
– Aggregate and stack sources.
– Import data from a list of sources.
– Customize functions and parameter passing in M language.
– Manage errors. IP.
Build advanced visualizations
– Use DAX variables for calendars, lists and functions to create an M calendar.
– Cumulate by periods. Cumulate over rolling periods.
– Use Time Intelligence.
– Use DATEADD, DATESYTD, DATESBETWEEN, DATESINPERIOD, CLOSINGBALANCE.
– Work with multiple date columns and double relationships with user relationship.
Dashboards & Story
– Cumulative calculation with the EARLIER function.
– The ISBLANK function for managing empty values.
– DAX table creation functions: FILTER, CALCULATETABLE, ADDCOLUMNS, SUMMURIZE, UNION…
– Create page backgrounds, themes and report templates.
– Create “Master-Detail” reports using extraction filters.
– Use bookmarks for storytelling.
– Define customized visuals with the Synoptic Panel.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
