Creating Optimal Reports with Power BI Desktop Report Server Training
Level
IntermediateDuration
16h / 2 daysDate
Individually arrangedPrice
Individually arrangedCreating Optimal Reports with Power BI Desktop Report Server Training
This training focuses on developing skills in creating efficient reports using Power BI Desktop Report Server. Participants will gain the knowledge and practical skills necessary to design reports optimized for performance and functionality. By understanding key concepts related to the data model, filters, advanced DAX language, and storytelling techniques, they will be able to build reports that effectively communicate information and support decision-making.
What You Will Learn
- Building lightweight and efficient reports: Learn how to optimize report performance through data model and layout optimization.
- Advanced DAX: Master advanced DAX techniques, including creating physical and virtual tables, using CALCULATE, and applying time intelligence functions.
- Storytelling in Power BI: Learn storytelling features like working with tables, matrices, and advanced conditional formatting to effectively communicate data.
- Administration and security: Gain knowledge of RLS (Row-Level Security) implementation and report refresh processes in Power BI Report Server.
Who is this training for?
IT specialists, data analysts, business consultants, and anyone interested in improving their reporting skills with Power BI Desktop Report Server.
Training Program
-
Building Lightweight and Efficient Reports
- Impact of the data model on report performance
- Methods for creating optimal report layouts
- Report performance analysis
- Filtering techniques in reports
-
Advanced DAX
- Working with contexts: filter context and row context
- Creating physical and virtual tables in DAX
- Advanced usage of CALCULATE
- Time intelligence functions
- Filtering queries using virtual tables
- Using variables in DAX calculations
-
Storytelling in Power BI
- Storytelling features available in Power BI
- Working effectively with tables and matrices
- Advanced conditional formatting in reports
-
Administration and Security
- Implementing Row-Level Security (RLS) in reports
- Refreshing reports in Power BI Report Server