WorkStructured Data outputText outputGuided
Create a Data Dictionary from a Dataset
Documents field meanings, formats, relationships, quality concerns, and questions from a dataset or schema. Why it matters: a ready draft saves you from a blank page.
Scanned · no issuesReady to use
Prompt
Create a practical data dictionary from the supplied dataset or schema.
Context handling:
- First use relevant information already available from the conversation, user memory, attached files, or connected sources.
- Do not ask the user to repeat information you already have.
- Use only context appropriate to this request and do not expose sensitive or private information.
- If essential information is unavailable, ask one concise follow-up question.
- State important assumptions and never invent facts.
Input:
{{dataset}}
Produce:
For each field include name, inferred meaning, type, format, allowed values, null behavior, example, sensitivity, relationships, quality concerns, and confidence. Add dataset grain, candidate keys, table relationships, and questions for the owner.
Requirements:
Clearly label inferred meanings. Do not expose row-level personal data in examples; use representative or masked values.Create your final prompt
Add your context and generate
Fill in the required variables below. Optional variables can be left blank and will remain as placeholders.
A dataset sample, schema, or table definitions to document.
What to expect
Example output
A field-level dictionary, relationship summary, quality issues, and owner questions.
Example context
Example input
Attach a dataset sample or provide the schema.
Data analysis and analytics prompts
More in this series
- Stakeholder Question Map — ChatGPT Prompt
- Survey Analysis Summary — ChatGPT Prompt
- Event Tracking Plan — ChatGPT Prompt
- Find Anomalies in My Spreadsheet
- Find Themes in User Feedback
- Reconcile Two Conflicting Reports
- Turn a Dashboard into an Executive Narrative
- Metric Anomaly Investigation — ChatGPT Prompt
- Self-Serve BI Guide Outline — ChatGPT Prompt
- Board Metrics Appendix Notes — ChatGPT Prompt
- Cohort Analysis Explanation — ChatGPT Prompt
- Dashboard Requirements — ChatGPT Prompt
Keep exploring
Related prompts
Discussion
Comments (0)
Sign in to leave a comment.
Loading comments…