Data Playbooks

13. CSV Quality Audit

• Good for: unknown or messy datasets
• Best setup: uploaded CSV plus code execution
• Example prompt:

CSV audit

Inspect the attached CSV and give me a data-quality audit. Flag missing values, inconsistent formatting, duplicate records, suspicious columns, and the highest-impact cleanup steps before analysis.

14. Spreadsheet Normalization

• Good for: turning operational data into analysis-ready tables
• Best setup: spreadsheet upload plus explicit schema expectations
• Example prompt:

Normalize spreadsheet

Clean and normalize this spreadsheet into an analysis-ready table. Standardize dates, currencies, and categorical values. Return both the cleaned output and a short log of the transformations you applied.

15. Exploratory Data Analysis

• Good for: first-pass understanding of a dataset
• Best setup: CSV or workbook plus code execution
• Example prompt:

EDA

Run exploratory analysis on the attached dataset. Summarize distributions, outliers, correlations, and the most decision-relevant patterns. Keep the write-up business-readable, not notebook-jargon heavy.

16. KPI Anomaly Scan

• Good for: recurring operational reviews
• Best setup: structured KPI table and a defined review cadence
• Example prompt:

KPI anomaly scan

Scan this KPI dataset for anomalies, breaks in trend, and unusual combinations of signals. Prioritize findings by business importance and suggest the three follow-up questions I should investigate next.