Data creates Value Talk to us

Library

Short reads for busy decision-makers.

Practical pieces about data, decisions and the small habits that make both easier. Free to read and share.

Guide

Writing a question data can actually answer

"How is the business doing?" is a mood, not a question. "Did repeat customers spend more per order this year than last?" is a question. The difference is that the second names a group, a measure and a comparison. Try rewriting your worry until it has all three. If you cannot, the gap tells you what to define first.

Then add the decision: "If repeat customers are spending less, we will review the loyalty discount." Now you know why you are asking, and when the answer is good enough.

Guide

When a spreadsheet has quietly become a system

Warning signs: only one person dares edit it; it has tabs named "FINAL v3"; other files link into it; month end depends on it. None of these means it must be replaced. They mean it deserves documentation, a backup routine and a second person who understands it.

Guide

Why "customer" needs a definition

Sales counts a customer per invoice account. Marketing counts email addresses. Operations counts delivery addresses. All three are reasonable, and all three produce different totals. Writing one agreed definition, or three clearly labelled ones, ends a surprising number of arguments.

Guide

Do you need software, or a better habit?

Ask: is the problem that the work is slow, or that it is inconsistent? Slow, repetitive work is a good candidate for a small tool. Inconsistent work usually needs agreement on how to record things first. Software built on an inconsistent habit simply automates the inconsistency.

Words we use

A friendly glossary

Dataset
A table of data prepared for a particular purpose.
Data dictionary
A list explaining what every column means and where it came from.
Join
Lining up two sources by something they share, such as an order number.
Assumption
A choice made when the data did not decide for us, written down.
Processing
Anything done to data: cleaning, combining, calculating, summarising.