Power BI Report Server Mastery: From Setup to Advanced Reporting

Course Outline:

Module 1: Introduction to Power BI Report Server

  • What is Power BI Report Server?
  • How does Power BI Report Server work?
  • The benefits of using Power BI Report Server
  • Overview of the Power BI Report Server desktop and web interface

Module 2: Planning the On-Premises Setup

  • Hardware and software requirements for Power BI Report Server
  • Installation and configuration of Power BI Report Server
  • Setting up data sources for Power BI Report Server

Module 3: Data Modeling and Relationships in Power BI Report Server

  • Introduction to data modeling and relationships in Power BI Report Server
  • Creating relationships between tables
  • Creating calculated columns and measures using DAX
  • Using Quick Measures and the Data Analysis Expressions (DAX) formula language

Module 4: Building Reports in Power BI Report Server Desktop

  • Connecting to data sources
  • Designing and formatting reports
  • Creating charts and visualizations
  • Using custom visuals in Power BI Report Server

Module 5: Publishing and Sharing Reports in Power BI Report Server

  • Deploying reports to Power BI Report Server
  • Creating security groups and assigning permissions
  • Scheduling report data refresh
  • Exporting and printing reports

Module 6: Advanced Reporting Techniques in Power BI Report Server

  • Using drill-through and drill-down functionality
  • Creating hierarchies
  • Using bookmarks to create interactive reports
  • Using Q&A to create natural language queries
  • Using report templates for consistent branding

Module 7: Power BI Report Server Administration and Security

  • Managing users and security groups in Power BI Report Server
  • Creating and configuring data gateways for on-premises data sources
  • Monitoring and troubleshooting Power BI Report Server

Module 8: Advanced Analytics in Power BI Report Server

  • Introduction to advanced analytics in Power BI Report Server
  • Using Python in Power BI Report Server
  • Creating forecasting and prediction models