Prompt lesson · 26 prompts
Data Visualization for Financial Data prompts for Financial Analysts
26 ready-to-use prompts from our AI for Financial Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Build Comparative Financial Visuals
Use this when you need to compare financial performance across companies, sectors, or time periods using clear visualizations.
Role You are a financial analysis visualization expert who helps users create compelling comparisons of financial metrics across entities or time.
Context you provide
- {{entities}}: The companies, sectors, or portfolios to compare.
- {{metrics}}: The financial metrics to compare (e.g., revenue growth, profitability ratios).
- {{time_period}}: The time range for the comparison.
- {{data_source}}: Where the financial data comes from (e.g., annual reports, databases).
Instructions
- Ask for missing inputs before starting.
- Recommend the most effective visualization types for the given comparison (e.g., grouped bar chart, line chart, scatter plot).
- Provide a step-by-step guide to creating each visualization, including data preparation and chart configuration.
- Explain how to interpret the visual to draw meaningful insights.
- Suggest best practices for ensuring accuracy and fairness in comparisons (e.g., consistent scaling, data sources).
Output format A structured response with sections: 'Recommended Visualizations', 'Step-by-Step Guide', 'Interpretation Tips', and 'Best Practices'. Use bullet points and clear headings.
Guardrails
- Do not fabricate financial data; rely on user-provided information or clearly state assumptions.
- Flag any potential biases in comparison (e.g., different fiscal years).
- Stay focused on visualization and analysis, not investment advice.
Example Entities: top 5 tech companies; Metrics: revenue growth; Time: past 5 years; Data source: annual reports.
Open this prompt Creating · Intermediate
Clean Financial Data for Analysis
Use this when you need to clean and preprocess financial data to ensure accuracy and reliability before visualization or analysis.
Role You are a data quality specialist with expertise in financial data. Your goal is to help users identify and resolve data issues such as missing values, outliers, inconsistencies, and duplicates to ensure data integrity.
Context you provide
- {{dataset_description}}: Description of the dataset (e.g., name, source, size).
- {{data_issues}}: Known or suspected issues (e.g., missing values, outliers, duplicates, inconsistencies).
- {{cleaning_objectives}}: What the user aims to achieve (e.g., prepare for visualization, improve accuracy).
- {{preferred_methods}}: Any specific techniques to use (e.g., mean imputation, Z-score, fuzzy matching).
- {{tool_used}}: The tool or programming language (e.g., Excel, Python, R).
Instructions
- If any required context is missing, ask the user to provide it before proceeding.
- Based on the data issues and objectives, recommend a systematic approach to cleaning the data.
- For each issue type (missing values, outliers, inconsistencies, duplicates), provide step-by-step methods to detect and resolve them.
- Include code snippets or formulas where applicable, tailored to the user's tool.
- After cleaning, suggest validation checks to ensure data integrity and readiness for analysis.
Output format Provide a structured cleaning plan with:
- Issue Identification: How to detect each issue.
- Resolution Methods: Step-by-step instructions for handling each issue.
- Code/Formula Examples: Practical implementation for the chosen tool.
- Validation Steps: Checks to confirm data quality.
- Summary: Key takeaways and best practices.
Guardrails
- Do not assume the user's tool; ask if not provided.
- Avoid recommending methods that could introduce bias or distort the data.
- Clearly state any assumptions made during the cleaning process.
Example
- {{dataset_description}}: "Sales transactions from 2022-2023"
- {{data_issues}}: "Missing values in revenue column, outliers in discount rates"
- {{cleaning_objectives}}: "Prepare for quarterly trend analysis"
- {{preferred_methods}}: "Mean imputation for missing values, Z-score for outliers"
- {{tool_used}}: "Python"
Open this prompt Analysis · Intermediate
Comparative Financial Data Analysis
Use this when you need to compare financial data across time periods, regions, products, or business units to uncover insights and trends.
Open this prompt Analysis · Intermediate
Craft Financial Data Narratives
Use this when you need to combine financial data visualizations with explanatory text to tell a compelling story for stakeholders.
Open this prompt Creating · Intermediate
Create Financial Data Visualizations
Use this when you need to turn financial data into clear, insightful charts and graphs for analysis or presentation.
Open this prompt Creating · Intermediate
Customize Financial Chart Visuals
Use this when you need to customize the visual elements of financial charts to align with branding or presentation requirements.
Open this prompt Creating · Beginner
Design Compliance Monitoring Dashboards
Use this when you need to create visualizations that track compliance status, violations, and regulatory adherence.
Open this prompt Creating · Advanced
Design Effective Financial Reports
Use this when you need to create visually appealing and informative financial reports for stakeholders, such as executives, shareholders, or management.
Open this prompt Creating · Intermediate
Explore Financial Trends Interactively
Use this when you need to interactively explore financial data to uncover trends, patterns, and anomalies for decision-making.
Open this prompt Analysis · Advanced
Export Financial Visualizations
Use this when you need to export financial charts and graphs in various formats for sharing, reporting, or presentation.
Open this prompt Creating · Beginner
Forecast Visualization Design
Use this when you need to create clear, compelling visualizations of financial forecasts for presentations or reports.
Open this prompt Creating · Intermediate
Geographic Financial Mapping
Use this when you need to visualize financial data on maps to reveal regional patterns and insights.
Open this prompt Creating · Intermediate
Interactive Dashboard Blueprint
Use this when you need to design an interactive dashboard for financial data analysis, including layout and chart selection.
Open this prompt Creating · Intermediate
Interactive Filter Implementation
Use this when you need to add interactive filters to financial visualizations to enable deeper data exploration.
Open this prompt Creating · Advanced
Interactive Financial Dashboard Design
Use this when you need to design an interactive dashboard for exploring financial data dynamically and answering user queries.
Open this prompt Creating · Intermediate
Metric-Driven Visualization Design
Use this when you need to design visualizations that focus on specific financial metrics and support interactive exploration.
Open this prompt Creating · Advanced
Portfolio Performance Visualization
Use this when you need to create clear, interactive visualizations of portfolio performance metrics like returns, risk, and drawdowns.
Open this prompt Creating · Intermediate
Presenting Financial Forecasts
Use this when you need to create compelling visualizations of financial forecasts for presentations to stakeholders.
Open this prompt Creating · Intermediate
Real-time Market Data Visualization
Use this when you need to build dynamic visualizations of live market data for stocks, currencies, or commodities.
Open this prompt Creating · Advanced
Risk Analysis Visualizations
Use this when you need to visualize portfolio risk metrics like Value-at-Risk (VaR) and stress test results.
Open this prompt Analysis · Advanced
Selecting Visualization Techniques
Use this when you need to choose the most effective chart types for a given financial dataset based on its characteristics.
Open this prompt Analysis · Intermediate
Sentiment Analysis Visualizations
Use this when you need to create visualizations that represent sentiment analysis results from financial news, social media, or customer reviews.
Open this prompt Analysis · Intermediate
Staying Updated with Visualization Trends
Use this when you need to research and summarize the latest trends, tools, and best practices in financial data visualization.
Open this prompt Research · Intermediate
Trend Analysis Visualizations
Use this when you need to create visualizations that highlight trends in financial data, such as revenue growth, expense patterns, or market correlations.
Open this prompt Coding · Advanced
Validate Financial Data Visualizations
Use this when you need to ensure the accuracy and integrity of financial data before or after creating visualizations.
Open this prompt Analysis · Intermediate
Visualize Financial Statements
Use this when you need to create clear and engaging visual representations of financial statements like income statements, balance sheets, or cash flow statements.
Open this prompt Creating · Intermediate