ChatGPT for Data Analysts | Best Use Cases + Analyzing a Dataset

ChatGPT has a lot of use cases for Data Analysts! In this video we walk through my favorite things to use ChatGPT and we also take a look at how it can help us analyze data.

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

0:00 Intro
1:30 1. Explaining Code
3:33 2. Generate Code
8:15 3. Commenting Code
9:25 4. Create Data Dictionaries
11:13 5. Optimize Code
14:04 Analyzing Dataset
29:55 Outro

[harrietdrums]

I started watching Alex in Jan 22, got my first data job in June, and just got offered a role as a data analyst this month. Increased my salary 60% in less than a year. Thank you Alex!

[elmago]

my wife laughs at me when I tell Alexa Please and Thanks. I'm just saying that I'll have a better time of it when the AI-Robot overlords take over cause they'll remember my kindness.

[Ryan_hey]

Junior and even mid-level engineers will really benefit from simply being able to paste code and ask why the code was written in a particular way. I've given it some pretty complex SQL code and it explains it correctly.

[JDMathematicsAndDataScience]

At time 2:18 "I don't really believe in paying." I can understand that. But, you must believe in being paid given the join button. I believe in both. At any rate, thanks for the video. Great quality.

[xenoaion]

FYI, if the response from ChatGPT is cut out, its likely because the token for the conversation is run out. You can just prompt with "continue" or "go on" to continue writing previous response.

[paulwatts]

I spent 35 yrs working in big data analytics at one of the credit bureaus - started out on mini computers and moved to the very first pc's so I have literally seen it all. I spent the last 3 months playing with GTP4 on a couple of private big data projects and in conjunction with an ETL tool (like alteryx) I can do in half a day what it took a small team of phd stats 3 months just 15 yrs ago. GPT is extremely impressive in generating code but equally impressive in suggesting methods. Without doubt GPT and it like are going to radically change data analysis and probably allow the more creative folks to win out over the less creative. It will mean fewer programmers and data engineers for sure. If I were 22 again I would make sure I had the widest possible understanding of business processes / problems and a wide range of analytical methods at a theoretical level. AI will plug the gap.

[emgp]

So ready…this is going to take data analysis and visualization to a whole new level!

[dannygunn]

This is amazing stuff, Alex. I’ve used ChatGPT to translate calculated fields in Google Data Studio to Tableau and even to Power BI. It’s truly fascinating how it works! I think it’s going to be a total game changer. Personally, I think data engineers are at more risk of job loss from ChatGPT integration into our data analytics tools than data analysts. Can’t wait to see your next video on this though!

[JamieHolloway]

I believe ChatGPT's operating memory space, today, is 4097 (input+output) tokens, which approximates 3000 words. This is perhaps why you are seeing truncated outputs, or limited memory of historical input.

[hammadalamsiddique]

Hi Alex, I am binge watching your Bootcamp since the day it's launched. Thank you so much for your efforts. Wish me luck.

[fdu]

Alex, I've gotta say... I've been thinking about switching careers for a while now and Data Analytics is right up my alley. I've watched some of your videos and your content has been nothing short of amazing and encouraging. I'm definitely switching this year, and 2023 will be my last year as a teacher! I'll let you know how it goes

[dawid_dahl]

(By the way, you can ask “Did you time out?” and it will retry the last answer, often completing it instead of stalling like it did previously.)

[sujhandas]

always so inspiring Alex! I've used the explaining, generating, commenting approach myself and funny story, it actually gave me the wrong code once, and when I entered "can you correct the code because your code is giving me the wrong output for n=90" it corrected itself and gave me an optimized accurate code, so we def need to be careful on not 'what all we can do through chatgpt' but also 'how' to do it :)

[toyflish]

You were so polite and valued its work. I wonder how people growing up now, getting used to ai doing hard work for them even if they are absolutely rude, will affect our society.

[conquerlife]

Greetings all the way from Uganda Kampala, this channel is so inspiring. Thanks Alex for being a such a good person, you're really changing our lives.

[PabloCarballo]

Just a tip when chat gpt stops like that you can just tell it to “continue your response from where you left, you stopped mid way “ and he will continue the previous response, pretty cool

[mischapeters]

Like the intitial relase of Power BI in 2014, this is going to be a game changer for sure!

[saskersoontiens]

Its not the server overloading why its erroring out. It has a max of 4000 tokens (± 3000 words) that's why it stops. Just insert your data before and ask it to continue from where it stopped and it'll finish your code for you

[kelthekonqrr]

I’ve started learning the basics of Python and SQL

[sheauchi]

Hope you can share on how will this impact on data analyst industry? Will it replace the job or enhance the industry?