Mastering Data Visualization with ChatGPT and Plugins: Create Stunning Graphs in Minutes!

welcome to today's video where I would love to introduce you to a new potential use case for chat GPT in project management and more specifically I'm going to be showing you how you can create highly visual graphs and data analysis that you can then use in your status reporting and Communications to stakeholders that whether internally or externally before I begin I do just need to mention that you will need to sign up for a Plus account or plus plan and that's because we need to use the gpt4 model so this is going to come at cost I believe it's around 20 a month but there's lots of different ways you can leverage chat GPT and if you're a subscriber of the channel you'll notice I've released quite a few other videos like this so it may be an investment you may want to make so do consider that from the outset but do continue watching because this video may change your mind as to whether you actually want to sign up and do consider that chat gbt is getting better all of the time and I'm exploring the tool as well so I'm learning new ways to interact with it and to get different outputs as well so yeah make sure you subscribe to the channel if you haven't already so the first thing you're going to need to do is of course sign up for an account and then get on a A plus plan once you've done that you will need to head to the settings of your account and you will need to navigate to this second tab better features and you will need to make sure that plugins is activated so just check that I Believe by default it's unchecked and that will mean that you won't be able to access the plugin repository and that's what we're going to be using right now so make sure that's checked now once you've done that you may need to refresh your chat GPT and then you need to head over to the gpt4 model and then you need to select plugins from here you then need to select it says no plugins enabled so from here we you will then need to go to the plugin store and it takes a couple of seconds to load and then you want to type in diagram oh no sorry graph I've already installed this you will then need to install this particular one called I'm not even going to print try and pronounce that but I'm assuming that's a take on diagram build charts graphs and more so install that once you've done that you just select this plugin and then we can enter our first prompt so what I've done ahead of this uh header recording is I've just I've created some dummy data that I want to analyze and put in graphical form so as you can see here I mean you could have a much larger data set than this and you could have various different data points that you want to summarize what I've actually done is I've just put in some dummy data for a set of five different projects based on what their supposed budget was and uh what they're in you know resulting cost was so we can actually see what projects ran to budget so what I'm going to do is I'm going to select all of this data I'm going to press Ctrl C and head back to chat GPT and I'm going to put this prompt in analyze the following data I'm sorry that's British spelling as you could probably tell I'll put that in American analyze the following data in graph form I mean graphical form is probably better grammar so I will put that in and then I'm going to press Ctrl and V so this is where you put in your your data hit enter and now we just need to wait for the plugin to do its thing so right off the bat you'll see that it is is activated using and this particular plugin so let's just give this a moment to run it does seem to take you know a minute or two so do consider that but you can see that it is is you know working use you can see it's in process we've got this little symbol here so we do need just a little bit of patience um but yeah it will generate in a moment and I'm going to show you how you can also and this is where it's kind of beneficial because obviously we've got to wait here you may be thinking oh I could have just done this in Excel there's a really nice format that comes out and you'll see why I'm using this particular plugin in a moment because we can provide future prompts to kind of refine it further and that's where in Excel it's a little bit more tricky to to alter you know you need to change your filters you need to just play around with perhaps the data and it can it can take a long long time so the benefits of this is that you don't need to do that but we do just need to wait for this to generate and it trust me I've done this before it doesn't take too long so yeah I'm going to keep it running so here we go the reason I didn't stop the video by the way is I wanted to wanted to show you how long it actually takes so here we go this is what it's produced so I didn't tell it what to produce I just said analyze it so here is the bar chart visualizing the comparison between the budget allocated for each project and the actual cost incurred interesting that it's pulled that out so here you can see it's obviously done it's mapped against the project and it's just really it's lovely it's really really great you could then use the Snipping Tool I could put this I could just put this straight in an email um but better still is you can view the chart in more detail here so if you click this open a new tab and this is when it's really really nice because I mean it's got this not in a day in night mode which is just quite cool um but yeah it's you could just grab this right away I mean you could send this as a link um but I would I would use a Snipping Tool and I would save this or you know you could then copy and paste this into an email or wherever you need it but I just really like the color I like the formatting like the text I just think it looks absolutely brilliant and also it's actually interactive so as you can see here hovering over it it's showing that's the cost to hover over this and it's the budget so it's actually just really really clever It's actually an interactive graph so that's what you can do that's the first diagram we've got off just a very very basic prompt and I could have actually been more specific I could have said something like please you know I could have said something along the lines of this please create a bar chart comparing the budget against the actual cost incurred I could have done that and this obviously would have got the same results or I could have been a bit more specific and if we wanted to look for something else so the second thing we can do and this is just a prompt to refund it further so the purpose of this is to give you some ideas of what you can do so yeah what I would suggest you do is go out and do this yourself play around with the tool and see what it does for you you might want to create different kinds of graphs or charts so yeah the purpose of this video isn't to tell you go to chat gbt and replicate this it's play around with the tool this is what can be done explore it and kind of see what uh it can be done for you so here's just a quick second prompt I'm going to show you I don't want this video to come for too long as I say do subscribe you're going to get a lot of videos about how I'm using chatgpt to really refine this tool further and get some fascinating data analysis or visualizations that I'm using in my day-to-day role as a project manager but here's the second prompt so alter the above diagram by project manager so this is where the value comes this is where you refine it to your needs again it's activated it's it's now understanding The Prompt that I've said and it is going to well I've done this before so it should work if it doesn't work now it'd be pretty pretty shocked um but yeah it's taking into account my prompt and it's going to refine this based on our needs so again used using so it tends to I've noticed that a pattern here it does tend to take three of these little processes I suppose to get to where we need so at the moment let's just assume we're two-thirds of the way through excuse me um yeah we'll let this run I'll show you what it looks like you probably can imagine uh so here's the third one we're getting there and uh we'll let this run and I'll show you what what happens and then we can wrap up but yeah do stick around to the end because this is exciting well I think it is um you know any way we can create things like this uh you know in an automated fashion uh is useful in my opinion um so yeah let's just let this finish where it should be done oh he's going for a fourth interestingly I I didn't expect that but it is it is going for a fourth but we should we should uh um be there very very shortly maybe this is the downside uh we're going for a fifth maybe this is the downside to chat GPT um you know at the moment is it still a little bit slow um but then again I'm using a plug-in here so it's obviously having to pull from some kind of external API to do this um I will be showing you in future videos other other plugins we can use for similar um analysis so this one's taken a while interestingly so as I say I'm still exploring this tool I'm still getting used to it and that's what I would suggest you do I'm still testing it and that's the best thing you can do so this is this is messing around so I'm going to stop generating it so um I'm gonna change the prompt just to see what happens so I stopped generating and I hit save and submit and yeah I could have stopped the video I could have stopped the video and stopped recording and I could have made this look you know fantastic but I want this to be as genuine as as as as possible I want you to see how I kind of work with it and how it how I interact with it and what I get you know it's not all it's not all brilliant at times so here we go this is a lot quicker so being a little bit more specific seems to have worked here is the bar chart visualizing the comparison between the budget allocated for each project and the actual cost incurred Group by project manager that's what we're after and it also looks brilliant again let's click through here so there you go there's a little lesson be specific the more specific you can be it turns out the better or the faster the result the best well the more accurate and the faster result maybe it's having to a lot less a lot less computing involved because it's not having to consider alternatives it's just get going to what we're looking for so here we go again this is absolutely brilliant also the the data is different because it is amalgamating um the data for for the project manager so yeah this you know this is really useful I'm going to start using these I've got two different um graphs now that I can add to some of my stated supporting and yeah I hope this video is useful if it was please hit the like button that tells me I should continue recording video videos like this and do consider subscribing if you haven't already if you do head over to my channel you'll notice lots of other videos are not only chat GPT but on project management in general whether that is project management training whether that is on different tools such as your likes of smartsheet and Asana there's all it's all over there so do make sure you check that out if you are a project manager and you and you do want to learn more so with all of that said I hope you have an excellent day

Channel: Proper Project Management

Views: 9,701

Keywords: chatgpt project management, chatgpt for project management, chatgpt graphs, chatgpt data visualization

Id: 691vNA5NBSE

Length: 11min 44sec (704 seconds)

Published: Thu Jun 15 2023