Data Nerds! Super stoked to finally have this course launched!!...again (BTW, I have a FAQ👇) Quick background on this course: I first launched this last November, and unfortunately, shortly after that, a plug-in that I used for the course (i.e., Noteable) was deprecated, causing me to pause enrollment for the course while I fixed it. Additionally, this entire course was behind a paywall, and I’ll be honest, I didn’t feel right keeping video content from my subscribers. So I felt like this was a sign and instead decided to make the entire course public after I upgraded the course for the deprecated plug-in issues. So, I want to thank those who support the course by buying the course notes and certificate; without y’all, future tutorials wouldn’t be possible. ✌ FAQ === Q: How do I enable 'Advanced Data Analysis', it's not in Settings under "Beta Features"? A: 18:30 ADA is no longer included under this section and is auto included in the most advanced model. Q: Does this require a ChatGPT subscription? A: Yes, you’ll need a Plus or Enterprise subscription to unlock the full potential of ChatGPT. The free version of ChatGPT is not powerful enough for this course. Q: Do I need to know how to code to take this course? A: No prior coding or analytical experience is required! This is for data professionals who want to automate finding data insights. Q: What are the computer requirements? A: You only need a functioning laptop, desktop, or tablet with an internet connection; we’ll access everything through a web browser, from ChatGPT to the course material.

this is incredible. Thank you so much for taking the time to make this and providing it to us. This is 100% exactly what I need on the exact weekend I needed it. I promise once I get a job I'll find a way to thank you with more than a nice comment. You are AWESOME!

Thank you Luke for all the support and amazing work you do to educate us. Keep up the good work and we here to support you

A really excellent course. Luke is energetic and articulate. He optimizes the use of GPT/ADA while at the same time telling you it is not perfect

Luke, I don't usually comment on youtuve videos but I think this time is worth it. Thank you for creating this course. I am a physician deeping into data analysis and statistics for my job as a researcher. Thank you.

Thank you for sharing all this knowledge! Amazing to find this available on YT.

Loved this ... Awesome job Luke

I’m going to complete this over the weekend.

Done !!! Thanks you for your time

Thank You so much Luke for this video!

This is why I watch. Amazing useful quality content. Thanks so much Luke

Thank you so much for this. Its really helpful 😊

great course man thank you 🙌

Excelent course mate!

Incredible luke❤

Thank you very much Mr. Luke from Iraq 🇮🇶 🙏

Thanks a lot for this. Bookmarked now.

Thank you so much for the content Luke... you are amazing. 🛠🎲📈

Putting this thing on my learning wishlish. Really Helpful content❤

Luke ! My Luke ! You are making my life way easier. I am looking for a long time now for somebody to help me start the journey of data analytics and I have to say that since I came onto your channel, I left the Gray area. Thank you for all that you do ! Thank you that for making everything understandable ! Thank you !

Thanks you for your time

Have not seen it yet, but I put "like" without any doubts - 3 hours of highly deliberated and structured content!

This is pure gold

Thanks for sharing 🙏

Very helpful video. Thanks

The value here is just insane

Thank you!!!

i love you man - most valuable content on youtube

Thanks!

Brilliant!

Hi Luke, can you let me know what do you think about Google's course for data analytics?

dude this is nuts! just got thru some of this content - can't believe its free! amazing video!

Thanks Luke!!!

Bro thank you for sharing such great content. Using the screenshot of powerbi's relationship view to get gpt to generate the script felt like magic.

Would love same tutorial on BingChat pro with all Windows Office applications integration now Excel,Word etc. Love your videos and the presentation

Hey @LukeBarousse , been watching your channel for quite some time big fan! I am somewhat mid level data analyst, at my job I struggle to problem solve and how to solution when given tasks. I tend to get stuck when using excel. Any tips to help with this?

Hello Luke. Great video as always. In yr view, how would you like to rate gpt + plus response's accuracy and reliability especially for data analysis and simple ML model result?

Hi Luke thank you for this awesome tutorial. It realy makes me happy! i have a question. I have followed the instructions, but chatgpt reponds it cannot build a model. In stead is responds a method to build a random forrest model with python etc. Has something changed of am i doing something wrong? thank you for a response. Joost (The Netherlands)

