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 in Power BI
Getting Started
- Installing Power BI and other components
- Workflow for preparing reports and dashboards
- Overview of the interface
Power Query – Importing Data
- Types of connectors
- Query folding
- Extracting data from different sources:
- Flat files
- Entire folders of data
- Websites
- Working with unstructured files
- Advanced techniques in Power Query
- Merging and appending tables
- Pivoting and Un-Pivoting data
- Automated column generation from examples
- Working with inconsistent tables
- Table decomposition
- Best practices in text analysis
- Basics of the M language
Data Model – Why Do You Need One?
- What is 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
- Data modeling best practices
DAX – The Best Tool to Make Your Data Useful
- What is DAX and why is it so effective?
- What is the difference between a measure and a calculated column? Which one should you use?
- Filter context vs. Row Context
- Creating a measure table
- Using 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 superior alternative to IF
- Utilizing the COALESCE function
- Advanced use of CALCULATE:
- Understanding 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 understand SUMMARIZE?
- Different ways to generate new data for your report
- Table joins:
- How to CROSSJOIN tables?
- EXCEPT and INTERSECT with examples
- Utilizing the UNION function
- Relationship Functions:
- What is the difference between physical and virtual relationships?
- RELATED and RELATEDTABLE
- How to use USERELATIONSHIPS?
- Advanced concepts of time intelligence
- Preparing Fiscal and non-standard calendars for your model
Advanced Visualization Techniques:
- Creating a custom color palette for your report
- Building a consistent theme across all your reports
- Designing an effective slicer panel
- Creating compelling graphs that ensure accuracy
- Distinguishing between good, bad, and misleading visualizations
- The simplest recipe to enhance your report’s appearance
- Interactive Scenario Analysis for your users
- Utilizing forecast and trend lines for better data recognition
- Drilling up and drilling down
- The importance of using parameters
- Bookmarks as essential allies in data visualization
Requirements
- A foundational understanding of Power BI.
- Practical 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.
