Reports vs. dashboards

Reports in Power BI

Kevin Feasel

CTO, Faregame Inc

Course pre-requisites

  • Data Visualization in Power BI
  • Intermediate DAX in Power BI
Reports in Power BI

Dashboards versus reports

Dashboard

  • Tells us about critical business or operational metrics, often in real time
  • Lacks interactivity
  • Single-view

Reports

  • Provides an application-like experience for users
  • Multiple pages and interactive functionality
  • The focus of this course
Reports in Power BI

Choosing between dashboards and reports

Choose a dashboard if...

Power BI Dashboard example

  • You need rapid analysis
  • Users have limited engagement opportunities

Choose a report if...

Power BI Report example

  • You need detailed analysis
  • Users are primarily on PC and have a keyboard, mouse, and large screen
Reports in Power BI

Paginated reports

  • "Pixel-perfect" report intended for the written page
  • Created in the Power BI Report Builder

An example of a paginated report in Power BI.

Reports in Power BI

The end goal

  • Multiple pages with drillthroughs, bookmarks, and navigation buttons
  • Interactive design: animations, highlighting and states
  • Question and Answer capabilities
Reports in Power BI

Wake County watchdog data

  • Part of Wake County Open Data
  • Tracks budgets and expenditures for Wake County, North Carolina
  • Includes fiscal years 2017-2019
    • July 1st - June 30th

Wake County budget watchdog data

Reports in Power BI

Let's practice!

Reports in Power BI

Preparing Video For Download...