You do not need to be a data scientist to work with data. If you can ask the right questions, ChatGPT can help you clean, analyze, and visualize data faster than clicking through spreadsheet menus.
1. Clean Messy Data
"I have a CSV file with 1000 rows of customer data. Here are 5 sample rows: [paste]. The issues I see: inconsistent date formats, missing email addresses, and duplicate names. Write a Python script to clean this data."
2. Analyze Trends
"Here is my sales data for the last 6 months: [paste numbers]. Identify trends, seasonal patterns, and anomalies. Suggest what might be causing the dips."
3. Create Charts
"Generate Python code using matplotlib to create a bar chart comparing monthly sales across 3 product categories. Use professional colors and labels."
4. Explain Statistical Concepts
"Explain p-values and statistical significance in simple terms. Use an example from A/B testing. When should I trust a result?"
5. Write SQL Queries
"I have a database with tables: customers (id, name, email, signup_date), orders (id, customer_id, amount, date), products (id, name, category). Write a SQL query to find the top 10 customers by total spend in the last 30 days."
6. Interpret Results
"I ran an A/B test on my landing page. Version A had 500 visitors, 25 conversions (5%). Version B had 480 visitors, 33 conversions (6.9%). Is this difference statistically significant? What would you recommend?"
7. Build Dashboards
"Design a simple dashboard for tracking my SaaS business metrics. Include MRR, churn rate, customer count, and average revenue per customer. Suggest the 3 most important charts to display."
The 500+ ChatGPT Prompts Pack includes prompts for data analysis, SQL, Python, and visualization — perfect for anyone who works with data but is not a full-time analyst.
Top comments (0)