Intro, options and setup

0:00 data nerds welcome to this full tutorial on how I use chat gbt for data analytics and this thing saves me up to 20 hours a week I use it for everything from analyzing spreadsheets for making in-depth visualizations to even more advanced concepts like machine learning and this entire video bundles up all my best practices for using chat gbt the number one AI tool of data nerds as my own personal data analytics assistant now this is all going to be broken up into six different chapters first was setting up chat gbt and understanding basic prompting next we'll move into chat gbt's most powerful internal tool we'll use Advanced Data analysis to build your very first project from scratch now for those that have seen this video that I did back in November and I teased an entire course on Chach PT well this is that entire course and you can skip those last two chapters I

0:44 just went over and go to this timestamp right here as the new portion jumps into the fundamentals of analytics we'll cover the best practice of visualizations and what the different types of analytics are next we'll get into some Advanced topics focusing on prompting techniques to prevent hallucinations we'll even cover Chachi BT's newest feature gpts and show you how to find the best ones for analytics from there we'll move into plugins even covering things like how to browse the internet and generating your own images and we'll wrap up the course with how you can get your own data for your projects not only be able to find public data sets but also extract it through techniques like web scraping now this three and 1 half hour video is all you need in order to complete this course heck I have included all the different reference you may need in the description however if you're looking to actually support this Channel and making more content like this then visit this

1:30 link right here as I'm going to give you even more additional perks for this including things like a certificate you'll receive upon completion detailed step-by-step instructions for each of the exercises in-depth notes for all the different segments of this video oh and I'll also be answering any your questions right inside of here now this chat gbt tutorial is something I wish I would have had when I first started as a data analyst as now somebody with no experience can get up and running from day one and Performing data analytics while saving a buttload of time a recent study from Harvard found that those who use chat GPT versus those that don't complete a task 25% faster with a 40% increase in quality so that 20 hours a week that I save I feel it's also realistic to you as well based on the data anyway if you get stuck at any point during the course I made a custom chatbot built on top of chat gbt that

2:17 can help you out enough me appen let's actually get into setting up chat gbt all right so let's get into the options that you have available for using chat gbt for this course and then finally we'll go into one of the options on how to actually set it up which I think it's going to be applicable to most of the users of this course there's four options for the course but it's really broken into two options one for individuals and others for businesses if you're individual you have the option of free or plus we're not going to be able to use free for this video or course because it doesn't have that advanced capabilities of advanced data analytics in order to analyze data so you have to get plus if you're an individual now chpd plus here in the United States is about $20 a month and with this you have an availability to access their newest and most capable model in this case it's GPT 4 um this may change be a higher

3:06 number model depending on when you take the course but overall you have access to the newest and greatest model from there it has some faster response speeds also you have access to plugins and Advanced Data analysis and both of these things are the core of what this course is going to take advantage of to make sure that you're doing data analytics correctly in chat GPT now there's two options for businesses in order to handle secure data specifically we have team and Enterprise we're going to focus on Enterprise first and then get back to team now the last two options which are applicable to businesses are team and Enterprise and it's going to have a similar interface that as uh chat gbt plus but it's going to be through a separate service and it's going to be mainly that your company is now paying for this chat BT Enterprise Edition and then you as an employee of the company have access to it now chat gbt Enterprise solves a lot L of problems when dealing with secure data specifically stuff like Hippa data confidential or even proprietary data it will all maintain that safe chbt plus doesn't necessarily do this but we're going to be going over in this course

4:15 how to safu your data if you have concerns with that now team is basically that Enterprise Edition but with a couple of removed functionalities specifically you have a reduced message cap and don't necessarily have Account Support directly but regardless this is still a great option if you need an option to handle secure confidential data this plan is for organizations that are less than 150 people so if you have any of these paid options available this is the end of the section for you you can go ahead and proceed to the next portion otherwise stick around because now we're going to be going over how to install chat gbt plus the first thing to do to get set up is go to open.com and select try chaty BT from there we're going to select sign up I use my Google credentials because I feel that's easier and so I don't have to forget a password and so you'll use that and login with your Google credentials it will send you an email to verify that it's actually you after that you'll be directed back into that chat that we're going to be operating in for basically the rest of this course I'll go ahead and accept these terms and agreements and also these tips so right now we're using the free version of chat gbt which is this

5:25 model right here gbt 3.5 but we need the newest and greatest model in order to get all those Advanced capabilities and advanced analysis so we need to upgrade to plus we can either do it right here or you can select it up in this menu on the Le hand side and we can see from this we have the plus version and it's 20 bucks a month right now they have this sign up for wait list and I don't think you're have to wait that long but they're pausing it because there's been a lot of different influx based on these new upgrades of chat gbt and apparently everybody wants to get in now either if you have the weight wa list or you're able to actually sign up immediately which hopefully you can you'll then be directed to this screen right here which is where you'll actually be putting in your payment information they're accepting credit cards right now and you'll be subscribing for that 20 bucks a month

