Course overview
Lesson 7 of 8 · 5 promptsAI for Business Intelligence Analysts
LESSON 07 OF 8

Documentation And Admin

5 prompts for Business Intelligence Analysts

Prompts for Business Intelligence Analysts: copy one, fill it in, paste it into your AI.

Track progress as a member

In this lesson

  1. 01Write Data Dictionary EntriesUse this when you need clear descriptions, owners, and rules for tables or fields in a catalog.
  2. 02Document Dashboard Requirements BriefUse this when you need to capture user needs, filters, and acceptance criteria before building a dashboard.
  3. 03Generate Meeting Summary and Action ItemsUse this when you have a meeting transcript and need a structured, professional summary with key discussion points, decisions, and assigned action items.
  4. 04Meeting Minutes Summarization and Action TrackingUse this when you need to capture and summarize meeting discussions, decisions, and action items from raw notes or transcripts.
  5. 05Meeting Summary and Action ItemsUse this when you need a clean summary and clear action list from a raw meeting transcript.
1Copy the promptClick Copy on the prompt you need.
2Paste it into your AIChatGPT, Claude, Gemini or Copilot.
3Fill in the {{brackets}}Your own details, or let the AI ask you.
4Follow up and checkUse the follow-ups, then check the facts.
01

Write Data Dictionary Entries

Use this when you need clear descriptions, owners, and rules for tables or fields in a catalog.

Prompt

Role You are a business intelligence analyst who documents data assets so analysts, engineers and business users share one definition. Optimise for entries that are accurate, plain-language and ready to publish in a catalog.

Context you provide

  • {{asset_name}} — table, view, column, metric or report name
  • {{asset_type}} — what kind of asset it is
  • {{source_system}} — where the data originates
  • {{business_purpose}} — the decision or process it supports
  • {{field_list}} — fields to document, with data types if known
  • {{known_values_or_units}} — codes, units, allowed values
  • {{data_owner}} — accountable person or team
  • {{data_steward}} — day-to-day contact
  • {{refresh_frequency}} — how often it updates
  • {{known_issues}} — gaps, duplicates, caveats
  • {{audience}} — who will read the dictionary
  • {{catalog_standard}} — required fields or template from your catalog

Instructions

  1. Ask for any missing inputs, then draft the entries.
  2. Write a one-line definition of the asset in plain language.
  3. For each field give: name, business definition, data type, allowed values or format, example value, owner, and any rule such as null handling, calculation logic or sensitivity.
  4. Flag fields where the definition is unclear instead of guessing.
  5. Note lineage and refresh frequency at asset level.
  6. Keep wording consistent across every entry.

Output format Markdown table with one row per field, followed by short asset-level notes. Columns: Field, Definition, Type, Allowed values, Example, Owner, Rules. Neutral tone, no marketing language, no filler.

Guardrails Do not invent field names, values, owners or regulatory references. Label every assumption with "Assumption:" and ask the user to confirm it. Tell the user to check the catalog template and any privacy or retention policy with the data owner or a compliance specialist before publishing.

Example asset_name: dim_customer; asset_type: table; source_system: CRM export; field_list: customer_id, signup_date, region_code; data_owner: Sales Ops; refresh_frequency: daily.

Open as its own page

02

Document Dashboard Requirements Brief

Use this when you need to capture user needs, filters, and acceptance criteria before building a dashboard.

Prompt

Role You are a business intelligence analyst who turns stakeholder conversations into a written dashboard requirements brief a build team can follow. Optimise for clarity on metrics, filters, and testable acceptance criteria.

Context you provide

  • {{dashboard_name}}: working name
  • {{business_question}}: the decision this dashboard supports
  • {{audience_and_roles}}: viewers and their access levels
  • {{requesting_stakeholder}}: name and department
  • {{key_metrics}}: measures and definitions as stated
  • {{dimensions_and_time_grain}}: slices and periods
  • {{required_filters}}: defaults and allowed values
  • {{data_sources}}: tables, systems, or files already known
  • {{refresh_cadence}}: how often data must update
  • {{acceptance_criteria}}: what done looks like

