How I design dashboards in Data Studio — Part 1: Data hierarchy and telling your story

  1. Understand your audience
  2. Tell them a story in their own language

Understanding your audience

  1. The user(s) of your dashboards
  2. Whoever you report to for the project (typically a PM)
  3. Whoever signs off on the budget
  • What is my user’s job? What is their level of proficiency?
  • How familiar are they with good data practices? Will this person know the difference between correlation and causation?
  • Will this tool make their job easier or harder? What part of their job could this dashboard improve?
  • What (if any) expectations do they have about this dashboard?
  • How much time do they spend on the part of their job related to my dashboard? Does this dashboard actually matter to them or is it just another tool that they have to learn to use?
  • What does the project manager need to show their boss to justify their role in the project? Do they just need to show them a cool looking dashboard or do they need to show that the dashboard actually improved a KPI?
  • What is the person approving the budget expecting as a deliverable and what do they need to justify the expense of the project?

Tell them a story in their own language

--

--

--

Building data-focused products. Startups acquired=1. Hobby = making Google Data Studio & Excel beautiful.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

9 Risks and Rewards of Using Social Media Instead of a Website

Six Reasons Why You Should Start Article Marketing

How to start with Google Ads? All you need to know

Google Ads

IDFA Changes, Mobile Marketing, Gamification and Customer Engagement

Drive More Sales with Automotive Marketing

automotive marketing

Non-profits: Fundraising isn’t an Expense its the Cost of Revenue.

Typical 5K Charity Fundraiser

5 Post-Launch Mobile App Marketing Strategies to Skyrocket Downloads

What’s The Difference Between SEO and SEM? Does It Matter?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Josh Cottrell-Schloemer

Josh Cottrell-Schloemer

Building data-focused products. Startups acquired=1. Hobby = making Google Data Studio & Excel beautiful.

More from Medium

Types of Technology Roadmaps + IT Roadmap Templates to Guide Your Tech Strategy

Minecraft- Block Dist per Layer- The making

What’s new in Release 49

Datylon Chart Maker | Datylon for Illustrator & Datylon Web App Product Update R49

New viz: Reparations Remain Controversial, but Why?