Analyst Resources
-
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
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)
Switching from Adobe to Google? What you Should Know (Part 2)
By March 22, 2021
on-
A quick update from The Analyst’s Companion …
By May 25, 2023
on -
Fork in the Road: The Big Questions Organizations are Trying to Answer
By May 15, 2023
on -
Switching from Adobe to Google? What you Should Know (Part 2)
By March 22, 2021
on -
Switching from Adobe to Google? What You Should Know (Part 1)
By March 15, 2021
on -
Adobe Target and Adobe Analytics Webinar with Adobe
By October 23, 2020
on