As an unknown data analyst, my work is inseparable from Chat GPT. Let me take you to play with it.
First we generate the transaction data of an e-commerce platform. Of course, you can also specify some data fields. There is no problem with this. You can also copy the data to Chat GPT and let it organize it into a table for you. Either way, the effect is As follows (note the issue of data leakage).
The second step is that many people are confused after seeing the data and don’t know where to start. Let’s start with the purpose of the analysis. For example, we want to If you are running an event and want to find matching users for marketing, then you just tell Chat GPT.
So we have a preliminary idea, and then let it help us interpret the data based on this idea.
Now that we have the basic statistical information of the data, we can continue the in-depth analysis and see that it gives sales statistics, transaction volume Ratios, merchant sales, and consumption preferences of different consumers
also gave some suggestions based on the data results:
Through continuous questioning and training, I believe your thinking will become clearer
Then we let Chat GPT help us make an indicator system to facilitate daily work Operation supervision, the results are as follows:
You can also use excel’s VBA, SQL, python, etc. to help you directly run the codes corresponding to the above indicators and run them automatically, here I won’t go into details, there are too many
Some people will say that a simple indicator system may not satisfy you. You can also use it to model, such as the RFM model commonly used in retail. We ask it to give a model and SQL prior way
##
The above is the detailed content of How scary is it to do data analysis with ChatGPT?. For more information, please follow other related articles on the PHP Chinese website!