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 […]
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 […]
The Data Visualization Design Process: A Step-by-Step Guide for Beginners
This is an Eval Central archive copy, find the original at depictdatastudio.com. Visualizing data in charts, graphs, dashboards, and infographics is one of the most powerful strategies for getting your numbers out of your spreadsheets and into real-world conversations. But it can be overwhelming to get started with data visualization. Does data visualization leave you […]
Review: Stefanie Posavec’s “Dataviz Drawing Class”
This is an Eval Central archive copy, find the original at depictdatastudio.com. Last month, I participated in Stefanie Posavec’s Dataviz Drawing Class. I LOVED the class! Wondering whether the class is right for you? What’s inside this review: Class logistics Why I signed up About the instructor What we learned Who this class is best […]
How to Make Great Graphs in Excel: 4 Levels of Excel Vizardry
This is an Eval Central archive copy, find the original at depictdatastudio.com. Are you drowning in the deep end of Excel? First, dip a toe in. And then another. You’ll be swimming confidently before you know it. 4 Levels of Excel Vizardry I’ve taught data visualization in Excel a dozen different ways over the years. […]