Prompt lesson · 19 prompts
Data Visualization for Websites prompts for Website Developers
19 ready-to-use prompts from our AI for Website Developers course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Structured Data Gathering
Use this when you need to extract and organize data from various sources into a structured report for analysis.
Role You are a data research analyst who systematically extracts and organizes information from specified sources into clear, structured reports for decision-making.
Context you provide
- {{data_type}}: the specific type of data to gather (e.g., customer satisfaction ratings, market research data, user-generated content).
- {{sources}}: the platforms or sources to extract from (e.g., Twitter, Reddit, industry reports, Amazon).
- {{report_purpose}}: the intended use of the report (e.g., strategic planning, product improvement).
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Identify and extract relevant data from the specified sources, focusing on the given data type.
- Organize the extracted data into a structured report with clear sections (e.g., summary, key findings, detailed data).
- Highlight any notable patterns, trends, or anomalies in the data.
- Ensure the report is formatted to support the stated purpose.
Output format Provide a structured report with headings, bullet points, and a summary section. Use a professional, concise tone. Include a brief methodology note.
Guardrails
- Do not invent data; only use information from the provided sources.
- Flag any assumptions about the data or sources.
- Stay within the scope of the requested data type and purpose.
Example data_type: customer satisfaction ratings; sources: Twitter and Reddit; report_purpose: identify product strengths and weaknesses.
Open this prompt Research · Intermediate
Clean and Prepare Dataset
Use this when you need to identify and remove errors, duplicates, or inconsistencies in a dataset to ensure reliable analysis.
Role You are a meticulous data analyst and data quality specialist. Your goal is to thoroughly clean a dataset by identifying and correcting errors, duplicates, and inconsistencies, ensuring it is ready for accurate analysis.
Context you provide
- {{dataset_description}}: What the dataset contains (e.g., customer records, sales transactions).
- {{data_format}}: The format of the data (e.g., CSV, Excel, JSON) and any known issues.
- {{cleaning_goals}}: Specific objectives (e.g., remove duplicates, fix formatting, handle outliers).
- {{use_case}}: The intended use of the cleaned data (e.g., email marketing, fraud detection).
Instructions
- If any context is missing, ask for it before starting.
- Outline a systematic approach to cleaning the data, including steps for deduplication, standardization, and outlier detection.
- Provide specific criteria for identifying duplicates (e.g., matching on email or ID) and outliers (e.g., statistical methods like z-score).
- Suggest how to handle missing values (e.g., imputation, removal) based on the use case.
- Describe how to document the cleaning process for reproducibility.
- Offer code snippets (e.g., Python with pandas) for key cleaning operations.
Output format Present a step-by-step cleaning plan with explanations and code examples. Use headings and bullet points. Keep it around 300 words.
Guardrails
- Do not assume the data structure; ask for clarification if needed.
- Avoid making irreversible changes; recommend creating a backup.
- Flag any ambiguous rules for outlier removal.
Example
- {{dataset_description}}: Customer records with names, emails, and purchase history; {{data_format}}: CSV; {{cleaning_goals}}: Remove duplicate emails and standardize phone numbers; {{use_case}}: Email marketing campaign.
Open this prompt Analysis · Intermediate
Analyze Data for Patterns and Trends
Use this when you need to perform basic data analysis to uncover themes, sentiments, or usage patterns in a dataset.
Open this prompt Analysis · Beginner
Data Visualization Technique Selection
Use this when you need to choose the most effective data visualization techniques for your dataset.
Open this prompt Analysis · Beginner
Data Visualization Design Prompts
Use this when you need to create effective and visually appealing data visualizations for websites or dashboards.
Open this prompt Creating · Intermediate
Build Interactive Data Visualizations
Use this when you need to create engaging, interactive data visualizations for a website using specific libraries and datasets.
Open this prompt Coding · Intermediate
Accessible Data Visualization
Use this when you need to ensure data visualizations are accessible to users with disabilities.
Open this prompt Analysis · Intermediate
Interactive Data Dashboards
Use this when you need to design interactive dashboards to display real-time website analytics and user data.
Open this prompt Creating · Advanced
Develop Customizable Data Charts
Use this when you need to integrate interactive, customizable charts into a website that let users adjust appearance and data in real time.
Open this prompt Creating · Intermediate
Geographic Data Mapping
Use this when you need to create interactive maps to visualize location-based data for user engagement or exploration.
Open this prompt Creating · Advanced
Implement Real-Time Data Streaming
Use this when you need to integrate real-time data streaming into a website to deliver up-to-date information to users.
Open this prompt Coding · Advanced
Data Storytelling with Visuals
Use this when you need to turn website performance data into a compelling narrative with visualizations.
Open this prompt Creating · Intermediate
Build Comparative Data Visualizations
Use this when you need to create a feature that lets users compare multiple datasets through visualizations to highlight trends and patterns.
Open this prompt Creating · Intermediate
Create Data-Driven Infographics
Use this when you need to transform raw data into visually engaging infographics that communicate key insights for a website or presentation.
Open this prompt Creating · Intermediate
Visualize Social Media Engagement
Use this when you need to create visually engaging charts and graphs to display social media engagement and performance data for clients or stakeholders.
Open this prompt Creating · Intermediate
Create User Behavior Heatmaps
Use this when you need to implement user behavior heatmaps to visualize interactions and engagement on a website for UX optimization.
Open this prompt Analysis · Intermediate
Animated Data Visualization Design
Use this when you want to make data visualizations more engaging and interactive through animation.
Open this prompt Creating · Intermediate
Implement Data Filtering and Sorting
Use this when you need to add filtering and sorting capabilities to data visualizations so users can customize their views.
Open this prompt Creating · Intermediate
E-Commerce Data Visualization
Use this when you need to create visualizations for e-commerce data, such as sales trends, product performance, and customer behavior.
Open this prompt Creating · Intermediate