Advanced Microsoft Power BI
Published by Pearson
Create enterprise-level models by using advanced techniques and external tools
- Be more productive when creating reports and models in Power BI
- Optimize the performance of slow reports
- Solve more complex issues in Power Query and DAX
Level up your understanding of Power BI with Microsoft BI aficionado and instructor Daniil Maslyuk as your guide. Learn advanced features of Power BI such as external tools, custom M code, data model optimization, and more. Go beyond the fundamentals and put your experience in Power BI to more effective and productive use.
What you’ll learn and how you can apply it
- How to use Advanced Editor in Power Query Editor
- What external tools can do for you
- What affects the report speed and how you can improve it
And you'll be able to:
- Create more complex models by using advanced DAX and modeling techniques
- Become more productive by using external tools such as DAX Studio and Tabular Editor
- Write custom M functions
This live event is for you because...
- You learned the basics of Power BI and want to become more productive
- You want to optimize the performance of your reports
- You want to develop skills that will help you advance in your career as a data analyst
Prerequisites
- Have a few months of experience creating reports and models in Power BI Desktop
- Familiarity writing DAX formulas
- Understanding of getting and transforming data in Power Query
Course Set-up
- Install: Microsoft Power BI
- Install: DAX Studio
- Install: Tabular Editor 2 (free)
- If interested in repeating the examples with Python, install Anaconda
- GitHub link with course files: https://github.com/DaniilMaslyuk/Advanced-Microsoft-Power-BI
Recommended Preparation
- Attend: Analyzing Data with Microsoft Power BI live training by Daniil Maslyuk
- Watch: Introduction to Microsoft Power BI (Video) by Chris Sorensen
Recommended Follow-up
- Read: Analyzing Data with Power BI and Power Pivot for Excel by Ferrari and Russo
- Read: The Definitive Guide to DAX: Business Intelligence with Microsoft Power BI, SQL Server Analysis Services, and Excel, Second Editionby Ferrari and Russo
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Course overview (5 minutes)
External Tools (70 minutes)
- Tabular Editor (30 minutes)
- DAX Studio (15 minutes)
- VertiPaq Analyzer (15 minutes)
10 minutes Q&A + break
Advanced Power Query concepts (40 minutes)
10 minutes Q&A + break
Advanced data modeling concepts (70 minutes)
- Row- and object-level security (20 minutes)
- Calculation groups (20 minutes)
- Composite models (10 minutes)
- Performance analyzer (10 minutes)
10 minutes Q&A + break
Other advanced concepts (40 minutes)
- Creating Python or R visuals (15 minutes)
- Enabling visual personalization (15 minutes)
10 minutes Q&A + break
Your Instructor
Daniil Maslyuk
Daniil Maslyuk is an independent business intelligence consultant and trainer who specializes in Microsoft Power BI. Daniil is the author of the official Microsoft Power BI exam reference books. For his community contributions, he has been recognized as a Microsoft Most Valuable Professional (MVP). Daniil blogs at xxlbi.com and tweets as @DMaslyuk.