Hi Luke. I am completely new in this field. I always loved doing analyses in excel. But I found my self limited. Now I am going through your course of SQL and also went through this course. I was able to set up local LLM using LM Studio (on MacBook Air M2) and get it running in VS Code via Continue extension. My question is, have you tried some locally running LLM? Also I recently found Microsoft LIDA. It would be great if we have your opinion on this tools.

Luke you are the best

Bro you are a goat i needed that

Thank you for this video. Can you please do a video on using Gemini Advanced for Data Analytics? I curious as to how it would perform compared to Chatgpt 4.

How do you get all the analysis produced as a report presentable to stakeholders?

I have the feeling that once I finish learning Python, it won't be useful anymore. This AI things grows quickly. Great curse. Really impressive! Thanks a lot, one of the best channel of KZfaq.

I have ChatGPT 4 and in settings for Beta Features, I only have the option to enable plugins and not the Advanced Data Analyst. What should I do to enable this beta features? Reference @ 18:34

Hey Luke currently there is no beta feature in settings . How can I add plugins?

Hi Luke , i am having 10 years of experience as a Quality analyst in banking,can you please help me to suggest if self-study or doing a master's is a good option

Hi, Luke - ref. Settings: You advised to make sure we allow both Pluggins and ADA under Settings. However, my ChatGPT settings only show Pluggins, and not ADA (I refer to minute 34:47 of your clip). is there a problem with the Settings? What should I do? Thank you!

Does bing do the same?

Hi thanks for the great course! After subscribing for ChatGPT Plus (20$/month), it seems the usage policy is limiting usage after about 20 messages. Any recommendation how to deal with this limitation? Thanks

just got the course and wow! totally worth it. great job with all of the resources. I thought it was just a donation thing, but was surprised by how affordable it is. excited to start!

Got my certificate! Woo hoo.

let's gooooooooo!!!!! Gracias

Seems to be some problem with the linked data file. ChatGPT hasn’t succeeded at analyzing it for me yet

Hi , i am having 10 years of experience as a Quality analyst in banking,can you please help me to suggest if self-study or doing a master's is a good option for data science

Luke - now I have Team subcription and I can work with chatGPT at work - the course is very usuful:) - thank you

Great intro course but is there a way i can get more details into Predictive and Prescriptive Data analytics. Like, go more into details. I will gladly pay for such a course.

Hey master Luke, great opportunity this again. Can I ask, when you go to the link in the vid there are three vids with you can click on, it goes to the same page where you can pay to support you. Is it 3x 25$ or just one time? Love to support to keep up the great work you do

Advanced Data analysis is not showing up as an option (either on 3.5 or 4.0).

You say that Harvard suggests an improvement with the use of ChatGPT; is this the same study you mentioned in a previous video, that included the stipulation 'if it is within the scope' of what ChatGPT/the data nerd can do? I just recall that it suggested that data nerds did worse if it was outside the scope and they used ChatGPT wrong - I'm wondering if there has been some improvement that means this isn't true any more?

I'm trying to connect to the data source (40:00) but the zip file is 60MB, so when I try to attach it to ChatGPT, the file exceeds the limit, even with Pro. It doesn't allow me to send the attachment, with the send button grayed out. Any fixes for this?

Luke, is your video useful for 3.5 version as well?

2022 is the most up to date info that chat gpt can access.

At minute 50:18, the prompt you use isnt working for me. ChatGPT says that it can't excecute due to limitations. Do you have any idea how I can fix this?

Happy place ❤❤❤❤

I watched the whole thing, it was great.

Hello Luke, I had some issues generating the machine learning model. I tried and tried but chatgpt said " Error analyzing It seems I've encountered limitations that prevent executing machine learning model training, specifically with the Random Forest Regressor, directly in this environment. This limitation is related to the operational constraints of the platform rather than an issue with the code itself. Although I'm designed to assist with generating and explaining code, including machine learning models, the execution of certain tasks, especially those requiring extensive computational resources or specific library functions like scikit-learn, might exceed the capabilities provided here. For running complex machine learning models like the Random Forest Regressor, I recommend using a local Python environment or a dedicated data science platform. These environments offer the computational resources and library support needed for such tasks, allowing you to train, test, and deploy machine learning models effectively." Thank you for your help.

No audio?

I am planning to buy your course ChatGPT for Data Analytics. Is it okay to become a data analyst without knowing coding? Can I get a good job and salary? Can the company accept me to do data analysis with the chat gpt4? Please let me know.

