Remove two-types-of-tabulations-formulas-vs-pivot-tables
article thumbnail

Two Types of Tabulations: Formulas vs. Pivot Tables

Depict Data Studio

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.

article thumbnail

Two Types of Tables: Datasets vs. Tabulations

Depict Data Studio

Last week’s blog post about contiguous vs. non-contiguous datasets was immensely unpopular. From a data prep perspective, one really long table is the correct way to store the underlying data. Dealing with dozens of tables that should just be a single set is a typical rookie mistake.”

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Top 23 Dataviz Resources of 2023

Depict Data Studio

How to Analyze Nonprofit Data with Excel’s Pivot Tables (No Formulas Required!) : I shared the recording and materials from my how-to workshop at the Good Tech Fest conference. Two Types of Tables: Datasets vs. Tabulations : If everyone followed this advice, I could retire. 6 months off.

article thumbnail

My 6 Data Communications Classes

Depict Data Studio

One class focuses on data analysis (cleaning and tabulating our raw datasets to get them ready for graphs). In this class, you’ll practice a step-by-step process for exploring, cleaning, analyzing, and tabulating your dataset. Did you know… that I teach six different classes? Three classes are advanced, sort of.