Exploratory Data Analysis with GPT-4

 

Environment:  ChatGPT Plus, GPT-4 with Advanced Data Analysis

 

Data:  Superstore dataset.

 

Objective:  Run Exploratory Data Analysis with GPT-4.

 

In GPT-4, you can enter custom instructions so that the answers provided will be tailored to your role.  Click on your account name and select ‘Custom instructions’.  Enter instructions about your role/profession, responsibilities, and expertise. 

After uploading the Superstore dataset and prompting GPT-4 to analyze the data, the recommended steps include Data Cleaning, Exploratory Data Analysis (EDA), Advanced Analysis, Data Visualization, and Insight Generation.  Notice that these steps were specific and relevant to the role of data analyst that was entered in custom instructions above.

Stage 2:  Recommendations for Exploratory Data Analysis:

After prompting to proceed with time-based analysis, GPT-4 created this Monthly Sales Trends graph:

Stage 3:  Plan for Advanced Analysis

After prompting to proceed with forecasting, GPT-4 delivered this Sales Forecast graph:

This Customer Lifetime Value has some interesting insights.  The equivalent of this would be a bar chart that shows customers with highest sales in Tableau.

Stage 4:  Data Visualization

The KPI dashboard is rudimentary.  It's better to give specific instruction to GPT-4 to design a dashboard according to your need.

Stage 5:  Insights

Verdict:  When GPT-4 knows your role as data analyst, it offers a deeper Exploratory Data Analysis with many insights.  Your job is to select the relevant graphs and insights that you need and tailor your analysis in the direction you want.  GPT-4 can be your awesome assistant.