Creating Optimal Reports with Power BI Desktop Report Server Training

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to enhance your employees' competencies in the IT field.

The training 'Creating Optimal Reports Using Power BI Desktop Report Server' focuses on enhancing skills in creating effective reports using the Power BI Desktop Report Server tool. During the course, participants will gain the necessary knowledge and practical skills needed to design reports that are optimal in terms of performance and functionality. By understanding the main concepts related to data models, filters, advanced DAX language, and storytelling techniques, participants will be able to create reports that effectively communicate information and support decision-making processes.

This training is intended for IT specialists, data analysts, business consultants, and anyone interested in improving their report creation skills using the Power BI Desktop Report Server tool. Participants will find valuable information and practical tips that will allow them to effectively utilize the potential of this tool.

Learn practices related to implementing RLS (Row-Level Security) in reports and the report refresh process in the Power BI Report Server service, enabling you to effectively manage reports and secure data.

• You will understand how to influence report performance by optimizing the data model and graphical layout.
• You will master advanced techniques for working with DAX, including creating physical and virtual tables, using the CALCULATE function, and time intelligence.
• You will learn to use functions that support storytelling in Power BI, such as working with tables, matrices, and advanced conditional formatting functions to effectively communicate data.

• Building Lightweight and Efficient Reports

  • Impact of the Data Model on Performance

  • Ways to Create Optimal Layouts

  • Report Performance Analysis

  • Filtering in Reports

• Advanced DAX

  • Working with Contexts – Filter Context and Row Context

  • Creating Physical and Virtual Tables in DAX

  • Advanced Use of the CALCULATE Function

  • Time Intelligence Functions

  • Filtering Queries Based on Virtual Tables

  • Working with Variables in DAX

• Storytelling in Power BI

  • Functions Supporting Storytelling in Power BI

  • Working with Tables and Matrices in Power BI

  • Advanced Conditional Formatting Functions for Reports

• Administration and Security

  • Implementing RLS in Reports

  • Refreshing Reports in the Power BI Report Server Service

16 hours/2 days

• Certificate of Completion
• Monthly Access to Training Recordings (for online format)
• Customization of Training Program to Client Needs