Browse 553 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Power BI Paginated Reports

Classroom Training

Paginated Reports for Power BI

Classroom training course - online version also available

£695 + VAT for most venues (£795 + VAT for London)

2 days

Power BI paginated reports allow you to create reports optimised for printing and exporting within Power BI (even when your data spans many pages).  In this two-day course you will learn how to use Power BI Report Builder to create paginated reports, and how to publish these to the Power BI Service.  You’ll learn how to connect to Power BI datasets, how to create basic DAX queries and how to present the results using a variety of visualisations such as tables, matrices, charts and other fancy graphical indicators (if you’re interested in using SQL Server data sources and deploying reports to an on-premises report server, you may prefer our standard Report Builder or Reporting Services courses).

Course details

  • Locations for Power BI Paginated Reports coursesPossible locations:London, Manchester, Online
  • Next Power BI Paginated Reports course locationNext classroom course:Tue 12 October 2021
  • Power BI Paginated Reports course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Report basics

  • Text boxes and images
  • Selecting report items
  • Formatting reports

Data sources and datasets

  • Connecting to a Power BI model
  • Datasets using query designer
  • Basic DAX queries
  • Copying DAX from Power BI reports

Tables

  • Creating tables
  • Interactive sorting
  • Floating headers

Saving and publishing

  • Saving reports locally
  • Publishing to the Power BI Service
  • Embedding in Power BI reports

Grouping

  • Grouping in a DAX query
  • Creating groups in tables
  • Group headers and footers
  • Displaying group totals
  • Expanding and collapsing

Matrices

  • Row and column groups
  • Choosing aggregate functions
  • Creating subtotals

Expressions

  • The expression builder
  • Creating calculated fields
  • Built-in fields
  • Conditional formatting expressions

Printing and exporting

  • Page headers and footers
  • Page names and numbers
  • The various report formats

Parameters

  • Creating report parameters
  • Filtering using parameters
  • Drop list parameters
  • Coping with empty tables
  • Parameters in DAX queries

Charts

  • Creating charts
  • Assigning fields
  • Formatting charts
  • Data bars
  • Sparklines

Graphical indicators

  • Creating and customising indicators
  • Linear and radial gauges

Covered if time allows If time

Lists

  • Page-per-record lists
  • Dashboard lists
  • Other list ideas

You'll find this course much easier and more meaningful if you've already created basic on-screen reports in Power BI, although this isn't an essential pre-requisite.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Very good organisation and pace. Very easy to stay engaged and focused. "

Roberto Roselli (Waltham Forest Council)

"Great introduction to SQL, delivered clearly with good examples and test databases."

Malcolm Marimirofa (Alzheimers Research UK)

"Brilliant, great trainer. Very educational and entertaining."

Andy Cook (Central and North West London (CNWL) NHS Foundation Trust)

"I really enjoyed this course and found it very useful. Our trainer was brilliant at explaining the topic clearly and answered all questions I had, along with giving a very friendly and comfortable environment to learn. This course changed my mindset on Power BI from just another program available, to potentially a key tool I will use daily going forward. Thank you for a great experience."

Ben Smith (Provide)

"A great instructor, extremely welcoming, and very sensitive to the way different members on the course engaged with and interpreted information. Made for a seamless and informative course. Would recommend!"

Patrick Thewlis (Ministry of Housing, Communities and Local Government (MHCLG))

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Power BI Paginated Reports training dates

Here are the classroom Power BI Paginated Reports courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 12-13 October 2021 2 £695 Book places
Thu/Fri 18-19 November 2021 2 £695 Book places
Date(s) Venue
12/10
18/11

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Power BI RECOMMENDED

Power BI screen reports

2 day course

DAX

Writing DAX in Power BI

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

View Power BI videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI or Power Apps blogs

This page has 0 threads Add post