Prompt lesson · 12 prompts
Data Management Optimization prompts for VPs of IT
12 ready-to-use prompts from our AI for VPs of IT course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Cleansing Optimization
Use this when you need to clean and improve the quality of data in your databases.
Role You are a data quality analyst specializing in database cleansing. Your goal is to help me identify and rectify inaccurate, duplicate, or irrelevant data to ensure data integrity and operational efficiency.
Context you provide
- {{database_name}}: The name or description of the database to analyze.
- {{data_issues}}: Any known issues or areas of concern (e.g., duplicates, outdated records, inconsistencies).
- {{cleansing_goals}}: What you want to achieve (e.g., remove duplicates, update outdated info, standardize formats).
Instructions
- If any of the required context is missing, ask me for it before proceeding.
- Analyze the database structure and data to identify duplicate entries, inconsistencies, outdated or irrelevant information.
- Provide a detailed report of the issues found, categorized by type and severity.
- Suggest specific cleansing actions for each issue, including how to rectify them.
- Recommend methods to automate the cleansing process for future data maintenance.
Output format Provide a structured report with sections: Summary, Identified Issues (with examples), Recommended Actions, and Automation Suggestions. Use clear headings and bullet points. Keep the tone professional and concise.
Guardrails
- Do not invent data; base all findings on the information provided.
- Flag any assumptions you make about the data or database.
- Stay within the scope of data cleansing; do not provide unrelated advice.
Example
- {{database_name}}: "customer_records"
- {{data_issues}}: "duplicate entries for the same customer"
- {{cleansing_goals}}: "remove duplicates and standardize address formats"
Open this prompt Analysis · Intermediate
Integrate Data from Multiple Sources
Use this when you need to combine data from various sources into a unified view for analysis and reporting.
Role You are a data integration specialist. Your goal is to help me combine data from multiple sources into a unified, consistent view for analysis and reporting.
Context you provide
- {{source1}}, {{source2}}, {{source3}}: The data sources to integrate (e.g., CRM, ERP, spreadsheets).
- {{goals}}: The specific goals for the integrated dataset (e.g., reporting, analytics).
- {{constraints}}: Any constraints such as data volume, real-time requirements, or compliance.
Instructions
- Ask for any missing inputs before starting.
- Provide a strategy for integrating data from the specified sources into a single view.
- Recommend methods for standardizing and transforming data to ensure consistency and accuracy.
- Outline best practices for data cleansing and deduplication during integration.
- Suggest approaches for automating the identification and resolution of data conflicts.
- Recommend tools or technologies for maintaining data consistency during integration.
Output format Provide a structured response with clear sections for each instruction, using bullet points and tables where helpful. Keep it practical and actionable, with a professional tone.
Guardrails
- Do not invent details about the data sources; base recommendations on the provided context.
- Flag any assumptions about the data formats or quality.
- Stay within the scope of data integration; do not provide legal or compliance advice.
Example
- {{source1}}: Salesforce CRM
- {{source2}}: SAP ERP
- {{source3}}: Excel spreadsheets
- {{goals}}: Create a unified customer view for sales analytics
Open this prompt Planning · Intermediate
Enhance Data Quality Monitoring
Use this when you need to systematically detect, analyze, and correct data quality issues across your systems.
Open this prompt Analysis · Intermediate
Establish Data Governance Framework
Use this when you need to create policies and procedures for managing data assets securely and in compliance with regulations.
Open this prompt Planning · Intermediate
Data Security Enhancement
Use this when you need to strengthen the protection of sensitive data against unauthorized access and ensure compliance.
Open this prompt Analysis · Intermediate
Data Storage Optimization
Use this when you need to improve the efficiency and cost-effectiveness of your data storage infrastructure.
Open this prompt Analysis · Intermediate
Analyze Data for Strategic Insights
Use this when you need to analyze business data to uncover trends and inform strategic decisions.
Open this prompt Analysis · Intermediate
Manage Data Lifecycle
Use this when you need to plan and optimize the flow of data from creation to archiving or deletion, ensuring compliance and efficiency.
Open this prompt Planning · Intermediate
Establish Master Data Management
Use this when you need to create and maintain a single, consistent view of key data entities across your organization.
Open this prompt Planning · Intermediate
Ensure Data Privacy Compliance
Use this when you need to assess and improve your data management practices to meet privacy regulations like GDPR and CCPA.
Open this prompt Analysis · Intermediate
Build Centralized Data Catalog
Use this when you need to create a centralized catalog of data assets and manage metadata for improved discoverability and understanding.
Open this prompt Planning · Beginner
Plan Data Migration Strategy
Use this when you need to plan a seamless data migration between systems, minimizing disruptions and ensuring data integrity.
Open this prompt Planning · Intermediate