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.

@R0k47

4 ай бұрын

This is amazing. Thank you so much. Please can you start a Patreon or something so we can support you on a regular basis. I have also purchased your course. 😄

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

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.

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

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.

Thank You so much Luke for this video!

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

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

I haven't even gotten very far yet but I'm blown away by the amount of your contribution to helping us out, thank you!

Thanks a lot for this. Bookmarked now.

Done !!! Thanks you for your time

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

Thank you so much for this. Its really helpful 😊

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 !

@LukeBarousse

4 ай бұрын

Glad to hear it!

Excelent course mate!

great course man thank you 🙌

Very helpful video. Thanks

Incredible luke❤

🎯 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

@dailymahbub

3 ай бұрын

Thank you

Completed this course and it really inspired me to delve deeper into ChatGPT and data analysis. The course is really comprehensive, explains the topics well and has active examples which you can follow along with. I managed to get lost a couple of times, but learnt heaps finding my way back - really builds confidence playing with a experimental dataset! One thing that confused me a little bit is that the dataset Luke uses for the course is a little older than the one that downloads, so the results are a little different.

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

@LukeBarousse

3 ай бұрын

Glad you enjoy it!

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

@LukeBarousse

4 ай бұрын

No probs!

i love you man - most valuable content on youtube

@LukeBarousse

4 ай бұрын

🫶

This is pure gold

Thanks for sharing 🙏

Mon premier commentaire pour une video youtube. Ce cours est complet et grand merci pour avoir dedié autant de temps pour nous. Merci

@LukeBarousse

Сағат бұрын

🙌🙌🙌

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!

Thanks Luke!!!

@LukeBarousse

4 ай бұрын

No problem, cuz!!

The value here is just insane

Brilliant!

I took the course (which was great btw) and was very excited to create a custom GPT. I uploaded three CSV files to use as knowledge data. I provided the key column for each relationship. There are a Company file, statistical question file and a statistical answer file (with two years of data). The experience was laughable. I instructed ChatGPT to only use the data I provided and it constantly made up responses. It even made up data as it was telling me HOW it was coming up with the FAKE responses. I would ask a question like "How many widgets did Acme Corp sell in 2023?" It would respond like "I see Acme Corp listed in the Company file and it is company 1234 (there was no company with that ID). I see the code for the widget question in the Stats Questions file is WDGT (that didn't exist) and the data in the Answers file linked by the question code. So Acme Corp sold 552 widgets (it made up that number)." I must have tried 25 different ways to tell it what is was doing wrong and it would sound like it "Got it" but it only gave me the correct answer once. When I changed the question, it screwed up in new ways. Has anyone had this type of experience?

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

Thanks!

Thank you!!!

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?

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 KZread.

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.

Luke you are the best

@LukeBarousse

4 ай бұрын

Thank you!

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.

@LukeBarousse

2 ай бұрын

felt the same way when I learned that trick! Glad you felt the same!

Got my certificate! Woo hoo.

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.

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?

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

Bro you are a goat i needed that

@LukeBarousse

4 ай бұрын

😉

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!

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

let's gooooooooo!!!!! Gracias

@LukeBarousse

4 ай бұрын

🙌

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

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

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

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

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

@LukeBarousse

4 ай бұрын

it's just a one time not 3x

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

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

@LukeBarousse

4 ай бұрын

So glad OpenAI finally released the Team subscription; glad to hear you're gettin use!

The video provided a comprehensive range of valuable information and proved to be extremely useful. This comment has been written using CHATGPT.

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

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?

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

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!

@LukeBarousse

3 ай бұрын

Thanks for contributing!

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

@LukeBarousse

4 ай бұрын

For this course, you need the paid version so you can upload files and use other more advanced features

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?

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?

great

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.

Does bing do the same?

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

I watched the whole thing, it was great.

@kestixmac

4 ай бұрын

14 mins after Upload. Nice

@juliom6260

4 ай бұрын

​@@kestixmac😂😂😂

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

@LukeBarousse

3 ай бұрын

Yeah plugins have been changing lately so that's why I mention just to find a similar one

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.

Happy place ❤❤❤❤

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?

@LukeBarousse

2 ай бұрын

There is no need to enable the ADA plugin it's included in GPT-4 automatically

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?

@stephenmarques3319

4 ай бұрын

I asked ChatGPT that question and it responded that's it's part of the Enterprise Plan

@LukeBarousse

4 ай бұрын

It's no longer has to be enabled, it's auto-included in the most advanced model. Don't worry about selecting it.

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.

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

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.

@LukeBarousse

4 ай бұрын

I only run into to this limit ever so often... it does suck... but I don't find I hit it all the time

What about data safety ? Doesn't chatgpt process later on that amount of data and feed itself with it ? Nothing is for free.

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 pls i can become a data analyst and get jobs knowing how to only use chatgpt to do data analysis

Really need to learn how to read lips

No audio?

That smiley excited emoji really on your certificate bro?

Hello

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

this is GPT 4 the paid version ?

1:28:04

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

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

Hiha, yea that’s it.

Thanks so much for making this; I learned a lot! At this point: kzread.info/dash/bejne/p5ytr9ObiqycorA.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?

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.

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

@split317

4 ай бұрын

Thank you for your sacrifice ❤

@Kamadrion

4 ай бұрын

Thank you for making this course possible and accessible for everyone. I salute you.

@Arcteek

4 ай бұрын

You could ask ChatGPT that question then ;-)

@dicklexiclemon7487

4 ай бұрын

Lmfao

@LukeBarousse

4 ай бұрын

Hey @jesus629, this is the same content from my course back in November, but packaged up into a single KZread video. The full course that you have has everything broken down into different segments for the chapters, making it easier to navigate and track. Nonetheless, you should have received an email a month ago asking if you'd like a refund for the course due to the deprecation of the "Noteable" plug-in. Hit me up via email if you want to go that route

4th quartile? 🤔😉

buddy thank you so much for teaching us so much on KZread. 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?!

Goldmine

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

@LukeBarousse

4 ай бұрын

This is that course! Everything you need is inside of here

@heisenberg7049

4 ай бұрын

@@LukeBarousse Can you still achieve similar results to what you used to be able to do using Noteable except maybe it's just not as convenient?