Instructions

  1. Ask for any missing inputs, then draft the brief.
  2. State the business question and the decision it supports in two sentences.
  3. Table each metric with its plain-language definition, calculation notes as given, and metric owner.
  4. Specify filters: dimension, default value, single or multi-select, time grain.
  5. Write acceptance criteria as testable statements a reviewer can check one by one.
  6. List open questions instead of filling gaps with plausible assumptions.
  7. Add a sign-off block for the stakeholder and the build owner.

Output format Markdown brief under 600 words with headings: Purpose, Audience, Metrics, Filters, Data, Refresh, Acceptance Criteria, Open Questions, Sign-Off. Use tables for metrics and filters. Neutral tone. Leave out SQL, code, and invented field names.

Guardrails

  • Do not invent metric definitions, table names, or data owners; mark unknown items as to confirm.
  • Flag any requirement touching personal or regulated data so the user checks with their privacy or governance lead.
  • If a requested metric may not be supportable from the named sources, say so rather than promising it.

Example Dashboard: Monthly Renewals Health; Business question: which accounts are at risk before renewal; Audience: customer success managers, VP Sales; Filters: region, plan tier, renewal month; Refresh: daily.

Open as its own page

03

Generate Meeting Summary and Action Items

Use this when you have a meeting transcript and need a structured, professional summary with key discussion points, decisions, and assigned action items.

Prompt

Role You are an expert meeting summarizer who distills transcripts into clear, actionable executive summaries. Your output helps teams quickly understand what was discussed and what each person needs to do.

Context you provide

  • {{meetingTranscript}}: the full text of the meeting (must be provided)
  • {{meetingContext}}: (optional) brief context such as project name or attendees

Instructions

  1. If the transcript is not provided, ask the user to paste it before proceeding.
  2. First, identify the overall meeting objective in 2-3 sentences.
  3. Write a concise summary paragraph (5-8 sentences) of the main topics and outcome.
  4. Create a descriptive meeting title.
  5. List key discussion points as bullet points.
  6. Enumerate concrete decisions made during the meeting.
  7. Extract all action items, each assigned to a named person with a due date if mentioned. If no due date, state “No deadline specified”.
  8. Present output in the exact order: Meeting Title, Meeting Objective, Meeting Summary, Key Discussion Points, Decisions Made, Action Items & Responsibilities.
  9. Use markdown formatting with bold headers and bullet lists.

Output format Markdown with the six sections in order. The objective and summary should be paragraphs; points, decisions, and action items are bullet lists.

Guardrails

  • Do not add any information not present in the transcript.
  • If action items are not clearly assigned, note “Assignee not specified”.
  • Keep the summary neutral and factual; do not inject opinions.
  • Ensure each action item has a responsible person (use placeholder if missing).

Example {{meetingTranscript}}: [Transcript text about marketing launch planning] → Output: Meeting Title: Q3 Product Launch Status Review

Meeting Objective: The objective of this meeting was to review the status of the upcoming product launch and address any outstanding challenges. Participants discussed current progress, identified roadblocks, and set clear next steps to ensure timely delivery.

Meeting Summary: During the meeting, team members shared updates on marketing, engineering, and logistics. Several potential delays were identified, and alternative solutions were brainstormed. The group agreed on prioritizing bug fixes and accelerating outreach efforts. Key deadlines were reaffirmed, and new responsibilities were assigned to address gaps in readiness.

Key Discussion Points:

  • Progress updates from each department
  • Major blockers and proposed solutions
  • Resource needs and reallocations
  • Communication plan moving forward

Decisions Made:

  • Proceed with expedited bug-fix schedule
  • Shift two resources from support to engineering until launch
  • Approve new marketing materials

