depictdatastudio

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]