# How are data analysts using AI without losing accuracy? > Analysts use AI for data checks, formulas, queries and write-ups, and keep accuracy by making it profile data first, show its work and tie totals out. Source: https://learn.ynteractive.com/content/questions/how-data-analysts-use-ai · Updated 2026-10-21 · Free from Stepthrough (https://learn.ynteractive.com) By [Robert Breen](https://learn.ynteractive.com/content/about) · Published October 21, 2026 · Updated October 21, 2026 · 4 min read Data analysts use AI to speed up the parts of the job around the analysis: profiling and cleaning a file, writing formulas and SQL, drafting charts and writing findings for non-technical readers. They keep accuracy by making the AI check the data before it answers, asking for formulas or code instead of typed-in numbers, and tying every key total back to the source, the routine in [Analyze a Spreadsheet](https://learn.ynteractive.com/content/chatgpt-analyze-spreadsheet-csv). The accuracy risk is real but specific. AI rarely gets a SUMIFS wrong when it writes the formula. It goes wrong when it quietly drops rows, counts duplicates twice, guesses what a column means, or reports a number it calculated in its head instead of in code. ## Where do analysts use AI day to day? - **Scoping.** Turning "can you pull some numbers on [churn](https://learn.ynteractive.com/content/glossary/customer-churn)?" into a clear question with a definition, a time frame and a comparison. - **Data profiling.** Columns, types, row counts, date ranges, duplicates, blanks and odd values, before any analysis. - **Cleaning.** Standardizing dates, fixing category spellings, removing subtotal rows from exports. - **Formulas and queries.** Writing and debugging Excel formulas, SQL and pandas from a plain description. - **Exploration.** Suggesting cuts of the data and chart types worth trying. - **Communication.** Findings for a manager, metric definitions, and documentation for a recurring report. The [prompts for data analysts](https://learn.ynteractive.com/content/prompts/roles/data-analysts) include ready-made versions of most of these, from writing SQL from a plain description to sanity-checking results. ## How do I keep AI analysis accurate? 1. **Profile first, ask second.** Ask what each column means, the row count, the date range, duplicates and blanks, and nothing else yet. 2. **Make the cleaning decisions yourself.** AI can find the duplicates. You decide whether they are real orders or a double export. 3. **Ask for formulas, not values.** In a workbook, formulas let anyone trace a total. In a chat, ask it to run code for calculations instead of estimating. 4. **Tie out.** Check one or two totals against the source system before anything goes to a stakeholder. 5. **Make it say what it assumed.** Ask for a list of assumptions and anything it could not determine. 6. **Keep the raw file.** Work on a copy, so you can rerun from the original. ## What does this look like in a real lesson? In [Analyze a Spreadsheet](https://learn.ynteractive.com/content/chatgpt-analyze-spreadsheet-csv), Maple Hollow Garden Center has six months of sales, about 1,200 orders, in a [CSV](https://learn.ynteractive.com/content/glossary/csv). You upload it to ChatGPT and ask only for the columns, row count, date range and any duplicates or blank cells. It finds three orders that appear twice and 12 rows with no channel. You tell it to remove the duplicates, label the blanks "Unknown" and give you the cleaned file, and you open that file to look at it. Only then do you ask for monthly revenue and the fastest-growing category, get a line chart you can download, and finish with three takeaways, each with its number, plus one thing to double-check. In [Use case: messy export to clean Excel workbook](https://learn.ynteractive.com/content/claude-excel-skill-messy-export-to-clean-workbook), [Claude](https://learn.ynteractive.com/content/glossary/claude) takes Willow Creek Plant Shop's messy till export (two title lines, dates in three formats, a subtotal line, a repeated row, "house plants" spelled three ways) and returns a workbook with a Data tab, a Summary tab and a chart. The reply lists every fix, including two duplicate rows it removed. In Excel, cell B4 and the grand total in E8 show SUMIFS and SUM formulas, so changing a sale updates everything. When an answer looks wrong, [Catch Made-up Facts Before They Reach Customers](https://learn.ynteractive.com/content/how-to-fix-bad-chatgpt-answers-push-back-constraints-fact-check) teaches the fix routine: point at the exact problem, add constraints, ask what it assumed and check facts against a source. ## Which tools do analysts use? - **ChatGPT** for uploading CSV and Excel files, running analysis in code and producing charts. - **Claude** for building real Excel workbooks with working formulas through its built-in Excel skill. - **Julius AI** for asking plain-English questions of a spreadsheet and getting charts and forecasts. - **Copilot in Excel** or **Gemini in Sheets** if your company already licenses them, so the data stays in your workspace. For a tool-by-tool view, see which AI tool can analyze an Excel spreadsheet. ## What mistakes should analysts avoid? - **Asking for insights before profiling.** - **Accepting cleaned data you have not opened.** - **Copying a number from the chat into a report** without a formula or code behind it. - **Uploading sensitive data to an unapproved tool.** Remove personal data your rules say should not leave the building. - **Letting a chart decide the story.** Check the axis, the filters and the time frame. ## Key takeaways - Use AI around the analysis: profiling, cleaning, formulas, queries and write-ups. - Profile first, then decide cleaning yourself. - Ask for formulas or code so every number is traceable. - Tie key totals back to the source before you share. ## Frequently asked questions **Can AI replace SQL for analysts?** It writes and debugs SQL quickly, but you still need to read the query and check the result, especially joins and filters. Knowing SQL makes AI more useful, not less. **How big a file can I upload to ChatGPT or Claude?** Both handle typical exports of thousands of rows, with limits that depend on the plan. For very large data, work in your database or warehouse and use AI for the queries. **How do I know the AI did not drop rows?** Ask for the row count before and after each step, and compare with the source. If the counts do not reconcile, ask it to list the rows it removed. ## Learn it hands-on Free, interactive lessons: you do every step yourself in a practice copy of the real tool, it checks your work as you go, and nothing touches your real accounts. - [Analyze a Spreadsheet with ChatGPT: Upload a CSV, Get a Chart and Three Takeaways](https://learn.ynteractive.com/content/chatgpt-analyze-spreadsheet-csv): Upload a CSV of sales to ChatGPT, have it check the data first, ask your questions, get a chart you can download, and finish with the three… (about 10 minutes) - [Claude's Excel Skill: Turn a Messy Export into a Clean Workbook](https://learn.ynteractive.com/content/claude-excel-skill-messy-export-to-clean-workbook): Upload a messy sales export to Claude and get back a clean Excel workbook with a Data tab, a Summary tab built with formulas, and a chart, thanks to… (about 8 minutes) - [Catch Made-up Facts Before They Reach Customers using ChatGPT](https://learn.ynteractive.com/content/how-to-fix-bad-chatgpt-answers-push-back-constraints-fact-check): Leave gaps in a prompt and ChatGPT fills them: a stiff paragraph, a made-up policy and a made-up fact. Point at the exact problem, add constraints… (about 7 minutes) [Start the free lesson](https://learn.ynteractive.com/modules/chatgpt-analyze-spreadsheet) ## AI tools in this answer Each one in the Stepthrough AI tools directory: what it does, who it is for and the free lesson where there is one. [ChatGPT](https://learn.ynteractive.com/content/ai-tools/tool/chatgpt) · [Claude](https://learn.ynteractive.com/content/ai-tools/tool/claude) · [Julius AI](https://learn.ynteractive.com/content/ai-tools/tool/julius-ai) [The full AI tools directory](https://learn.ynteractive.com/content/ai-tools) ## Related terms Plain-English definitions, each with an example from a free lesson. [Customer churn](https://learn.ynteractive.com/content/glossary/customer-churn) · [CSV](https://learn.ynteractive.com/content/glossary/csv) · [Claude](https://learn.ynteractive.com/content/glossary/claude) · [Code execution and file creation](https://learn.ynteractive.com/content/glossary/code-execution) · [Hallucination check](https://learn.ynteractive.com/content/glossary/hallucination-check) · [LLM as a judge](https://learn.ynteractive.com/content/glossary/llm-as-a-judge) [The full AI glossary](https://learn.ynteractive.com/content/glossary) ## Related prompts - [Messy export to workbook prompt](https://learn.ynteractive.com/content/prompts/messy-export-to-workbook-prompt): A copy-ready prompt that tells Claude exactly how to clean a messy CSV export into an Excel workbook with a data tab, a formula… - [Timesheet summary prompt](https://learn.ynteractive.com/content/prompts/timesheet-summary-prompt): A ChatGPT prompt that turns a timesheet export into a summary: hours by person and project, missing days, unusual entries and… - [Change one fact, show what moved prompt](https://learn.ynteractive.com/content/prompts/change-one-fact-and-show-what-moved-prompt): A follow-up prompt for a ChatGPT chat that tells the AI one new fact, then asks it to redo the work and list exactly which… [All free prompt templates](https://learn.ynteractive.com/content/prompts) ## Related questions - [Can AI do account reconciliations accurately enough to trust?](https://learn.ynteractive.com/content/questions/can-ai-do-account-reconciliations): AI can match rows and list exceptions fast, but you can trust it only after you check the exceptions and do the math yourself… - [How are accountants using AI to speed up month-end close?](https://learn.ynteractive.com/content/questions/how-accountants-use-ai-month-end-close): Mostly for the matching, cleaning and explaining: bank recs, flux commentary, accrual lists and close checklists, with every… - [How should a finance team start using AI without breaking controls?](https://learn.ynteractive.com/content/questions/how-to-start-using-ai-in-finance): Treat AI as a preparer, never an approver: written rules, an approved tool, a person who reviews and evidence you keep. A plan… - [Can AI run payroll, or only help around it?](https://learn.ynteractive.com/content/questions/can-ai-run-payroll): No, the pay math, tax filing and deposits stay in your payroll system. AI helps with pre-run checks, employee questions and… - [What AI skills do employers want from office workers?](https://learn.ynteractive.com/content/questions/ai-skills-employers-want): Clear prompting, checking AI output, good judgment about data and knowing when to automate. What each skill looks like at work… - [Can I do real work with only free AI tools?](https://learn.ynteractive.com/content/questions/can-free-ai-tools-do-real-work): Yes for everyday writing, summaries and small spreadsheet jobs. Free tiers hit limits on volume, agents and client data. See… [More questions: AI by department](https://learn.ynteractive.com/content/questions/by-department) · [All AI questions](https://learn.ynteractive.com/content/questions) · [All free tutorials](https://learn.ynteractive.com/content)