🎯 Key Takeaways for quick navigation: 00:00 💡 *Introduction to ChatGPT for Data Analytics* - The video introduces ChatGPT as a tool for data analytics, highlighting its time-saving benefits and versatile applications in tasks ranging from spreadsheet analysis to advanced machine learning. 00:27 📘 *Course Overview* - The tutorial is structured into six chapters, covering ChatGPT setup, basic and advanced prompting techniques, plugins, data collection methods, and how to use ChatGPT for data analytics effectively. 01:09 🛠️ *ChatGPT Features and Plugins* - Focus on Advanced Data analysis, gpts (customized ChatGPT models), and plugins for browsing the internet and image generation. 01:22 🌐 *Data Collection Techniques* - Emphasizes the importance of data collection, including finding public datasets and web scraping methods. 02:03 📊 *Efficiency and Quality Improvement with ChatGPT* - A Harvard study showed ChatGPT users complete tasks 25% faster with a 40% increase in quality, illustrating the efficiency and effectiveness of using ChatGPT in data analytics. 02:31 💼 *ChatGPT Plus for Advanced Capabilities* - Discusses the necessity of ChatGPT Plus for access to advanced features like data analysis and internet browsing, especially for individual users. 03:25 🏢 *ChatGPT for Businesses* - Explains options for businesses, such as Enterprise and Team editions of ChatGPT, which are suitable for handling secure and confidential data. 05:01 🔑 *Setting Up ChatGPT Plus* - Guides through the process of signing up and upgrading to ChatGPT Plus, ensuring access to the latest model and features necessary for the course. 06:53 🤖 *Exploring ChatGPT Interface* - Provides an overview of ChatGPT's layout, including the sidebar, chat history, settings, and accessing custom-built models (gpts) for specific functions. 07:07 🎛️ *Layout Changes in ChatGPT* - Addresses recent layout changes in ChatGPT and ensures consistency in the course content with the current interface. 09:00 🌟 *Utilizing ChatGPT's Capabilities* - Demonstrates basic prompting techniques and how to maximize ChatGPT's capabilities for efficient and accurate responses. 11:18 💬 *Developing Personal Context Statements* - Encourages creating personal context statements to guide ChatGPT in providing tailored and relevant responses. 12:12 🔄 *Updating ChatGPT's Knowledge* - Discusses ChatGPT's knowledge level and the importance of using the internet browsing feature for up-to-date information. 14:03 🤹‍♂️ *Mastering Prompting Techniques* - Focuses on improving prompting techniques with context and task considerations to get precise and desired results from ChatGPT. 16:33 ⚙️ *Setting Up Custom Instructions* - Demonstrates how to set up custom instructions in ChatGPT for personalized and efficient use, aligning with individual preferences and requirements. 17:45 🔧 *Customizing ChatGPT Responses* - ChatGPT's custom instructions can be tailored for specific formats and tones in responses, including the use of emojis and concise answers, ensuring each new chat session starts with these preferences loaded. 18:26 🌓 *Setting Preferences in ChatGPT* - Users can adjust settings like themes (dark or light mode), clear chat history, and enable beta features like plugins and Advanced Data analysis for enhanced functionality. 19:07 🔒 *Data Security and Privacy Settings* - ChatGPT Plus may not be secure for confidential or proprietary data, suggesting the use of ChatGPT Enterprise for handling sensitive information, which is SOC 2 compliant. 20:43 👁️ *ChatGPT's Image Analysis Capability* - ChatGPT can now analyze images, offering a unique application in data analytics by interpreting graphs, visualizations, and data models from uploaded images. 26:46 📊 *Introduction to Advanced Data Analysis Plugin* - The Advanced Data Analysis plugin in ChatGPT is a powerful tool for exploring data sets, performing statistics, exploratory data analysis, and machine learning predictions. 29:03 ⏳ *Handling Timeouts in Data Analysis Sessions* - ChatGPT's environment may time out during advanced data analysis sessions, requiring users to re-upload files for continued analysis without losing previous work. 31:08 🔄 *Transitioning Between ChatGPT Models* - Users should ensure they use the ChatGPT model with Advanced Data Analysis enabled for complex data analytics tasks, as base models without this feature may produce inaccurate results. 36:02 💻 *Advanced Data Analysis Execution in ChatGPT* - ChatGPT's Advanced Data Analysis feature executes Python code directly within the chat interface, allowing users to see and verify the accuracy of calculations in real-time. 36:57 📈 *Versatility of Advanced Data Analysis* - The Advanced Data Analysis feature can handle a wide range of tasks including data processing, statistical analysis, predictive modeling, and custom queries, making it a robust tool for data analysts. 38:03 📊 *File Type Flexibility in Data Analysis* - ChatGPT accepts a variety of file types for data analysis, including CSV, Excel, Json, and more, demonstrating its flexibility in handling different data formats. 41:16 📊 *Descriptive and Exploratory Data Analysis* - ChatGPT can perform descriptive statistics and exploratory data analysis (EDA) on datasets, providing insights through visualizations like histograms and bar charts. 46:06 🧹 *Importance of Data Cleanup in Analysis* - Effective data analysis often requires cleaning up datasets, such as removing unnecessary spaces or renaming columns, to ensure accurate categorization and analysis. 48:08 📉 *Complex Data Visualization Techniques* - Advanced visualizations, such as analyzing salary data in relation to job platforms, job titles, and locations, can provide deeper insights and identify trends within datasets. 52:29 🤖 *Machine Learning Predictions with ChatGPT* - ChatGPT can build machine learning models, like Random Forest, to predict data such as yearly salaries, using inputs like job titles, platforms, and locations. 55:36 📉 *Understanding Model Error Metrics* - The Root Mean Square Error (RMSE) metric is used to evaluate the model's accuracy, indicating an average deviation of about $22,000 from actual yearly salaries, which is crucial for gauging the model's performance. 56:30 💹 *Testing the Predictive Model* - Testing the machine learning model with real-world scenarios, like predicting salaries for specific job titles and platforms, demonstrates its practical application and allows comparison with external salary data sources like Glassdoor. 58:06 📊 *Model Performance Variability* - The predictive accuracy varies across different roles, with senior roles showing more accurate predictions. This variability highlights the importance of having a well-defined and diverse dataset for training. 59:42 🌐 *Internet Access Limitation* - Advanced Data Analysis in ChatGPT cannot directly connect to online data sources like databases or APIs, which limits its ability to directly analyze data from the internet. 01:00:24 📊 *File Size Limitation* 01:01:58 🔒 *Security Concerns* 01:15:10 📈 *Visualization Tasks* 01:17:03 📝 *Visualization Task Recap* 01:19:20 📊 *Histogram and Box Plot Analysis* 01:27:16 📈 *Visualization Best Practices* 01:33:38 🖼️ *Clutter-Free Visuals* 01:34:34 🎨 *Focused Attention* 01:35:42 📊 *Effective Communication* 01:38:02 📈 *Visualization Improvement Task* 01:38:42 🔢 *Basic Statistics: Numerical Data* 01:46:13 🔠 *Basic Statistics: Categorical Data* 01:50:34 📊 *Four Types of Data Analytics* 01:52:22 🔍 *Diagnostic Analytics* 01:53:16 🔮 *Predictive Analytics* 01:54:07 📊 *Prescriptive Analytics* 01:56:26 📈 *Descriptive Analytics* 01:59:15 🧐 *Deep Dive into Diagnostic Analytics* 02:06:09 🤖 *Building Predictive Models* 02:09:26 🧠 *Advanced Prescriptive Analytics* 02:11:44 📊 *Recommender Algorithm for Data Analysts* 02:13:10 🧠 *Advanced ChatGPT Topics* 02:14:03 🤖 *Understanding ChatGPT's Token Limit* 02:15:28 🚫 *Hallucinations and Bias in ChatGPT* 02:16:24 🌡️ *Exploring ChatGPT's Temperature Setting* 02:18:27 📚 *Case Study on ChatGPT's Hallucinations* 02:30:03 📝 *Format and Tone in Custom Instructions* 02:33:21 📊 *Custom Instructions for Optimized Responses* 02:39:25 🤖 *Building Custom GPTs for Specific Tasks* 02:47:00 🛠️ *Importance of Refining Custom GPTs* 02:47:13 🛠️ *Creating a Personalized GPT* 02:47:42 🔌 *Intro to ChatGPT Plugins* 02:58:44 🌐 *Browsing the Internet with ChatGPT* 03:03:44 📊 *Using Wolfram Plugin for Analytics* 03:04:39 🧮 *Wolfram Plugin for Data Analysis* 03:08:17 🖼️ *DALL-E 3 Plugin for Image Generation* 03:13:33 📊 *Introduction to Data Collection Methods* 03:17:10 🌐 *Resources for Finding Public Data Sets* 03:21:09 🕸️ *Intro to Web Scraping with ChatGPT* 03:22:56 ⚖️ *Legal Considerations in Web Scraping* 03:24:33 📂 *Legally Collecting Data from Websites* 03:29:22 🌐 *Using ChatGPT for Data Extraction* 03:30:27 🛠️ *Advanced Concepts in Web Scraping* 03:32:19 🤖 *Checking Website Legality for Scraping* Made with HARPA AI

