1 Comment

  • […] what I learned in the course, I transformed the ugly tables into a dashboard (below). I created data bars to communicate percentage progress towards annual goals and sparklines to show trends over time. I […]

  • Leave a Reply to Ann K. Emery | Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal Cancel reply

    Your email address will not be published. Required fields are marked *

    How to Explore Your Spreadsheets with Miniature At-a-Glance Graphs

    Updated on: May 1st, 2018
    Dashboards
    , , , , ,

    I worked in several university research centers before transitioning to applied settings. My favorite position was as a researcher in a longitudinal study of adolescent development. We followed the same cohort of ~175 participants from their preteen years through adulthood. This is and was a major initiative funded by the National Institutes of Health, so we were careful and methodical during every step of the data collection, analysis, and reporting process.

    In those formal research settings, I was taught to analyze the data first and visualize the data second. We crunched our numbers and poured through dozens of pages of tables during staff meetings (SAS print-outs in tiny font, which was oh-so-readable). Much later on, while prepping for a conference presentation or journal article submission, we designed graphs to showcase key findings.

    Although I learned data analysis and data visualization as two distinct phases, nowadays I mix and mingle them a lot. Our brains can spot patterns in a visualization much faster than we can read through pages of numbers in tables.

    I use exploratory visualization techniques early and often. My favorite exploratory visualization techniques are sparklines and data bars. I use these techniques daily, and I want to share them with you, too.

    Sparklines

    Here’s a two-minute tutorial about sparklines, which are mini line graphs.

    I use sparklines during early exploratory analyses when I’m trying to spot juicy patterns. Are my numbers generally going up? Going down? Are there lots of peaks and valleys? Or are the numbers generally flat? I insert these quickie visuals and then sit back and reflect on the patterns I see.

    I also use sparklines in dashboard projects, like when I need a one-pager to show to others.

    Here’s how to create sparklines:

    Data Bars

    Here’s another two-minute tutorial about data bars, which are mini bar charts:

    More about Ann K. Emery
    Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 100 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

    1 Comment

  • […] what I learned in the course, I transformed the ugly tables into a dashboard (below). I created data bars to communicate percentage progress towards annual goals and sparklines to show trends over time. I […]

  • Leave a Reply to Ann K. Emery | Revamping a Tired Data Table: A ‘Before’ and ‘After’ Reveal Cancel reply

    Your email address will not be published. Required fields are marked *

    You Might Like

    Our complimentary mini course for beginners to dataviz. Takes 45 minutes to complete.

    Enroll

    6 Examples of Interactive Dashboards Made in Microsoft Excel

    Excel can do a lot–formulas, pivot tables, charts, static one-pagers, and even interactive dashboards! In this article, you’ll see a few examples and how-to tips to get you started.

    More »

    Want to wow your boss with a dynamic dashboard? Or, how about a one-pager of key findings? Our 4-course bundle provides all the how-to’s.

    Enroll

    Weekly Newsletter

    Data visualization time-savers in everyday software, like Excel. 

    Our weekly newsletter is shared with a community of 8,000 researchers, evaluators, and scientists.