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's features and architectural structure.
- Exploration of advanced tools and data analysis capabilities in Power BI.
Getting Started
- Installing Power BI and related components.
- Workflow for preparing reports and dashboards.
- Overview of the interface.
Power Query – Importing Data
- Types of connectors available.
- Understanding query folding.
- Extracting data from various sources:
- Flat files
- Entire folders of data
- Websites
- Handling unstructured files
- Advanced techniques in Power Query:
- Merging and appending tables
- Pivoting and unpivoting data
- Automated column creation from examples
- Working with inconsistent tables
- Tables decomposition
- Best practices in text analysis
- Introduction to the M language
Data Model – Why 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.
- How to create a hierarchy.
- Best practices in data modeling.
DAX – The Best Tool to Make Your Data Useful
- What is DAX and why is it so powerful?
- What is the difference between a measure and a calculated column? Which one should I use?
- Filter context vs. Row Context.
- How to create a measure table.
- Variables in measures:
- How to create variables?
- Why you should use variables?
- How to handle errors and debug with variables?
- Scalar functions:
- Basic aggregation functions
- Iterator functions
- SWITCH function – a better IF
- How you can use the COALESCE function?
- Advanced use of CALCULATE:
- The modifiers
- REMOVEFILTERS and KEEPSFILTERS functions with examples
- What is a Pattern?
- Table and Filter functions:
- Most common table functions
- Difference and examples of using VALUES and DISTINCT functions
- How to incorporate SELECTEDVALUE into your report?
- ALLEXCEPT
- ALLSELECTED
- Why you should know SUMMARIZE?
- Different ways to generate new data for your report
- Table joins:
- How to CROSSJOIN tables?
- EXCEPT and INTERSECT with examples
- How you can use the UNION function?
- Relationship Functions:
- What is the difference between physical and virtual relationships?
- RELATED and RELATEDTABLE
- How to use USERELATIONSHIPS?
- Advanced concept of time intelligence.
- How to prepare Fiscal and non-standard calendars for your model?
Advanced Visualization Techniques:
- How to prepare your own color palette for your report?
- How to build a theme for all your reports?
- How to create an effective slicer panel?
- Learn to create compelling graphs that do not lie.
- Learn to distinguish between good, bad, and wrong visualization.
- The simplest recipe to make your report look good.
- Interactive Scenario Analysis for your users.
- Forecast and trend lines for better data recognition.
- Drilling up and drilling down.
- Why you should use parameters?
- Bookmarks as your allies in data visualization.
Requirements
- A foundational understanding of Power BI.
- Previous experience working with Power BI.
14 Hours
Testimonials (2)
Method of training.
Ineshia Bilankulu - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
Useful and practical, the knowledge gained in training can be applied immediately.
