Наталя Хандусенко AI Eng 15 January 2025, 15:15

TOP 20 ChatGPT prompts to help you work with data, from Jooble's Head of Analytics

Oksana Nosenko, the head of the analytics team at Ukrainian product company Jooble, compiled a list of 20 queries for data analytics in ChatGPT.

1. Data analysis

Prompt 1: Analyze this dataset and find the main trends (with example data in CSV format).

"Of course, you have to be careful not to transfer too many sensitivities of data and downloading terabytes of data won't work either. But it's cool to download data for AB tests and the AI can additionally highlight something that you didn't notice," Nosenko added.

Prompt 2: What major trends can I identify for [industry/field]? Or find me some benchmarks!

Prompt 3: There is a dataset, I see a drop in [metric], look for interdependencies that could have caused this drop.

2. Python

Prompt 4: Write a Python script to process and visualize this dataset.

Prompt 5: Write code to calculate the statistical significance of an AB test in email marketing given the following dataset — [dataset description].

Prompt 6: How to connect to a SQL database and extract data via Python?

Prompt 7: There is a file, I need to make a revenue forecast, taking into account the annual seasonality in the dynamics. Write code that makes a forecast for the next 30 days after those in the file. Save the result in csv.

3. Data visualization

Prompt 8: What graphs are best suited for analyzing this data set?

Prompt 9: How to calculate the cumulative amount in Tableau without taking into account the filter?

Prompt 10: I have a dataset [dataset description]. What visualizations would you recommend for analyzing this data?

4. Explaining complex concepts

Prompt 11: Explain what PCA is and how to apply it in data analysis.

Prompt 12: What is a p-value and how to interpret it correctly?

Prompt 13: How do I start integrating with Amplitude for my site?

Prompt 14: What is linear regression and what are its main advantages and disadvantages?

Prompt 15: What key metrics would you recommend for AB testing this application?

5. Tools and training

Prompt 16: What is the difference between Tableau Public and Tableau Desktop? How much will it cost me in year two?

Prompt 17: Optimize this SQL query for me. It's taking a very long time to execute.

Prompt 18: Write instructions for connecting data in Google Sheets to BigQuery.

Prompt 19: What APIs are available for loading open data? How do I generate data for transmission based on this documentation?

Prompt 20: Explain how to use dbt to build data models.

How to improve your LinkedIn with AI? 6 profile optimization prompts from a Ukrainian career coach

On the topic

How to improve your LinkedIn with AI? 6 profile optimization prompts from a Ukrainian career coach

How to write effective prompts for Midjourney: 9 recommendations from a Ukrainian web designer

15 Effective ChatGPT Prompts That Will Help You Save 15 Hours Every Week