The Growing Analyst

Tools

Things to use, not just read

Free, in your browser, and nothing you enter leaves your machine.

Data quality checker

New

Most analysis problems start in the data, long before the chart. Drop in a CSV file and in a few seconds you see what needs fixing, why it matters and how to fix it.

  • Duplicates and structure: rows that are exact copies, IDs that repeat, rows with too many fields.
  • Hidden problems: NA written as text, the same label spelled three ways, mixed date formats, 1900-01-01 placeholders.
  • A fix for each one, with the Power Query or R step to use.

Check a file

Dashboard layout generator

Most dashboards look amateurish for reasons that have nothing to do with the analysis: nothing lines up, and there are six shades of blue. This tool handles the groundwork so you can focus on the numbers.

  • Layouts named by situation, like "the manager's morning check", not by shape.
  • Every zone has a job: the answer, the trend, the breakdown, and the caveat.
  • Exports a background for Power BI or Excel, plus an annotated version to explain your thinking.

Open the generator

On the shortlist

Is this change real?

Compare two percentages, such as this quarter and last, and see whether the difference is bigger than chance.

Sample size calculator

How many people to survey for the precision you need, with design effect and non-response built in.

Chart chooser

Starts from what you want people to see, not from your variables.

Want one of these? Tell me. I build the ones people ask for.