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).
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
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
- 537 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).
John Marsden (Tameside MBC )
Michael Taylor (Leeds Community Healthcare NHS Trust)
Radoslaw Kowalczyk (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))
Rob Walker (JDP Furniture Group Ltd)
Siobhan Thompson (PricewaterhouseCoopers)
There are lots more where these came from (or just refresh this page to change the quotes shown).
