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
- Overview of Power BI features and architecture.
- Advanced tools and data analysis techniques in Power BI.
Getting Started
- Installing Power BI and its related components.
- Workflow for preparing reports and dashboards.
- Overview of the user interface.
Power Query – Data Import
- Types of available connectors.
- Understanding query folding.
- Extracting data from various sources:
- Flat files.
- Entire folders of data.
- Webpages.
- Working with unstructured files.
- Advanced techniques in Power Query:
- Merging and appending tables.
- Pivoting and unpivoting data.
- Automated column creation from examples.
- Handling inconsistent tables.
- Tables decomposition.
- Best practices for text analysis.
- Introduction to the M language.
Data Model – Why Do You Need One?
- Definition of a data model.
- Data model normalization.
- Two main types of tables.
- Relationship cardinality:
- One-to-many.
- One-to-one.
- Many-to-many.
- Filter flow – the logic behind the engine.
- Creating hierarchies.
- Best practices in data modeling.
DAX – The Best Tool to Make Your Data Useful
- What is DAX and why is it so effective?
- Differences between measures and calculated columns. Which should be used?
- Filter context vs. Row context.
- Creating a measure table.
- Variables in measures:
- How to create variables.
- Benefits of using variables.
- Handling errors and debugging with variables.
- Scalar functions:
- Basic aggregation functions.
- Iterator functions.
- SWITCH function – a superior alternative to IF.
- Using the COALESCE function.
- Advanced uses of CALCULATE:
- Using modifiers.
- REMOVEFILTERS and KEEPSFILTERS functions with examples.
- Understanding patterns.
- Table and Filter functions:
- Most common table functions.
- Differences and examples of using VALUES and DISTINCT functions.
- Incorporating SELECTEDVALUE into your report.
- ALLEXCEPT.
- ALLSELECTED.
- Why you should use SUMMARIZE.
- Different ways to generate new data for your report.
- Table joins:
- Crossjoining tables.
- EXCEPT and INTERSECT with examples.
- Using the UNION function.
- Relationship functions:
- Differences between physical and virtual relationships.
- RELATED and RELATEDTABLE.
- Using USERELATIONSHIPS.
- Advanced concepts of time intelligence.
- Preparing fiscal and non-standard calendars for your model.
Advanced Visualization Techniques:
- Creating your own color palette for reports.
- Building a theme for all your reports.
- Designing effective slicer panels.
- Creating compelling graphs that accurately represent data.
- Distinguishing between good, bad, and incorrect visualizations.
- The simplest recipe to enhance report aesthetics.
- Interactive scenario analysis for users.
- Using forecast and trend lines for better data recognition.
- Drilling up and drilling down.
- The importance of using parameters.
- Using bookmarks as allies in data visualization.
Requirements
- A solid understanding of Power BI.
- Practical experience with Power BI.
14 Hours
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 -
