🔮 Let’s start…

Open your ChatGPT and paste your data, or upload a file (.xlsx, .csv, etc.)

Example Task: Analysing Company’s Data

For this tutorial, I uploaded the table containing the data below from a fictitious company:

1) Analysing Sales Trends

We can ask ChatGPT to “Analyse the sales trend over the year” to get insightful information, such as growth periods, patterns, and possible correlations.

2) Calculating Cost per New Customer (or CAC)

How much does it cost me to acquire new customers each month? The “Calculate cost per new customer” prompt will return the following:

It can also create charts. For example, what if we ask for a Sales vs Ad Spend chart? Voilà…

3) Predictive Analysis

Maybe it would be useful to predict the sales and revenue for the next quarter based on historical data. We can simply ask and ChatGPT will use a linear regression model to show me a forecast.

Additionally, you can ask for suggestions, such as “Suggest marketing strategies to boost sales during low-performing months,” which can help with planning.

Remember this is a prediction and not something you can follow blindly!

4) Sentiment Analysis

Prompting it to “Perform a detailed sentiment analysis of feedback comments to identify common themes and areas for improvement” is a great way to summarise tons of messy feedback that might help with the strategy and continuous improvement.

That is it! Imagine doing all that analysis with a larger dataset, how helpful could it be?

There are many other ways this could be analysed and visualised using ChatGPT. It is also handy for cleaning and structuring messy data.

Try out ChatGPT for your data analysis tasks and let us know what you think.