Speaker

Lenore Flower

Lenore Flower

Caf2Code - Senior Business Intelligence Analyst

Washington, Washington, D.C., United States

Lenore Flower is an enthusiastic “data plumber” and co-organizer of the Power BI Washington, D.C. user group. Her technical experience includes Power BI, SQL, Azure Analysis Services, and a range of other tools to help D365 users meet their reporting and analytics ambitions.

Lenore holds an MBA from the University of Maryland, where she prioritized finance and tech coursework that aligned with her background in FP&A (Financial Planning & Analysis), accounting, and DQ&G (Data Quality and Governance). A passionate advocate for the "boring but essential" stuff, Lenore loves helping colleagues, customers and students learn how to build and optimize their own reports and data plumbing in addition to implementing herself.

When not building datasets and reports, Lenore can generally be found working on her blacksmithing skills, trying out her latest DIY project, or attempting to improve her French.

Area of Expertise

  • Business & Management
  • Information & Communications Technology

Topics

  • power bi training
  • Power BI Report Builder
  • power bi paginated reports
  • Microsoft Power BI
  • Power Platform
  • Power Query
  • power bi
  • Data Modeling
  • Data Management
  • SQL Server Analysis Services
  • Tsql

Paginated Reports 201 – Build a Better Report

You’ve connected to your data source and generated a table with parameters in Power BI Report builder, but the basic structure of your report leaves something to desire. How do you upgrade your functional but ho-hum report without breaking it?
   
In this session, users will learn how to tackle a mix of structural and formatting challenges that often plague paginated report developers, such as getting headers to repeat on each page, leveraging date pickers, and incorporating two datasets within the same table. Attendees will leave with links to the sample files and instructions they can reference in future when tackling their own reports.

Workshop - Paginated Reports 101 for the Power BI Veteran

Scenario: you’ve just completed a Power BI report, and it’s downright majestic! There’s just one tiny problem: it turns out your report users need a simple table that will print out well instead. Now what?  

This hands-on session will go step-by-step in converting a Power BI analytical report into a Power BI paginated report that uses the same underlying Power BI Dataset.  We’ll break down what each section of Power BI Report Builder contributes to your report and discuss how the underlying paginated report logic differs from a standard PBIX file. 

Session attendees will have the opportunity to practice what they learn throughout session with hands-on support and time for Q&A. At the end of this deep dive, attendees will leave with practice files that they can reference for practice and as a starter template for developing their own paginated reports.  

This is a 90-minute hands-on workshop version of this presentation, which I have also presented as a 50-minute session without the hands-on component.

Paginated Reports 101 for the Power BI Veteran

Scenario: you’ve just completed a Power BI report, and it’s downright majestic! There’s just one tiny problem: it turns out that your report users need a matrix that will print out well instead. Now what?  

This hands-on session will go step-by-step in converting a Power BI analytical report into a Power BI paginated report that uses the same underlying Power BI Dataset.  We’ll break down what each section of Power BI Report Builder contributes to your report and discuss how the underlying paginated report logic differs from a standard PBIX file. 

At the end of this deep dive, attendees will leave with practice files that they can reference, both for practice and as a starter template for developing their own paginated reports.  

This is the hour-long version of the 90-minute hands-on session. Starting in Nov 2023, this session will also cover how to use the online paginated report options in the Power BI service for very simple reports.

Choosing the Right Reporting Tool for the Job (D365 Finance & Power BI)

The right reporting tool can make a huge difference in development costs and user adoption but knowing which tool to use (and when) can be a challenge. During this session, users will learn when to use standard Power BI reporting, paginated reports, Excel-based reporting, customized Dynamics 365 Finance reports, OData, or a combination to meet their specific reporting needs. We will dive into the wealth of out-of-the-box reporting Dynamics 365 F&O has, where to look, and what changes users can make without having to engage in any type of code changes. Finally, we'll review common D365-to-report "data plumbing" approaches to demystify how your critical information gets from point A to point B.

This session was first presented at Community Summit NA in collaboration with the inestimable Lauren Wooll.

What is a Golden Dataset (and why do you need one)?

Well-designed golden datasets are game changer; they create the foundation for reliable data quality and support good data governance while also lowering the barrier for entry for report writers. By centralizing the workload and minimizing duplicate data pulls, golden datasets can also save your company significant money by reducing maintenance time and resourcing costs.

