Code Interpreter for Data Analysis - ChatGPT (July 2023 update)

ALL PROMPTS IN DESCRIPTION.
Generative AI is everywhere, but what can it do for data analysts?
In this video, I try to showcase how data analysts can take advantage of the code interpreter.
=================================
OpenAI:
🔗chat.openai.com/
Dataset:
🔗onyxdata.ck.page/1e8beb9b02
🔗onyxdata.co.uk/data-dna-datas...
=================================
Come find me on Linkedin: / injae-park
Thanks for taking the time to watch this video.
#powerbi #copilot #microsoft
=================================
PROMPTS:
----------------------
Load this data and analyze it, check for inconsistencies
This data has 2 sheets, one which has a data dictionary, and one which has the data
----------------------
Take this dataset, and normalize the data to be used in a power bi report. Make sure to follow best practices such as star schema.
----------------------
You are a power bi report developer, who is creating a dashboard with this hotel data. Your end user are regional level managers, and c-suite members. As such, you need a dashboard that shows overall statistics and trends, but also regional data.
Try to come up with KPIs that fit this dashboard, while including their formulas
----------------------
make 5-6 visuals as well as these KPIs to be used in a dashboard
----------------------
Create all the KPIs and visuals in a layout
----------------------
Create all the KPIs and visuals in a layout for a dashboard, keeping in mind gestalt principles, and general sizes of the objects.
Use text to show spatial area, using dashes and lines
----------------------

[@ahmedshalaby9343]

Thanks from Egypt

[@nehashahpatel1741]

million thanks. .incredible information

[@shahzadkheros]

Great demo

[@ragragrec1]

Simple and clean demo thanks!

[@PowerBIPark]

Glad it was helpful!

[@fernandamello837]

😮 my goodness this is incredible…thanks for sharing

[@PowerBIPark]

Glad you enjoyed it! I wanted to do a more in depth guide, since I've been trying to adapt code interpreter for power bi, so this is just the start 😂

[@hienlongly6017]

great

[@eduardoactd]

No more PLUS subs. 😢 but when I received the email with more subs available, I will return here, great vid!!!

[@timianalytics7150]

Really, this is very insightful... Great Job!

[@PowerBIPark]

Thank you!

[@killualover225]

I’m a plus user. But I don’t have code interpreter even though i followed all instructions

[@Gethin1978]

Same here....

[@WirelessGus]

You Offer Consulting Services?

[@PowerBIPark]

Depends on the length of engagement, but I'm open to it depending on what your needs are.

[@SABEDIT2914]

Great explanation but very expensive chatgpt..i can't afford..but I want too learn