WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews 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

£850 + VAT for most venues (£995 + 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).

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking.

Alternatively, you could enquire about running the course in your office or even (if available) as a tailored online course.

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).

"Interactive, enthusiastic trainer. Great jokes."

Carrie-Anne Adams (Macquarie Energy Leasing)

"Thank you for delivering a fantastic course. "

Shahbaaz Khan (UP Global Sourcing (UK) Ltd)

"Our trainer was very friendly and delivered the course in a way that made it fun and enjoyable, but also easy to understand. I would definitely recommend the course to anyone looking to get into SQL."

Katie Horton (The Modern Milkman)

"The trainer's approach made me feel very comfortable and I gained confidence quickly in my abilities as I progressed through the course. Lots of practical exercises to reinforce what I thought I knew, and yet still lots of time to go out on tangents when necessary, Fantastic. Wish I could do it again! Very excited to apply what I've learned. I wanted a training provider that offered more of a personal touch really. Everyone learns differently and I didn't like the idea of attending a seminar style course. This was anything but that, very personal, focused and enjoyable. Thank you."

Puc Covelli (Integrate Media Limited)

"A very good trainer, who was good at explaining new topics and keeping us engaged; very friendly too. The main topics had been set by our company, but he was happy to go over some more esoteric things when we had time."

James Whitehouse (Liquid Logic (System C))

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

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 or DAX exercises

Power BI videos

Power BI videos

View Power BI or DAX for 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, Power Apps or Power Automate blogs

This page has 0 threads Add post