If you’ve been using the Power BI service in a decentralized fashion, however, setting up a golden dataset can be a tall order. How do you determine what goes into a golden dataset, or who should have access to its different components? Do you still leverage a star schema? What do you do when different teams each calculate a measure in their own unique way?

This session provides a roadmap for converting your existing data models without interrupting business operations. You’ll leave with insights and tools that will help you get started developing your own golden dataset that aligns with your company’s unique needs.

Community Summit NA

1. Choosing the Right Dynamics 365 F&O/AX Reporting Tool for the Job

Description: The right reporting tool can make a huge difference in development costs and user adoption, but knowing which one to use can be a challenge. During this session users will learn when to use standard Power BI reporting, paginated reports, Excel-based reporting, customized Dynamics 365 F&O reports, or a combination. We will dive into the wealth of out-of-the-box reporting Dynamics 365 F&O has, where to look, and what changes users can make without having to engage in any type of code changes.

Selected for: First Time at Summit Curated Agenda, Most Popular Sessions Curated Agenda

https://connect.summitna.com/8_0/sessions/session-details.cfm?scheduleid=408

2. Paginated Reports 101 for the Power BI Veteran (90-minute workshop)

Scenario: you’ve just completed a Power BI report, and it’s downright majestic! There’s just one tiny problem: it turns out your report users need a simple table that will print out well instead. Now what?

This hands-on session will go step-by-step in converting a Power BI analytical report into a Power BI paginated report that uses the same underlying Power BI Dataset. We’ll break down what each section of Power BI Report Builder contributes to your report and discuss how the underlying paginated report logic differs from a standard PBIX file.

Session attendees will have the opportunity to practice what they learn throughout this deep dive session with hands-on support and time for Q&A. At the end of this deep dive, attendees will leave with practice files that they can reference for practice and as a starter template for developing their own paginated reports.

https://connect.summitna.com/8_0/sessions/session-details.cfm?scheduleid=244

3. Paginated Reports 201 – Build a Better Report

You’ve connected to your data source and generated a table with parameters in Power BI Report builder, but the basic structure of your report leaves something to desire. How do you upgrade your functional but ho-hum report without breaking it?

In this hands-on session, users will learn how to tackle a mix of structural and formatting challenges that often plague paginated report developers, such as getting headers to repeat on each page, leveraging date pickers, and incorporating two datasets within the same table. Attendees will leave with links to the sample files and instructions they can reference in future when tackling their own reports.

https://connect.summitna.com/8_0/sessions/session-details.cfm?scheduleid=243

October 2023 Charlotte, North Carolina, United States

Power BI DC

Power BI paginated report tend to be thought of as the boring older sister of standard Power BI Reports. Still, when you need a report that can be reliably PDF-ed or printed out in a specific format, these boring but essential reports are simply the right tool for the job.

Join us for a special 1.5 hour in-person workshop on the evening of August 24th, where you'll be able to get some hands-on experience creating paginated reports from Power BI DC's co-organizer Lenore Flower. Attendees will leave the session with practice files and a firm understanding of when and how to leverage paginated reports.

August 2023 Arlington, Virginia, United States

Dynamics User Group Northeast Regional Meetup

You’ve connected to your data source and generated a table with parameters in Power BI Report builder, but the basic structure of your report leaves something to desire. How do you upgrade your functional but ho-hum report without breaking it? In this session, users will learn how to tackle a mix of structural and formatting challenges that often plague paginated report developers, such as getting headers to repeat on each page, leveraging date pickers, and incorporating two datasets within the same table. Attendees will leave with links to the sample files and instructions they can reference in future when tackling their own reports.

July 2023 Arlington, Virginia, United States

DynamicsCon Live

Session Presented: Power BI Paginated Reports 201: Build a Better Report

You’ve connected to your data source and generated a table with parameters in Power BI Report builder, but the basic structure of your report leaves something to desire. Now what?
In this session, users will learn how to tackle a mix of structural and formatting challenges that often plague paginated report developers, such as getting headers to repeat on each page, leveraging date pickers, and incorporating two datasets within the same table. Attendees will leave with links to the sample files and instructions they can reference in future when tackling their own reports.

Link to Presentation Slides: https://live.dynamicscon.com/wp-content/uploads/2023/06/Lenore-Flower-Power-BI-Paginated-Reports-201-Build-a-Better-Report.pdf

May 2023 Scottsdale, Arizona, United States

Lenore Flower

Caf2Code - Senior Business Intelligence Analyst

Washington, Washington, D.C., United States