Platform Access

Intro to Paginated Reports

Gain technical knowledge on pulling data in from Power BI into Paginated Reports this will allow you to plan the layout of the pages and ensure that all information is visible

Enroll Now
Intro to Paginated Reports (1 of 3)

Here's What You'll Get

With The Course

Over 2 hours of intensive training videos

Resource pack

Intro to Paginated Reports (1 of 3)

Gain an overall understanding of the basics of how Paginated Reports works in Power BI

  • Paginated reports allow pixel-perfect formatting of our data to fit into a visualization that can expand over many pages
  • Allow us to plan the layout of the pages and ensure that all information is visible

Details Of What You Will Learn

During This Course

  • Import - data from Power BI service, DAX Studio or Performance Analyser into Paginated Reports
  • Understand - how to build a Query within Paginated Reports
  • Set up - a Report with Headers and Images
  • Create - a Table and understand how to Filter and Sort
  • Understand - how to format and change background and font sizes of different objects within Paginated Reports
  • Create - a Chart, format the Chart, and specify filtering, sorting, and adding data labels
  • Gain - an overall understanding of the basics of how Paginated Reports work to enable independent exploration
  • Publish - the report to the Power BI Service
Intro to Paginated Reports (1 of 3)

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Any user interested in producing printable reports from Power BI

LEARN HOW TO

Utilize the key features within Power BI

Intro to Paginated Reports (1 of 3)
  • Learn amazing tools for managing data
  • Gain knowledge in modeling data, creating insights, and visualization of information
  • Create a report on specific elements of data that expands to more than one page
  • Capture a copy of a report at a specific date/time for legal / business reasons that cannot be changed

Course Curriculum

1. Introduction to Paginated Reports

  • Start Introduction to Paginated Reports
  • Start What Are Paginated Reports And Why Would We Use Them

2. How to Install Report Builder

  • How to Install Report Builder

3. How to Get Data into a Report

  • Using Query Designer
  • Using DAX Studio
  • Using Performance Analyser
  • Create a blank Report and How to Filter a Report

4. How to Create Visuals-Object on Page

  • Page Properties
  • Text Box Properties
  • Location and Size
  • Run report
  • Design Editor
  • Add a Table
  • Formatting data
  • Formatting Headers
  • Conditional Formatting Using Expression Builder
  • Sorting Options
  • Filtering Options
  • Parameters and Error Handling
  • Remove Parameters
  • Deal with Blanks

5. Create a Chart

  • Insert
  • Chart Properties
  • Filtering
  • Sort A Chart
  • Add Data Labels
  • Examples of Using Expression Builder
  • Dynamic Header and Footer for a Template
  • Export and Save as PDF
  • Publish to Service
  • Considerations and Tips

What our Students Say

Your Instructor

Sue Bayes

Sue Bayes

  • Sue is a Microsoft Certified Data Analyst Associate specializing in Microsoft Power BI, Excel, and Paginated Reporting. She develops reports and models using Microsoft Power BI, Microsoft Excel, R, and Python and works closely with businesses to enable them to use these tools to provide strategic insight and answer those questions that give value. She spends most of her time heavily involved with Microsoft Power BI extracting, transforming, and loading data into business models visualizing information using both M and DAX to transform data into business solutions.
  • She established her freelance business after spending 14 years delivering Computing and Business training at all levels in finance, reporting, information systems, and databases predominantly.
  • She specializes in four areas:
    • Dashboards designed specifically for your business in Microsoft Power BI together with Microsoft Excel
    • Data interpreter - giving support for businesses when looking at different software solutions.
    • Bespoke IT training in Microsoft PowerBI or Excel either as individuals or groups on your data.
    • Specialist data solutions such as text analysis using bespoke code built for individual cases.

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or For Business access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA

On-Demand

Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace