This is an Eval Central archive copy, find the original at depictdatastudio.com. Do you need to share statistics in presentations? Maybe you’re getting ready for a talk at a conference. Or, maybe you’re sharing updates with coworkers in a staff meeting. In this blog post, you’ll learn how to explain dense graphs one slide at […]
How to Visualize Small n’s with Icon Arrays
This is an Eval Central archive copy, find the original at depictdatastudio.com. I was recently working with an online course student to visualize data for her country’s government officials. These aren’t her real categories or real numbers, but you get the idea. Before: Reading Numbers Her “before” version looked something like this: She had small […]
Use Icons to Visualize Data, Not Just Decorate
This is an Eval Central archive copy, find the original at depictdatastudio.com. Something wonderful — and terrible — has started happening. Researchers, evaluators, and scientists complete my online courses. Or they bring me in for private workshops. And they start applying what they learned. GREAT!!! But it’s a little off. OOPS. This is entirely my […]
Entrepreneurial Insights for Expecting Mothers on Heather Sager’s “Hint of Hustle” Podcast
This is an Eval Central archive copy, find the original at depictdatastudio.com. We recently added two more members to the Depict Data Studio team! In this podcast episode, I sat down with Heather Sager to share behind-the-scenes tips on managing parenthood and entrepreneurship. How to Listen LISTEN to the full episode on Apple Podcast or Spotify READ the episode […]
Redesigning a Thesis Chapter
This is an Eval Central archive copy, find the original at depictdatastudio.com. I’m an epidemiologist and public health researcher who studies health policies on infectious disease. I got the opportunity to work with a public health agency which I was really exited about. Until I had to present my research to a group of policy […]
How to Make Interactive Dashboards in Excel
This is an Eval Central archive copy, find the original at depictdatastudio.com. Want to make an interactive dashboard in Microsoft Excel? Interactive (a.k.a. dynamic) dashboards are a great option for technical audiences that have the time and interest to explore the data for themselves. They’ll look something like this: Interactive dashboards are easy to create […]
Don’t Start from Scratch! Make One of these Dashboards Instead
This is an Eval Central archive copy, find the original at depictdatastudio.com. Dashboards aren’t supposed to take forever. They’re not supposed to cost an arm and a leg. They don’t even need to be outsourced to a consultant. Dashboards are supposed to be fast and easy. We make ’em quickly. We give the numbers to […]
How to Make a Series of Matching Dashboards in Excel
This is an Eval Central archive copy, find the original at depictdatastudio.com. Do you need a series of matching dashboards? One per program, school, or state? Copying and pasting is tedious and destined for typos. Instead, produce a series of matching dashboards through the magic of lookup functions and drop-down menus. Save time with my […]
How to Make Your First Tableau Dashboard
This is an Eval Central archive copy, find the original at depictdatastudio.com. Want to get started with Tableau? Here’s a step-by-step guide to making your very first Tableau dashboard. In less than an hour, you’ll be able to install the free version of Tableau, add your dataset, create a few charts, and then combine then […]
Two Types of Tabulations: Formulas vs. Pivot Tables
This is an Eval Central archive copy, find the original at depictdatastudio.com. You learned about two types of tables: datasets vs. tabulations. Then, you learned about two types of datasets: contiguous vs. non-contiguous. Now, let’s learn about two types of tabulations: formulas vs. pivot tables. Tabulation Option 1: Formulas Formulas and pivot tables are both […]