<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Home / Power BI / Advanced Power BI

Advanced Power BI

Beyond basic Power BI, this course uncovers advanced features and uses of R and M languages for data extraction and transformation, tackling complex data modeling scenarios.

Free Community Plan View Pricing Plans
  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

Course Description

Understanding the basics of Power BI can only get you so far. There are many lesser known advanced features within the tool that can take your Power BI knowledge to the next level. This course explores those features. Starting with how the languages of R and M can be used to extend that standard data extraction and transformation capabilities of Power BI. You will then understand complex data modeling scenarios and how Power BI can overcome them. Lastly, you will learn about several advanced data visualization techniques that can take your reports and dashboards beyond the basics.

Course Outline ( Free Preview)

Advanced Power BI - What you need to get started

Module 01 - Getting Started

Module 02A - R Integration (Installation and Configuration) 6 min.

Module 02B - R Integration (R Scripting Basics) 22 min.

Module 02C - R Integration (R for Data Cleansing) 16 min.

Module 03A - Python Integration (Installation and Configuration) 12 min.

Module 03B - Python Integration (Python as a Data Source) 14 min.

Module 03C - Python Integration (Python Visual) 16 min.

Module 04A - M Query (Variables and Parameters) 19 min.

Module 04B - M Query (Expanding Lists) 10 min.

Module 05A - Query Folding (Basics) 14 min.

Module 05B - Query Folding (Beyond the Basics) 10 min.

Module 06A - Advanced Data Modeling (Filtering) 12 min.

Module 06B - Advanced Data Modeling (Cross-Filtering and Time Intelligence) 19 min.

Module 06C - Advanced Data Modeling (Many to Many with DAX) 11 min.

Module 06D - Advanced Data Modeling (Creating a Bridge Table) 11 min.

Module 06E - Advanced Data Modeling (Role Playing Tables with DAX) 17 min.

Module 06F - Advanced Data Modeling (Role Playing Tables without DAX) 10 min.

Module 06G - Advanced Data Modeling (Mismatched Granularities) 32 min.

Module 06H - Advanced Data Modeling (Weighted Allocation) 16 min.

Module 07A - xVelocity (Overview) 15 min.

Module 07B - xVelocity (Vertipaq Analyzer and DAX Studio) 15 min.

Module 07C - xVelocity (Column Cardinality) 16 min.

Module 07D - xVelocity (Calculated Columns) 9 min.

Module 08 - Advanced Visualizations (Visuals with DAX) 11 min.

Module 09A - Power BI Administration (Incremental Refresh) 18 min.

Module 09B - Power BI Administration (Implementing Row Level Security) 16 min.

Module 09C - Power BI Administration (Implementing Dynamic Security) 12 min.

Module 09D - Power BI Administration (Power BI Embedded) 15 min.

Module 10 - Outro 2 min.

This course includes:

  • 6+ hours of training
  • 30 Modules
  • * Access on mobile and browser
  • Certificate of Completion
Free Community Plan View Pricing