Map and inspect an unfamiliar data export
Quickly understand the purpose, column types, and data quality risks of a messy raw CSV export. Ideal when inheriting unfamiliar operations sheets.
You getDataset Summary, column Dictionary and immediate Audit Steps
Prompt
Act as a senior data analyst. Review the sample rows and header names pasted below to help me understand this unfamiliar dataset.
- Infer the business purpose of the file and define each column plainly.
- Flag probable primary keys, date formats, and numeric types.
- List potential data quality issues, missing values, or edge cases to inspect before doing analysis.
Output format:
1. Dataset Summary (2 sentences on likely source and purpose)
2. Column Dictionary (table with columns: Column Name, Inferred Data Type, Description, Expected Values)
3. Immediate Audit Steps (bulleted checklist of what to check in the raw data)
Here is the data snippet:Example output
Paste your CSV header row and 5 to 10 representative rows into ChatGPT, Claude, or Gemini right after the prompt. As a follow-up, ask the model to write an SQL query or pandas snippet to run the suggested audits.
Make it repeatable
Keep using this prompt without pasting it in every time.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Screen survey data for duplicate and low-effort responses
Audit raw survey records for gibberish, straightlining, rapid completion times, and duplicate entries to clean your dataset.
Plan an exploratory data analysis from scratch
Generate a practical exploratory data analysis plan when starting with unfamiliar data. Frame key business questions, data hygiene checks, and visualization priorities.
Separate true anomalies from pipeline data errors
Classify extreme values as either legitimate business events or pipeline errors. Use it when high or low metrics distort downstream reporting.
Summarize weekly metric anomalies into executive briefings
Convert raw week-over-week metric spikes and drops into concise executive briefs with business context and next steps.
Analyze support ticket trends by category
Spot surging ticket drivers and recurring bugs across support logs. Use this to allocate team coverage and escalate product flaws quickly.
Convert monthly operations metrics to executive updates
Translate complex monthly performance metrics into a concise executive briefing. Use this before executive staff meetings to showcase key wins and blockers.
- Select three core KPIs for your business goal
- Build three scenarios for revenue and demand forecasts
- Evaluate past forecast variances to set accurate targets
- Isolate regional or platform drivers behind KPI drops
- Differentiate structural null values from missing data
- Map inconsistent export columns to target schemas