Skip to content
Crane, home
Sign inCreate a free account

Fictional example

Avery Sample (fictional), both employers, the school and the posting are invented for this page. None of it is a real person's data, anonymized or otherwise.

Same candidate, two résumés

The posting: Product Analyst at Northbay Grocers (fictional). It asks for SQL, Tableau or a similar BI tool, A/B testing, Python, Partnering with product managers. Asked which of those they have, the candidate answered SQL: yes; Tableau: yes; A/B testing: yes; Python: no.

Before

A generic AI draft

Written by us to show the usual problems — it isn't the output of any particular tool.

  • Results-driven analyst with 5+ years of experience in SQL, Python and Tableau.

    Invented. “5+ years” and Python: neither is in Avery's facts, and Avery said they don't have Python.

  • Led a team of 4 analysts to build executive dashboards, cutting reporting time by 40%.

    Invented. Avery built one dashboard. No team, no executives, and no 40% anywhere in the facts.

  • Designed and ran 20+ A/B tests that increased conversion by 15%.

    Invented. Avery analyzed one test. “20+” and “15%” are invented.

  • Managed inventory across 12 store locations.

    Invented. The fact says 3 locations.

  • Wrote the SQL behind the monthly sales report.

    This one is true.

After

Written by Crane's rules

Every line cites the facts it came from. In the app, you click a line to see them; here they're shown under each.

Summary

  • Data analyst who builds the SQL reporting and Tableau dashboards an e-commerce team uses, and writes up A/B test results for product managers.

    Traced to: Data Analyst at Lakeshore Outfitters (fictional); Built a weekly Tableau dashboard of returns by product line for the merchandising team.; Wrote the SQL behind the monthly sales report, replacing a manual spreadsheet export.; Analyzed an A/B test of free-shipping thresholds and wrote up the results for the product manager.

Experience

Data Analyst, Lakeshore Outfitters (fictional) | 2022 – Present

  • Built a weekly Tableau dashboard of returns by product line for the merchandising team.

    Traced to: Built a weekly Tableau dashboard of returns by product line for the merchandising team.

  • Wrote the SQL behind the monthly sales report, replacing a manual spreadsheet export.

    Traced to: Wrote the SQL behind the monthly sales report, replacing a manual spreadsheet export.

  • Analyzed an A/B test of free-shipping thresholds and wrote up the results for the product manager.

    Traced to: Analyzed an A/B test of free-shipping thresholds and wrote up the results for the product manager.

Operations Associate, Harbor Street Books (fictional) | 2019 – 2022

  • Tracked inventory for 3 store locations in Google Sheets.

    Traced to: Tracked inventory for 3 store locations in Google Sheets.

Skills

  • SQL

    Traced to: SQL: daily, against the company's Postgres warehouse.

  • Tableau

    Traced to: Tableau: built and maintained the team's dashboards.

  • A/B testing

    Traced to: Analyzed an A/B test of free-shipping thresholds and wrote up the results for the product manager.

Left out, and why

  • Python — You said you don't have this, so it isn't mentioned anywhere.

How this example was made

We wrote both sides by hand for this page. The right-hand side passes the same code checks the app runs on every line — a test in our code fails if it ever stops passing — and each line on the left marked “invented” is flagged by those same checks. In the app, an AI reviewer also reads every line; that part isn't run on this page.

Ready to try it with your own facts? Create a free account.