Environment: ChatGPT Plus, GPT-4.
Data: Article counts dataset.
Objective: Transform data to create different tiers with rank percentile.
In my post on 9/22/2023, I wrote the steps how to transform data to create different tiers using RANK_PERCENTILE function in Tableau Prep. Let’s see if GPT-4 can do the same data transformation.
1) Upload Data: Upload the article counts dataset.
2) Count Articles Based on Views: Count number of articles grouped by number of views.
3) Rank Percentile: Rank percentile based on average views.
4) Group Percentile Rank into Tiers:
5) Export Table to Excel File: export table to Excel file for visualization in Tableau.
Verdict: GPT-4 can definitely transform data if it were provided with the correct prompts. The new skill for data analytics professionals is to learn how to write proper prompts. GTP-4 can be your powerful analytical assistant as it can analyze, visualize, and transform data.
No comments:
Post a Comment