I Quit Coding - How I use ChatGPT instead as Data Analyst

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I'll be sharing my experience using ChatGPT as a Data Analyst to make my work easier, from consolidating files and cleaning up data to diving deep into analysis. I'll show you how to put together Excel summary reports and charts using Python and PowerQuery, create eye-catching interactive HTML charts, whip up quick Streamlit dashboards, and generate SQL queries effortlessly. Come along as I share real-life examples and handy tips to help you get the most out of ChatGPT in your own data analysis journey.

🌍 𝗟𝗜𝗡𝗞𝗦:

𝗠𝘆 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝗣𝗿𝗼𝗺𝗽𝘁𝘀
Links to the ChatGPT conversation history ⤵

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 – Intro
0:37 - A Quick Note Before We Begin
1:02 - Generating an Excel Report with ChatGPT
6:37 - Crafting an Interactive Plot with ChatGPT
7:11 - Building a Dashboard using ChatGPT
8:01 - Refactoring and Cleaning Up the Code
9:15 - PowerQuery Alternative
9:58 - SQL Query Assistance with ChatGPT
11:01 - Essential Tips for Using ChatGPT
12:06 - Introducing the ChatGPT Excel Add-In
12:30 – Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

*Hey guys! I'm curious about your thoughts on the rapid development of AI. Are you already using it in your day-to-day workflows, or do you have concerns about its impact on our industry? Let's discuss in the comments below!*

ChatGPT Excel add-in ⤵

Source code (generated by ChatGPT) ⤵

Links to the ChatGPT conversation history ⤵

[Somebodyoncetoldme]

Thank you. Better, fast, and non bloated explanation like I see in many paid courses. Good job!

[michaelharper]

I am just starting to explore how I can use ChatGPT in my work as a database specialist. I learned SO much from this video. It was also very easy to watch and no time wasted. Thank you.

[MyCodingDiary]

Your explanations are so concise and easy to follow😀. Thank you for making this video!

[xilllllix]

great vid! this shows how powerful chatgpt can really be in the right hands...

[torque]

Great video as always! Please keep the great content coming.

[bc]

Fantastic video! I am the only one in my office aware of ChatGPT/AI at all, and plan to be the robots' best friend when they obsolesce the other jobs 😅... I use ChatGPT/AI for myself frequently, but little for work so far. I've snuck it into a couple little test cases and have some long-term ideas, but will have to train it on custom data before I can really use it day-to-day.

[franciscozapata]

Hi, the company I work for, doesn't allow us to use chat GPT even though I work with excel every single day.

[rajeevgangal]

Does the Plus subscription make any difference? If yes what? Initially the free version used to generate complete python cose however complex. Nowadays it often stops midway and repeat regenerate and task submission are needed to get complete code.

[pleabargain]

Thanks for posting.

You have a subscription which gives you larger number of tokens, correct?

[jhari]

Sorry I cant find it on the discord or website but what Python IDE are you using? I'm just starting so copying mostly what others are doing.

[brilliancetventertainment]

hello Coding Is you have a video on using python to search a excel workbook with several sheets in it for a specific search term in cell 1 of each sheet and once found copy the entire column and move it to a different column?....eg. say the cell 1 text is "PORTS" and it is in all excel workbooks that has several sheets within it, once the string in cell 1 is found and not already in column B then we want to copy that entire column and paste it in column B and then remove all blank cells from the column. Also, just to mention that cell 1 of all the workbooks are merged cells. ChatGPT gave code that didnt work at all, I even created a macro and provided the VBA to it to convert to python which the code decriptions seems to suggest the right thing but it just does work. I think this one if not done already makes for a great video topic

[bwilliams]

This is a great video. Shows how non coders can leverage python and LLMs to automate safely with limited experience. Thanks!

[hamidreza]

Bro your videos should be illegal 😂😂❤❤ thank you for helping big time

[steeful]

Question? Would my data now become part of ChatGPT? So if someone knew I was using it could someone else ask questions about MY data?

[ESPjump]

Actually, I can make it much faster and personalized with coding. ChatGPT is ok to ask doubts, as a Stackoverflow more eficient. But it didn't help me so much with the analysis.

[DonaldJevgenjevichPanasonic]

Does it makes any sense anymore spending serious amount of time studying for becoming a data analyst, considering the rise of AI, and what it can be in the near future?

[leandrov]

So I shouldn't go deep on Python, if I want to become a data analyst?

[swiatlowiekuiste]

I find risky making available to chat gpt real data. I'd recommend using made up templates instead

[VayunEkbote]

Hey great video! What are your thoughts on the ChatGPT code interpreter plugin? Will it put an end to data analyst jobs? I read another comment asking a similar question to which you replied that humans will take the final decision and guide the AI. But will human intervention really be necessary after a certain point? And if yes, then is a highly qualified data analyst required for that purpose, as even a beginner can do the job with AI.