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 […]
Building a Business that Fits Your Family: Disrupt Your Money Podcast
This is an Eval Central archive copy, find the original at depictdatastudio.com. Wake up without an alarm… Exercise, eat breakfast with the family, work on energizing projects for a few hours… … and then call it a day. Take the kids to gymnastics. Volunteer at field day. Take off the entire summer for bucket list […]
How to Analyze Data with Excel’s Pivot Tables (No Formulas Required!)
This is an Eval Central archive copy, find the original at depictdatastudio.com. In May 2023, I led a 45-minute session at Good Tech Fest about using pivot tables to analyze a dataset from start to finish. The conference recording wasn’t perfect — I got kicked out of the conference session midway, and again towards the […]
My 6 Data Communications Classes
This is an Eval Central archive copy, find the original at depictdatastudio.com. Did you know… that I teach six different classes? All of these classes fall under the broad data communications umbrella. One class focuses on data analysis (cleaning and tabulating our raw datasets to get them ready for graphs). Two classes focus on core […]