Hi Luke, I have been experiencing frequent and prolonged errors with ChatGPT’s inability to read Excel, CSV and other file types. Even very small datasets seem to be a problem. Do you know whether this problem also persists in the USA, I'm living in the Netherlands Has anyone else experienced this issue? I think this is a major shortcoming of a service for which you also have to pay monthly

Hi pls i can become a data analyst and get jobs knowing how to only use chatgpt to do data analysis

my chat gpt cant analyse same csv file says error analysing tried different ways still can't do it anyone having same issue and resolved? using gpt4

Hi, ADA plugin is not available in chatgpt plus now. I can't get the similar responses as you have in this course. Any update?

this is GPT 4 the paid version ?

Good video! Couldn't find the plug in thou...

18:34. Why doesn't my "beta features" list include "advanced data analysis"? I only see "plugins". Is it possibly because I don't have extensive use of ChatGPT yet?

And one more question there is limit of 50 messages / 3 hour so that's very low limit, so how can you continue working with this even I have the pro version but still it's not worth enough because you cannot use it continuously because you there is a message cap limit.

What that dinging sound? Sounds familiar....🤐

Really need to learn how to read lips

That smiley excited emoji really on your certificate bro?

1:28:04

Representistic is not the correct word, it is representative. That said, I prefer the former.

