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
Possible locations:London, Manchester, Online
Next classroom course:Tue 12 October 2021
Time: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
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?
- No more than 5 people per class
- Proper restaurant lunch included
- 553 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Roberto Roselli (Waltham Forest Council)
Malcolm Marimirofa (Alzheimers Research UK)
Andy Cook (Central and North West London (CNWL) NHS Foundation Trust)
Ben Smith (Provide)
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 | Manchester | £695 | Book places |
| Thu/Fri 18-19 November 2021 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 12/10 | Manchester |
| 18/11 | Manchester |
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).
