Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Comprehensive overview of Power BI features and architecture.
- Exploration of advanced tools and data analysis techniques in Power BI.
Getting Started
- Installation of Power BI and associated components.
- Standardized workflow for preparing reports and dashboards.
- Walkthrough of the user interface.
Power Query – Importing Data
- Types of connectors available.
- Concept of query folding.
- Strategies for extracting data from various sources:
- Flat files.
- Data within entire folders.
- Websites.
- Handling unstructured files.
- Advanced Power Query techniques:
- Merging and appending tables.
- Pivoting and unpivoting data.
- Generating columns automatically from examples.
- Managing inconsistent tables.
- Decomposing tables.
- Best practices for text analysis.
- Introduction to M language basics.
Data Model – Why Is It Necessary?
- Definition and purpose of a data model.
- Data model normalization.
- Overview of the two main table types.
- Understanding relationship cardinality:
- One to many.
- One to one.
- Many to many.
- Filter flow – underlying engine logic.
- Creating hierarchies.
- Data modeling best practices.
DAX – The Optimal Tool for Data Utility
- What is DAX and what makes it so effective?
- Distinction between measures and calculated columns: which to choose?
- Filter context versus Row context.
- Creating a measure table.
- Utilizing variables in measures:
- Methods for creating variables.
- Benefits of using variables.
- Error handling and debugging using variables.
- Scalar functions:
- Basic aggregation functions.
- Iterator functions.
- Using the SWITCH function as an superior alternative to IF.
- Application of the COALESCE function.
- Advanced application of CALCULATE:
- Understanding modifiers.
- Practical examples using REMOVEFILTERS and KEEPSFILTERS.
- Understanding DAX Patterns.
- Table and Filter functions:
- Most commonly used table functions.
- Differences and examples regarding VALUES versus DISTINCT.
- Integrating SELECTEDVALUE into reports.
- Understanding ALLEXCEPT.
- Understanding ALLSELECTED.
- Why SUMMARIZE is essential.
- Various methods for generating new data for reports.
- Table joins:
- Performing CROSSJOIN operations.
- Using EXCEPT and INTERSECT with examples.
- Utilizing the UNION function.
- Relationship functions:
- Difference between physical and virtual relationships.
- Using RELATED and RELATEDTABLE.
- How to apply USERELATIONSHIPS.
- Advanced concepts in time intelligence.
- Preparing Fiscal and non-standard calendars for your model.
Advanced Visualization Techniques:
- Creating custom color palettes for reports.
- Developing themes applicable to all reports.
- Designing effective slicer panels.
- Mastering the creation of truthful and compelling graphs.
- Distinguishing between effective, poor, and misleading visualizations.
- The simplest approach to enhancing report aesthetics.
- Implementing interactive scenario analysis for users.
- Utilizing forecast and trend lines for improved data recognition.
- Techniques for drilling up and drilling down.
- The importance of using parameters.
- Leveraging bookmarks as allies in data visualization.
Requirements
- Fundamental understanding of Power BI.
- Practical experience with Power BI.
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
- Building dashboards - Learning the counts and SUMs and SWITCH -
