Know your audience

Data Visualization in Power BI

Iason Prassides

Content Developer at DataCamp

Dashboards versus "pixel-perfect" reports

Dashboard

  • Tells us about critical business or operational metrics, often in real time
  • "Single pane of glass"
  • The norm for Power BI (even when we call them reports!)

"Pixel-Perfect" Reports

  • Provides more detailed information on business or operational metrics, usually delayed
  • Intended to fit on sheets of paper, not just on screen
  • Called "Paginated Reports" in Power BI
Data Visualization in Power BI

Your intended audience

Questions to ask

  • Who is your intended audience?
  • How will they use your dashboard?
  • What actions do you want to them to take as a result of what you show?
  • Are you showing the right measures in the right way?

Process Control Chart

An example of an i chart

Data Visualization in Power BI

The dataset

A visual with a silhouette of the United Kingdom and examples of textile products sold, e.g. a sweater

Data Visualization in Power BI

The dataset

  • Fact Table:
    • Orders - sales orders information
    • Returns - orders that have been returned to the company
  • Dimension Tables:
    • Products - details about products sold
    • Retailers - information related to the customers

Image of the data model for Threads Ltd as seen within Power BI

Data Visualization in Power BI

Our audience

The Head of Sales

  • Already has a view of high level company figures

  • Wants a more detailed view of the orders carried out by the company

  • Has asked for a specially tailored report

Cartoon image of two women assessing percentages and graphs surrounded by money and a briefcase

Data Visualization in Power BI

Let's practice!

Data Visualization in Power BI

Preparing Video For Download...