Module 2
Structuring data: tables, columns, consistent values and the tidy table
Most legal data starts life in a spreadsheet built by someone who needed to keep track of something. It grows columns as new needs arise, mixes facts and comments, spells the same thing three ways and leaves gaps. It is usable by its author and almost useless to anyone else. Before you can ask questions of data, you must put it into a shape that a program, or a person who did not make it, can count. That shape is surprisingly simple: a tidy table. This module teaches what a tidy table is, how to choose and enforce consistent values, how to treat dates, numbers and gaps, how tables are linked and how to document what each column means.
Module 1 of this course is free, and this is not it. Unlock the whole course below, or go back to the course page.
Two Ways In
Introductory PriceLegal Data and Dashboards: buy it on its own, or get it with All-Access
Unlock all of Legal Data and Dashboards on its own with a one-time purchase, or get it as part of an All-Access Membership, which also covers every course and the other paid tools. A member never needs to buy it separately.
This is an early, introductory price for a brand-new product — it’s expected to rise as we add more content. Buy now and it’s yours at today’s rate, forever.
No account needed: you pay, and we email you a one-click sign-in.
All-Access is $19.99 a month or $149 a year, and covers every course and most tools, this one included. Create a free account to subscribe.
Look first, then buy. Free previews on every product page. Secure payment by Stripe. Pay once, keep it forever. Details
See what is included in All-Access →General education on legal data and analytics, using invented organisations, datasets and figures. It is not legal advice. Duties about client confidentiality, data protection and the use of data about employees differ between countries and employers: check the rules that apply to you.
Teaching? Share this with your class
Free to use in class. The free parts open for everyone, no account needed.