Prompt lesson · 21 prompts
Data Analysis and Reporting prompts for IT Project Managers
21 ready-to-use prompts from our AI for IT Project Managers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Assess and Improve Data Quality
Use this when you need to evaluate the quality of a dataset, identify issues or biases, and suggest improvements.
Role You are a data quality analyst. Your goal is to assess the completeness, accuracy, and representativeness of a dataset, and to recommend practical improvements.
Context you provide
- {{dataset_name}}: The name or description of the dataset.
- {{data_fields}}: The key fields or variables included.
- {{collection_method}}: How the data was collected (e.g., surveys, system logs, third-party).
- {{quality_concerns}}: Any specific issues you suspect (e.g., missing values, duplicates, bias).
Instructions
- If any context is missing, ask for it before proceeding.
- Evaluate the dataset for completeness (missing values), accuracy (errors), and representativeness (sampling bias).
- Identify potential biases (e.g., selection, response, measurement) and their likely impact.
- Suggest concrete improvements for data collection and storage processes.
- Prioritize recommendations based on effort and impact.
Output format Provide a structured assessment with sections: Data Quality Overview, Issues Identified, Bias Analysis, Improvement Recommendations, and Prioritized Action Plan. Use tables and bullet points. Tone: analytical and constructive.
Guardrails
- Do not assume data issues without evidence; base findings on provided information.
- Clearly distinguish between observed issues and potential risks.
- Stay within the scope of data quality; avoid unrelated data science advice.
Example Dataset: 'customer_survey_2024'; fields: age, satisfaction score, region; collection method: online survey; concerns: low response rate from older users.
Open this prompt Analysis · Intermediate
Automated Data Visualization System
Use this when you need to design a system that automatically turns raw data into clear, customizable charts and graphs for stakeholders.
Role You are a data visualization architect and IT project manager. Your goal is to design a robust, automated system that transforms raw data into insightful, customizable visualizations for diverse stakeholders.
Context you provide
- {{data_source}}: Where the raw data comes from (e.g., CSV exports, databases, APIs).
- {{visualization_types}}: The types of charts/graphs needed (e.g., bar, line, scatter, heatmap).
- {{stakeholder_needs}}: Who will use the visuals and what decisions they need to support.
- {{customization_requirements}}: Any specific branding, interactivity, or filtering needs.
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Outline a step-by-step architecture for the automated visualization pipeline, from data ingestion to rendering.
- Recommend specific tools and libraries (e.g., Python, Tableau, Power BI, D3.js) suitable for the given data source and stakeholder needs.
- Describe how to customize visualizations—such as color schemes, labels, and interactive filters—to meet the stakeholder requirements.
- Provide a plan for testing and validating the system to ensure accuracy and performance.
Output format Provide a structured plan with sections: Architecture Overview, Tool Recommendations, Customization Strategy, and Implementation Steps. Use bullet points and keep the tone professional and technical.
Guardrails
- Do not invent specific tool capabilities; stick to well-known features.
- If data source details are vague, state assumptions and ask for clarification.
- Stay focused on the visualization system design, not on data analysis itself.
Example
- {{data_source}}: "Sales data from our CRM (CSV export)", {{visualization_types}}: "Monthly revenue trend line chart and regional bar chart", {{stakeholder_needs}}: "Sales managers need to spot underperforming regions", {{customization_requirements}}: "Include company colors and drill-down by product category."
Open this prompt Creating · Intermediate
Build Predictive Models
Use this when you need to forecast trends or outcomes from historical data using machine learning.
Open this prompt Analysis · Advanced
Customer Segmentation Analysis
Use this when you need to segment customers based on behavior, demographics, or preferences to enable targeted marketing and personalized experiences.
Open this prompt Analysis · Intermediate
Data Analysis Report Generation
Use this when you need to turn data analysis findings into a clear, actionable report with insights and recommendations.
Open this prompt Creating · Intermediate
Data Cleaning and Quality Improvement
Use this when you need to identify and fix data quality issues to ensure accuracy and reliability.
Open this prompt Analysis · Intermediate
Data Quality Assurance System
Use this when you need to design a data quality assurance system to detect inconsistencies and errors in your datasets, ensuring reliable reporting.
Open this prompt Creating · Advanced
Data-Driven Decision Support
Use this when you need to build a decision support system that uses data analysis to provide recommendations for resource allocation, risk management, and KPI tracking.
Open this prompt Creating · Advanced
Design Interactive Dashboards
Use this when you need to design, prototype, or plan interactive dashboards for real-time data analysis and reporting.
Open this prompt Planning · Intermediate
Exploratory Data Analysis Guidance
Use this when you need to explore a dataset to uncover patterns, trends, and relationships, and get recommendations on statistical techniques and visualizations.
Open this prompt Analysis · Intermediate
Fraud Detection System Setup
Use this when you need guidance on implementing an automated fraud detection system that analyzes transactional data for anomalies.
Open this prompt Planning · Advanced
Interactive Dashboard Design
Use this when you need to design and build interactive dashboards that allow users to explore data and customize their own reports.
Open this prompt Creating · Intermediate
Interactive Data Visualization
Use this when you need to create interactive visualizations to explore relationships, distributions, or sentiment in your data.
Open this prompt Creating · Intermediate
Interpret Data Analysis Results
Use this when you need help interpreting the results of a data analysis, including trends, outliers, and correlations.
Open this prompt Analysis · Intermediate
Optimize Resource Allocation
Use this when you need to analyze resource allocation data to improve efficiency and cost-effectiveness in projects.
Open this prompt Analysis · Intermediate
Perform Statistical Data Analysis
Use this when you need to conduct statistical tests or analyses to derive insights from data, such as hypothesis testing, regression, or clustering.
Open this prompt Analysis · Intermediate
Predictive Analytics Model Guidance
Use this when you need to understand, select, or implement machine learning models for predictive analytics based on historical data.
Open this prompt Analysis · Intermediate
Preprocess Data for Analysis
Use this when you need to transform, normalize, or engineer features in a dataset to prepare it for analysis or machine learning.
Open this prompt Analysis · Intermediate
Real-Time Data Monitoring Setup
Use this when you need to design and implement a real-time data monitoring solution with alerts for anomalies and trends.
Open this prompt Planning · Advanced
Sentiment Analysis Tool Development
Use this when you need to build a sentiment analysis tool to extract insights from customer feedback across various sources.
Open this prompt Creating · Intermediate
Trend Analysis Tool Design
Use this when you need to design a trend analysis tool to identify patterns in historical data and inform strategic decisions.
Open this prompt Planning · Advanced