This is an Eval Central archive copy, find the original at depictdatastudio.com.
6,000 total participants in our dataviz training academy so far (with 5 cohorts going through our Full Courses in 2021 alone).
28 blog posts.
14 YouTube videos.
1 new baby.
What a year.
Top 21 Dataviz Resources of 2021
Want to do some year-end learning as 2021 winds down?
Here are our favorite 21 data visualization resources from the past year.
Every time I scroll through social media, someone’s post is telling me: “Want to know the secret to great dataviz?! Know your audience!” I mean… duh. “Knowing your audience” is terrible data visualization advice. What’s the alternative? Not know my audience? Of course not.
In this blog post, you’ll learn 8 specific, nuanced, advanced ways of “knowing our audience.”
This year I had the honor of speaking with Bill Jelen, a.k.a. Mr. Excel. He was a guest speaker inside our data analysis course, Simple Spreadsheets, and is a big, big deal in the Excel community! I’ve internet-stalked him for years on his website and his popular YouTube channel. Frankly, I’m still shocked he agreed to come speak with us.
“A lot of information and a bit overwhelming to take in.” That’s how Kristen Summers described her old grants docket. She emailed me an example of how she’s revamped her organization’s grants docket and I knew I had to showcase her hard work (keep it up, Kristen!).
In this guest blog post, Kristen walks us through the steps she took to remake her organization’s grants docket and budget visualizations.
When my friend Jon Schwabish asked me to partner on his One Chart at a Time project, it was an easy “yes.” For the project, I created a tutorial on using colored phrases to visualize qualitative data.
You’ll learn about the first time I ever used colored phrases to visualize qualitative data, my favorite examples of colored phrases, and practical tips for using colored phrases in your project.
Talk about a before/after makeover! Lillian Haley, Ph.D., MSW, ChFC® said, “Enrolling in courses at Depict Data Studio is one of the best professional developments I have ever made.”
In this guest blog post she shared how she originally based her capability statement on an example she found on the U.S. Department of Health and Human Services website and then transformed it using skills she learned in our courses.
Ready to escape the bar chart? Bar charts aren’t evil. But they’re overused.
In this blog post and video tutorial, you’ll learn about my 3 favorite exploratory vizzes (sparklines, data bars, and heat tables) and the pros and cons of choropleth maps, square tile grid maps, and hex maps.
Are you familiar with The Big Book of Dashboards?? It’s THE reference book with dozens of real-life case studies. The author, Steve Wexler, joined our Dashboard Design course as a guest speaker where we talked about his career, his books, the goal of data visualization, why he loves collaboration and a lot more.
Want to pass the Excel certification exam? Maybe you want proof that you can rock Excel for your resume? For your boss? In this blog post, I’ll share behind-the-scenes tips for registering for and pacing the MOS-200 exam.
Has using a dashboard has been central to your work? In this blog post, you’ll see Shawna Rohrman’s before/after dashboard makeover.
Shawna wrote, “Even with just these few changes (and using a program nearly everyone can access!), our new performance monitoring dashboard has made it so much easier for our team to review quarterly progress in one place and visualize how our system of early childhood programs are working for children and families in the county.”
Ready for an advanced presentation technique? Want to make sure your audience is engaged?
In this blog post, you’ll learn about the “Choose Your Own Adventure” method for engaging our audiences during presentations. This style puts our audience in the driver’s seat. We prepare lots of topics in advance, but they vote on which topics they want to cover.
Who are your datavizzes for? For your Board members? Other staff members? The general public? But what about for kids?
Bob Coulter has been “developing dashboards to support students’ understanding of local ecology and equip them to use that local understanding as a baseline to explore the rest of the world.” In this blog post, you’ll learn how Bob Coulter designed visualizations that personalize the experience for kids, too.
“Over the past few years, I have given a number of presentations across the country. I’ve learned the importance of presenting a creative topic rather than just ‘Hey, here’s my program. Let me throw some stats at you…’ I realized my slides needed some quick but major changes,” said Kelsey Watterson.
In this guest blog post she shared how she transformed her text-heavy presentations with her three favorite tips: color coding, increasing readability, and storyboarding.
I was a guest on Alli Torban’s podcast, Data Viz Today.
In this episode, you’ll learn how to overcome common reporting challenges like:
- Figuring out how to incorporate a variety of formats. Not just slideshows, not just reports, not just dashboards, and not just infographics. A different format for each of our different audiences.
- Trying to pack a lot of dense, technical information into each format — without overwhelming our readers. This is a tough one, even for me. And 3)
- Incorporating a variety of visuals. Not just graphs. Not just tables. Not just photographs.
Need a skimmable one-pager?
Guest blogger Juan DeJesus needed a one-pager that his team of 100+ people could read in 2 minutes or less.
“Instead of dense and text-heavy presentations, I minimize the text to include only the main points and actions I need from my team,” he wrote.
Have you conquered the lookup functions yet? (vlookup, hlookup, index-match, and xlookup?)
In this blog post, you’ll learn:
- what vlookup is used for,
- why vlookup can be tricky, and
- how to fill in the four pieces of the formula.
Curious about Tableau? Want to get started for the first time? Maybe you’re already using Tableau… but want to use it even better?
Zach Bowders, Tableau Zen Master and Tableau Ambassador, was a guest speaker during a Dashboard Design live session and he helped us navigate the Tableau community’s resources.
Are you using visual frameworks to explain your data?
This is an advanced technique, and it definitely requires more up-front planning time than usual. (But, it’s time well spent! More planning = better comprehension for our audience.)
“The effort to pick the right visual metaphor transformed the way I understood my own content,” explained Elizabeth Dove, guest blogger who shared her tips and tricks for presentations.
Do I selfishly hold Office Hours every week just so I can talk with you about data? Maybe. Wink.
Guest blogger Maddison Staszkiewicz shared how she transformed her data visualizations after getting feedback from our community during Office Hours.
Most of us were trained to write formal, academic reports.
Transitioning into infographics, dashboards, slidedocs… or even landscape orientation… yikes! It’s a big difference from what we’re used to.
To ease that transition, I invited professional illustrator Emily Mills to lead a sketchnoting session for our Report Redesign Full Course.
If we can get comfortable drawing graphics by hand, I thought, then adding a few more graphs to our reports won’t feel so daunting. Grab a pencil and paper to follow along.
Overwhelmed by fancy statistics? Does that make you feel like a wimp?? What if statistics weren’t necessary for some organizations???
Drs. Maryfrances Porter & Alison Nagel were guest speakers in our Simple Spreadsheets course, and they explained why nonprofits shouldn’t use statistics.
Don’t miss this one if you work at a nonprofit!
Ever feel like Microsoft Office wasn’t designed with data viz in mind? Do you have actions that need to be repeated over and over and over again?
In this blog post, Andrew Forsman is sharing how “a voice command and dictation software called Dragon can help overcome some of Office’s limitations.”
While I’m a big believer in everyday software, I love learning how new software can save us time and effort so we can focus on creating great data viz.
Here’s to 2022!