Analytics Demystified - Insights from the global authority on digital analytics and optimization
  • Home
  • About Us
  • Services
    • Strategy
    • Analysis
    • Adobe
    • Google
    • Mobile
    • Testing
    • Implementation
    • Training
  • Blog
    • Hawkins
    • Willeitner
    • Kiss
    • West
    • Patten
    • Peterson
  • Contact
  • More Options »

Analyst Resources

  • schedule a consult

    We would love to talk with you directly about your analytics needs and how Analytics Demystified can help. Please either call Eric Peterson directly at (360) 833-3996 or email us at consulting@analyticsdemystified.com

Home ≫ Community ≫ Analyst Resources

This page is a collection of downloadable tools and resources for digital analysts:

Process Templates

The following are downloadable templates that may have been referenced in a presentation or blog post by a Demystified consultant:

  • Hypothesis Library template (Google Sheets)
  • Hypothesis Library template (Microsoft Excel)
  • Tools self-audit (Google Sheets)
  • Tools self-audit (Microsoft Excel)
  • Performance Measurement Planning template (Google Sheets)
  • 1-Page Guide to Getting to Great KPIs (PDF)
  • Google Analytics URL Builder for utm_ Campaign Tracking (Google Sheets)

Data Visualization and Communication Books

There’s a lot to be read on the subject of data visualization. Our favorites:

  • Information Dashboard Design: Displaying Data for At-a-Glance Monitoring by Stephen Few
  • Show Me the Numbers: Designing Graphs and Tables to Enlighten by Stephen Few
  • The Wall Street Journal Guide to Information Graphics by Dona M. Wong
  • Brain Rules: 12 Principles for Surviving and Thriving at Work, Home, and School by John Medina
  • Presentation Zen: Simple Ideas on Presentation Design and Delivery by Nathan Yau
  • slide:ology: The Art and Science of Creating Great Presentations by Nancy Duarte

Excel Tips and Tricks

This is a list of posts developed to support a DAA webinar of Excel tips and tricks, but it seemed worthwhile to post it on this page as well:

  • An explanation of Excel tables
  • In-cell dropdowns using Excel tables and data validation
  • Creating dynamic named ranges using Excel tables
  • Creating dynamic named ranges without using Excel tables (i.e., if your data is being brought in automatically in such a way that Excel tables are not an option)
  • Creating named ranges for Adobe ReportBuilder queries
  • Conditional formatting for compact horizontal bar charts
  • Converting dates in Excel to the first day of week, last day of month, etc.
  • Combining conditional formatting with custom number formatting
  • Dynamically (formulaically…and with array formulas to break ties) sorting lists of data
  • Tips for building dashboards with Excel (also see the presentation in the selection below)

 

  • COMMUNITY
    • Demystified Library
    • Analysis Exchange
    • Analyst Resources
    • Books and White Papers

Share This

FacebookTwitterLinkedIn

Switching from Adobe to Google? What you Should Know (Part 2)

By Josh West on March 22, 2021

FacebookTwitterLinkedIn
  • Switching from Adobe to Google? What you Should Know (Part 2)

    By Josh West on March 22, 2021

    FacebookTwitterLinkedIn
  • Switching from Adobe to Google? What You Should Know (Part 1)

    By Josh West on March 15, 2021

    FacebookTwitterLinkedIn
  • Adobe Target and Adobe Analytics Webinar with Adobe

    By Brian Hawkins on October 23, 2020

    FacebookTwitterLinkedIn
  • Our campaign to raise money for Black Girls CODE

    By Eric Peterson on July 6, 2020

    FacebookTwitterLinkedIn
  • Analytics Demystified Supports Black Lives Matter

    By Eric Peterson on June 29, 2020

    FacebookTwitterLinkedIn
  • How Adobe Target can help in the craziest of times…

    By Brian Hawkins on March 20, 2020

    FacebookTwitterLinkedIn

Analytics Demystified - Insights from the global authority on digital analytics and optimization
  • Web Analytics Demystified, Inc.
    P.O. Box 589
    Camas, WA 98607
    (360) 833-3996
  • Connect

    • facebook
    • twitter
    • google plus
    • linkedin

About Us

  • Sitemap
  • Privacy
  • Terms

Services

  • Strategy
  • Adobe Analytics
  • Google Analytics
  • Testing
  • Implementation
  • Training
  • Staffing

Community

  • Analysis Exchange
  • Demystified Library
  • Analyst Resources
  • Books and White Papers

Blog

  • Eric Peterson
  • Michele Kiss
  • Josh West
  • Brian Hawkins
  • Kevin Willeitner
  • Tim Patten

Connect

  • facebook
  • twitter
  • google plus
  • linkedin



Copyright © 2023 Analytics Demystified

  • Privacy Policy
  • Sitemap