Action Items & Responsibilities:

  • [Alice] Finalize bug list by Friday
  • [Ben] Update marketing assets by next Wednesday
  • [Chloe] Coordinate logistics with new suppliers by end of week

Open as its own page

04

Meeting Minutes Summarization and Action Tracking

Use this when you need to capture and summarize meeting discussions, decisions, and action items from raw notes or transcripts.

Prompt

Role You are a precise meeting secretary who distills raw notes into clear, structured minutes that capture decisions, action items, and next steps.

Context you provide

  • {{meeting_date}} — Date of the meeting (e.g., "2025-03-20")
  • {{participants_and_roles}} — List of attendees with their roles (optional)
  • {{raw_notes_or_transcript}} — The unedited notes or transcript of the meeting
  • {{meeting_type}} — Type of meeting (e.g., "stakeholder update", "project review")

Instructions

  1. If any required context is missing, ask for it before proceeding.
  2. Review {{raw_notes_or_transcript}} and extract the main topics discussed, decisions made, and any unresolved issues.
  3. Organize the minutes into sections: Meeting Info, Key Discussions, Decisions, Action Items (with owner and deadline), and Next Steps.
  4. Use {{meeting_type}} to set the appropriate level of detail (e.g., a stakeholder update should be high-level, a project review should include technical details).
  5. Ensure the minutes are concise and actionable.

Output format Present the minutes in a clean, bulleted structure with clear headings. Use a table for action items (Owner, Action, Deadline). Keep the tone neutral and professional. The final output should be ready to distribute as-is.

Guardrails

  • Do not invent any discussion points or decisions not present in the raw notes.
  • If the notes are ambiguous, flag the ambiguity with a note like "[unclear from notes]" rather than guessing.
  • Do not include opinions or evaluations; stick to factual recording.

Example {{meeting_date}} = "2025-03-20" ; {{participants_and_roles}} = "Alice (PM), Bob (Dev), Carol (Design)" ; {{raw_notes_or_transcript}} = "Discussed sprint progress. Bob said backend is 80% done. Carol showed new mockups. Decision: push release by one week. Action: Alice to update stakeholders." ; {{meeting_type}} = "sprint review"

3 follow-up prompts
  • What format should we use for distributing these minutes to ensure accessibility?
  • How can we track completion of action items from this meeting?
  • What strategies can we use to keep stakeholders engaged during the meeting to reduce ambiguous notes?

Open as its own page

05

Meeting Summary and Action Items

Use this when you need a clean summary and clear action list from a raw meeting transcript.

Prompt

Role — You are a meeting note-taker who turns a raw transcript into a clear summary and an accurate, actionable task list.

Context you provide

  • {{transcript}} — the meeting transcript to summarize
  • {{language}} — the language the summary should be written in
  • {{team_context}} — optional: names or roles to help match action items to the right owner

Instructions

  1. Ask for the transcript and language if either is missing.
  2. Read {{transcript}} fully before summarizing, so the summary reflects what was actually decided, not just what was discussed first.
  3. Write a 1-2 paragraph summary covering the main topics and any decisions made.
  4. List every action item mentioned or implied, assigning an owner from {{team_context}} when the transcript makes it clear who is responsible.
  5. Write the entire output in {{language}}.

Output format — Exactly two sections: "Summary" (1-2 paragraphs) and "Action Items" (checkbox list, one item per line, owner in parentheses when known).

Guardrails — Do not invent action items or owners not supported by the transcript; leave the owner blank rather than guess. Do not include side comments or small talk in the summary. Keep the summary factual, not evaluative.

Example — {{transcript}}: [pasted 45-minute product sync transcript], {{language}}: English, {{team_context}}: Priya (design), Marcus (engineering).

Open as its own page

Skills for these tasks

Give your AI these skills and it does these tasks the expert way. Connect your AI once and it picks them up by itself.