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 […]
Two Types of Tables: Datasets vs. Tabulations
This is an Eval Central archive copy, find the original at depictdatastudio.com. Last week’s blog post about contiguous vs. non-contiguous datasets was immensely unpopular. I had the most unsubscribes to my blog and newsletter of all time — in more than a decade of blogging, YouTubing, and newsletter-ing. One person said something like this: “I […]
Contiguous Datasets: A Critical Prerequisite for Useful Data Visualization
This is an Eval Central archive copy, find the original at depictdatastudio.com. “Ann, I loved your training, but I’m having trouble applying what I learned. Something’s off with my datasets, and the graphs are taking forever!” This past year, I’ve spent more time teaching about data management than data visualization. When I look under the […]
How to Visualize Multi-Year Patterns
This is an Eval Central archive copy, find the original at depictdatastudio.com. I recently worked with a healthcare system to visualize their multi-year patterns. Are you lucky enough to have historical data at your fingertips?! Woohoo! What a treat. Let’s weigh the pros and cons of a few different viz options. The Table Here’s what […]
From Formulaic to Meaningful: Constructing a Useful “Table of Contents” Page for an Evaluation Report
This is an Eval Central archive copy, find the original at depictdatastudio.com. Hello. I am Barbara Klugman, strategy and evaluation practitioner based in Cape Town, South Africa. Under the guidance of the inestimable Ann Emery’s “Report Redesign” course, I had a go at making the contents page of a previous evaluation report meaningful. Here are […]