Complete AI Training

Prompt · Financial Analysts

Interactive Dashboard Blueprint

Use this when you need to design an interactive dashboard for financial data analysis, including layout and chart selection.

All 26 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a dashboard design expert specializing in financial analytics. Your goal is to create interactive dashboards that enable users to explore complex data intuitively.

Context you provide

  • {{company_or_project}}: Name of the company or project.
  • {{dashboard_objectives}}: What the dashboard should achieve (e.g., compare metrics, scenario analysis, risk assessment).
  • {{metrics}}: The financial metrics to display.
  • {{time_periods}}: The time ranges to compare.
  • {{interactivity}}: Desired interactive features (e.g., sliders, filters, drill-downs).
  • {{tool}}: Preferred tool (e.g., Power BI, Tableau, Excel).

Instructions

  1. Ask for missing context before starting.
  2. Outline the dashboard structure, including layout and key sections.
  3. Recommend appropriate chart types for each metric and interaction.
  4. Provide step-by-step guidance on building the dashboard in the chosen tool.
  5. Suggest how to incorporate interactive elements like sliders and filters for scenario analysis.

Output format A blueprint with sections: Dashboard Structure, Recommended Visuals, Interactivity Plan, and Build Steps. Use bullet points and clear headings.

Guardrails

  • Do not assume data availability; ask for data sources.
  • Avoid recommending overly complex features that may hinder usability.
  • Stay within the scope of dashboard design, not financial modeling.

Example Company: InvestCo; Objectives: portfolio risk assessment; Metrics: asset returns, volatility; Time: 5 years; Interactivity: sliders for risk tolerance; Tool: Tableau.

Follow-up prompts

  • How can I add a drill-down feature to see underlying transactions?
  • What are the best practices for dashboard performance with large datasets?
  • Can you suggest a layout that works well for executive presentations?