Data guide · 11 min

Analyze data with AI while keeping control

AI can speed up data preparation, coding and summaries. Reliability still depends on definitions, checked calculations and a record of each transformation.

Two analysts compare a data table and charts on a screen.
AI-generated illustration
Key points

The starting rule

Define the question, scope and units. Preserve an untouched copy of the data, request reproducible steps, then independently recalculate the results that support your conclusion.

  • Define metrics
  • Preserve source data
  • Recalculate key results

Six steps to a verifiable analysis

  1. AI-generated illustration

    1. Frame the question

    State the decision, population, period, measures and meaningful comparisons. Avoid asking for a conclusion before the metrics are defined.

  2. Editorial illustration

    2. Inspect the dataset

    Check provenance, permission to use, columns, types, units, missing values, duplicates and dates. Remove or protect personal data as appropriate.

  3. Editorial illustration

    3. Preserve the source

    Work on a copy and record every filter, join and correction. Ask for a script or sequence of steps that can be rerun on the same data.

  4. AI-generated illustration

    4. Check calculations

    Recalculate a few rows and the important aggregates. Compare counts, denominators, means and medians; look for edge cases and omitted categories.

  5. Creative studio with a camera and drawing tablet
    AI-generated illustration

    5. Read the charts

    Check axes, scales, periods, legends and displayed figures. An attractive chart may hide a wrong comparison base or confuse correlation with causation.

  6. Wooden desk with a laptop and monitor
    AI-generated illustration

    6. Publish limitations

    Explain cleaning choices, uncertainty, missing data and tests performed. Preserve the source, script, settings and update date.

Recount rows after a join

Before joining orders to customers, record what each row represents in both tables and verify that the customer ID is unique in the customer table. Add a duplicate ID and an unmatched order to a fictional sample. Compare distinct order counts, unmatched rows and total order amounts before and after the join. Document how you handle missing values and retain rejected rows for review.

Put the method to work

Document research with an atlas and books in a library
AI-generated illustration

Practical case

Analyse a small known table with missing values, a duplicate and a check total. Request both an answer and a chart.

Laptop and folders on a private desk
AI-generated illustration

Evidence to keep

Keep transformations, formulas, excluded values, independently checked calculations and chart scale choices.

Library with books and a research notebook
AI-generated illustration

Make the decision

Accept the result when another person can reproduce the numbers and explain what the chart does not show.

Verification workshop

Detect correct analysis of the wrong data

Create a small fictional table in your usual tool. Calculate expected results independently before using an assistant.

AI-generated illustration

A duplicate inflating the total

Input to prepare
Three sales are 10, 20 and 30 euros; the 20-euro row appears twice with the same identifier.
Expected result
Unique sales total 60 euros and the duplicate is flagged.
If the check fails
Define the uniqueness key and compare row count with sale count.
AI-generated illustration

Missing value

Input to prepare
Three durations are 10, blank and 20 minutes.
Expected result
The mean of recorded durations is 15 minutes; one value is missing.
If the check fails
Check the denominator and prevent silent replacement of blanks with zero.
Conversation using a phone and laptop
AI-generated illustration

Incomparable groups

Input to prepare
Two teams have rates calculated from very different volumes.
Expected result
Counts and denominators accompany each rate.
If the check fails
Display volumes and revisit conclusions before ranking.

Decision rule. Reject a conclusion whose source rows and calculation cannot be recovered. Retain cleaning assumptions and formulas.

Compare tools on four points

AI-generated illustration

Import

Which formats and volumes does the tool actually support?

Open desktop computer showing memory and cooling
AI-generated illustration

Traceability

Can transformations and calculations be seen and rerun?

Microphone and headphones in an audio studio
AI-generated illustration

Control

Are errors and missing values clearly flagged?

Local computing workstation with an automation diagram
AI-generated illustration

Output

Can tables, charts and scripts be exported?

1 starting points

Tools to test on the same dataset

Compare services using a test file with missing values, duplicates and one known expected calculation. Measure the time needed to check and correct the output.

How is this selection produced?

These profiles are linked to the guide’s subject in our editorial catalogue. Inclusion is neither a ranking nor a performance measurement on your documents. Methodology.

Explore the full category

Related tool families

Frequently asked questions

Can AI replace a spreadsheet or analyst?

It can help explore and write, but definitions, methods and results still require review.

How do I verify an AI-generated chart?

Recreate aggregates from source data and compare axes, categories, units and scale with the visual.

What should be kept to reproduce the analysis?

The dated source, cleaning rules, script or steps, settings and output versions.

The references below expand on the concepts and checks discussed. Scenarios and trial frameworks remain editorial proposals; provider documentation describes its own product rather than an independent benchmark.

Official sources

Continue with another guide

Keep evidence from this trial

Connect this material to a decision and a retest condition. Prepare a decision record →