I'm not watching a 3.5-hour video but I did figure something out on my own today. I was working with Google Sheets and decided to paste a small spreadsheet into ChatGPT to see If it could reverse-engineer the code needed for each cell. It worked but took a few prompts to get it to understand what was needed.

Hello

4th quartile? 🤔😉

Thanks so much for making this; I learned a lot! At this point: kzfaq.info/get/bejne/q86pgNSTv6-aooE.html you say it has no knowledge *prior* to April 2023. It has no knowledge *after* that point, right? Or is it updating continuously but only from that point onward?

Hiha, yea that’s it.

PLEASE PLEASE PLEASE SELL MERCH! I want a T shirt that says Data Nerds!!

I paid for your full course, what is the difference from this?

Goldmine

buddy thank you so much for teaching us so much on KZfaq. But... am I the only one having ONLY problem problem problem?! My ChatGPT (4, of course) only answers: i have a problem, i cannot perform this, i cannot perform that, I apologize, i have a technical problem, the problem is permanent, I am sorry but... That's it. Especially with the dataset you provided (which is way too big even to be opened on my excel...). If i use a smaller dataset "sometimes" i can see some elaboration and ChatGPT at least tryies to help as much as it can (few). Please consider i am copying and pasting your exact prompt. No way to work here. Just 20% of times, the rest is "i have a technical problem, i am sorry...." and "error analyzing". Frustrating is not enough. Is ChatGPT still working or not?!

💎 Cognizant Technology Solutions (CTSH) 💎

diddy going to prison is like 2024 booty warrior's revenge

ok i realized after clicked this video , he is not mark zuckerberg

great course, thanks, shame I joined chat gpt to encounter this ridiculous 40 messages/3hr limit part way through your course, not your fault but this limitation is a complete turn off. Of note Luke is the announcement of the discontinuation of plugins by OpenAI for your vids soon ;)

Does that mean there's no need for your course anymore or what?

The course is too long. Could you please tell me the plugins you use in the ChatGPT plus and list all the prompts?

could this be considered as cheating by your employer???

Your videos are great. But the product you are selling is not. The system is not reliable, it constrains for how long you have to use it and it is very temperamental. Instead of us paying them to test it, we should be getting paid for it.