6:12 make sure you're comfortable with paying that 20 bucks per month before proceeding but just to reiterate you do need this chat gbt Plus for this course after that you'll be directed back into this chat and now we'll have all models available so in our case at the time recording this I have that GPT 4 model and GPT 3.5 we're going to be using the GPT 4 for this course because it has that browsing and Analysis in it and this home of this chat is going to be located at chat.

6:36 open.com and I would save this to your bookmarks or to your favorit so that way you can easily access it all right with that now it's your turn to jump in and actually go through and set up chat gbt plus if we don't have it set up already and after that we're going to be jumping into some more examples on how to use this all right in this video we're going to be going over the layout of chat gbt and all the different functionality that's involved with it to get you up and running to do your first prompt now Chachi BT just recently in November of 2023 went through a layout change and unfortunately I went through and filmed this entire course and so I'm going back and refilm some of these videos anyway you're going to notice in this course sometimes that the old layout is inside of some of these videos don't be alarmed by that this I'm going through and correcting any ones that need to be updated but if you do notice there's differences in what my Chach BT and your Chach BT looks alike overall I'm trying to tell you this don't be concerned anyway let's go through the layout you should be seeing over here on the left hand side we have our sidebar and then

7:47 right here on the um right hand side we have our actual chat we'll be interacting with our gbt model for the sidebar you can either close it out or bring it back in up at the top they have all the different gpts you probably only have one GPT right now of chat GPT below this it has our different chat history and then underneath that you can refer a friend and then next is settings settings it's a whole another video because there's a lot to go into this so stay tuned for that one so back to the gpts up at the top gpts you can actually click the explore menu right here are custombuilt models built on top of Chad GPT to perform specific functions so I built a gbt for this course called data analytics and I'll link it below and in the exercise and you can actually go into this data analytics title GPT and quiz it on the contents of the course now there's also a whole host of other gpts as well but the one we're primarily going to be focusing on besides that chat bot for this course is this one up at the top that you have already should have and that's just chat GPT now with this specific one we can go up to the top leftand corner and you can select

8:59 the newest and greatest model which I recommend doing and that's going to include as of filming this dolly browsing and Analysis and this model is great because it includes everything we're going to need from this course from browsing the internet to performing with that Advanced Data analysis plug-in that we'll be going over in a complete chapter gbt 35 as of filming this is in the free version we're not going to be really messing with that then we'll also be jumping into also plugins in the future specifically this notable plugin but for the time being let's just stick with that GPT 4 model so let's prompt chat GPT with our first prompt asking it who the heck are you and what can you do to find out what some of the limitations are of it and it goes into telling you a lot of the stuff that I've told you already now some things to note with this so it provided a response you can

9:47 copy this response you can also like it and dislike it to help feed the algorithm on whether it's performing good or not you can also click this regenerate and this is great for if you're getting response or it's getting held up and you want to regenerate a new response to get it from a different angle and as you can see it's completely different even a completely different layout from what we got before I'll be honest I like this one a little bit more so I'm going to say it was better up at the top right we have a share icon so you can take this link that is actually provided with chat gbt and I'm going to go ahead and paste it in a new browser right here so that way you can see it and those even without a chat gbt account can go in and actually view the results of what you got from this and then in the bottom right hand corner we

10:30 have this question mark they have an help and FAQ some release notes term and policy I really honest I don't really use that much the one I do use is keyboard shortcuts specifically I would commit these two to memory the copy last code block and the copy last response these are great at actually grabbing different things that I'm getting from Chachi BT and pasting it somewhere else where I may be working the last thing to note is we can actually change these chats so this is our chat history we're right now in this one titled data content wizard and I don't really like the name of it I can actually go in and select rename for important chats I'd like to begin them with an emoji so that way they're easy recognizable and then also give it an appropriate title all right so now it's your turn to perform some tasks I want you to go into that base chat gbt model and actually prompt it to understand similar to that what I asked it who the heck are you and what can you do additionally I want you to get that chatbot for this course loaded into your menu so I'm going to include a link in the exercise for you actually to go to it and it's going to take you right to here and it should add it to your sidebar for this one feel free to prompt it any questions about the course right

11:38 here they have some recommended things I'm going to ask it hey what's Luke's course about and from the transcripts that I built this bot on top of it actually goes into a lot of the different areas that we're going to go in for this course so this is pretty cool this will be a great tool for you actually to quiz yourself and also ask questions if you get stuck all right with that one I'll see you in the next one all right let's now get into to basic prompting techniques that you need