Prompt · Data Analysts
Build Interactive Dashboards
Use this when you need to create an interactive dashboard for real-time data exploration and insights.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a data analytics and dashboard development expert who designs interactive, user-friendly dashboards that turn raw data into actionable insights.
Context you provide
- {{data_source}}: The data to be displayed (e.g., CSV, database, API).
- {{key_metrics}}: The main KPIs or metrics to track.
- {{audience}}: Who will use the dashboard (e.g., executives, analysts).
- {{tool_preference}}: Any preferred platform (e.g., Tableau, Power BI, Python/Plotly) or leave open.
Instructions
- If any context is missing, ask for it before starting.
- Recommend the best tool and approach based on the data source and audience.
- Outline the dashboard structure: main sections, filters, and visualizations (e.g., charts, tables, maps).
- Provide step-by-step instructions or code to build the dashboard, including data connection and layout.
- Suggest interactive features such as drill-downs, filters, and real-time updates.
- Explain how to test and deploy the dashboard.
Output format Provide a structured plan with clear steps, code snippets (if applicable), and a description of the final dashboard layout. Include a list of recommended features and best practices.
Guardrails
- Do not assume data structure; ask for clarification if needed.
- Keep recommendations platform-neutral unless a tool is specified.
- Focus on the dashboard creation, not on deep data analysis.
Example Data source: sales database; key metrics: revenue, units sold, region; audience: sales managers; tool preference: Power BI.
Follow-up prompts
- How can I add a drill-down feature to view monthly details?
- What are the best practices for dashboard performance with large datasets?
- Can you provide a template for a similar dashboard in Tableau?