On August 28, OpenAI introduced improvements to version 4 of GPT (chatGPT Plus) incorporating advanced data analysis. We tested it and can say that we were impressed. Not only does it allow anyone to perform complex data analysis simply by asking questions in natural language, but it also has the ability to generate complete reports in Word format. Do you want to know the correlation between sales and advertising campaigns? Do you need a graph of the trends of the last week? Would you like a well-structured report that you can present at the next meeting? GPT-4 has got you covered.

Basic example to show you how it works

1. Import your data: Upload your CSV or Excel file.

Note: Click here to download the dataset that was utilized for this analysis.

2. Ask your question or give an instruction.

“Conduct and visualize a detailed graphical analysis of sales profitability in key cities.”

“What is the probability that a customer will repeat a purchase in the next three months?”

3. Make a report in Word

“Make a report in word with all the analysis”

Note: Click here to download the report.

Summary of Capabilities

Statistical Analysis in Simple Sentences

Imagine having a sales data set and wanting to know which product is the best seller. You just have to ask: “What is the best-selling product?” and GPT-4 will give you the answer, even with a graph if necessary.

Real-time Results

If you’re in a meeting and need updated data, you can get it almost instantly. Ask: “How have sales fluctuated in the last 24 hours?” and get a detailed report in seconds.

On-demand Visualizations

You need a bar graph showing performance from the last quarter. Ask: “Show me a bar graph of last quarter’s performance” and you’ll have it on your screen.

Word Reports

One of the most useful features is GPT-4’s ability to generate reports in Word format. Just ask: “Generate a report on last quarter’s sales” and you’ll have a well-structured document ready to present.

Conclusion

The “Advance Data Analysis” functionality of GPT-4 eliminates many of the barriers that previously made data analysis difficult. Now, with a few questions in natural language, you can have access to valuable insights, visualizations, and even complete reports in Word format. It’s a tool that can change the way we interact with data, making it more accessible to everyone.

Final note: The “Advance Data Analysis” version is available in ChatGPT Plus and is activated in the “Settings & Beta” -> “Beta features” option.