Remove two-types-of-tables-datasets-vs-tabulations
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.

Trending Sources

article thumbnail

Top 23 Dataviz Resources of 2023

Depict Data Studio

6 Data Cleaning Steps to Save You Millions : Hudson Kelley teaches us how to check for duplicates; check for changes in the survey instrument; check for outliers; use counts; recode variables with IF statements; and combine datasets with lookups. Two Types of Tables: Datasets vs. Tabulations : If everyone followed this advice, I could retire.

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? Not sure where to start?