I've just discovered chatGPT, and I am going through the motions. I use excel in my small business, and your real example has set my head thinking. Excellent video 💯👍
The potential is incredible, surely! If you've got an idea for something you want to accomplish, at this point we can just ask the tool and see what happens.
@@mattbrattin and that is where the learning really begins... how to correctly instruct the AI to produce the outcome we seek... what a great time to be alive 😊
Fascinating. Back in the day (retired now) I used to build VBA tools for this kind of work all the time. Manual processes that would take hours reduced to seconds of running a macro. But that would take days to build the needed code. Now along comes this and the potential for using the AI and python (or some other language) to create new data analysis reports is mind blowing.
Great post. Thank you for sharing this information. This helps a lot. I've been seeing your posts for a while now, and I have some ideas for you to boost your viewers and engagement.
I've had my fair share of spats with it so far as well. This is the part people need to really understand - we still need to "human check" what's happening.
Great video. Awesome to see what ChatGPT can do in a real life situation. I'm a programmer and don't often have to use Excel for analysis tasks but, it's awesome to know that it's there and that work done with it should be pretty good (though you should always test the output to validate any ML model's work).
Yeah it can write code in many languages Couple of unique things about Code Interpreter is that it runs python, sees it failed, tries to fix, runs again before asking. I see it can be way crazier, imagine it having access to databases and apis that it can query. I honestly was underwhelmed by Code Interpreter as it does not install many libraries. Like ones for visual analysis. While it actually generates code of how to use them. So it can do it, limitation is just security and hardware resources considerations. Now imagine attaching it to Jupiter notebooks or local environment! I am actually playing with allowing it to work with JavaScript right in browser
I used regular GPT4 to create some VBA code a week ago to do a bunch of formatting I didn't want to do by hand. Took a little bit to get it to understand what I really wanted it to do, but once I figured out how to properly describe what I was asking for, it banged it right out. Would have taken me hours to figure out all of the edge cases by hand.
@@chopchop7871 That's great! Yeah I used it recently to clean up some VBA after some security change messed with some of my steps. It was actually kind of fun troubleshooting the re-write with GPT as I was feeding ideas and it was re-coding to test like I was sitting with an Analyst. Much more engaging than googling for solutions and got it done in under 10 min. Game changed!
I love your x l videos and shorts. Thank you so much for all your tips and tricks. Have a fast question What kind of mouse do you use? Do you have issues with your wrist and arm hurting? Do you use a wristpad ? I'm trying to come up with a way To help with mine. maybe getting a vertical mouse. Do you ever use adobe? I'm definitely needing any kind of tips and tricks with that program too.if yo c an. Please.
Glad to know you've been enjoying the content! I use an incredibly cheap little mouse, I think it's called Rii and because I don't use the mouse all that much it seems to be ok for me. In the past I had a lot of issues and ended up going with a vertical mouse, which plenty of people seem to like so it might be worth a try! Regarding Adobe - which programs do you use? I use adobe for video editing and some graphics and photo editing, but I'm amateur at best and probably not one to be giving tips!
You will probably be able to self-host something like this in a few months time. I think that would be the way to go rather than uploading your confidential data to ChatGPT. The AI tools that we first saw at the beginning of the year, you can now run on your own computer if you have something like a 3080Ti GPU and 32GB RAM.
Sir please clear my doubt Copilot 365 soon available in Excel & other ai tools are there So is it still important to learn ms Excel deeply all functions and advance formulas
If I were to attack this problem, I would use my brain and SQL. If the data is in "excel", I'd save as CSV and import into SQL and then co-relate the data. It would take a few minutes but it would not be difficult. But I am a professional. If a simpleton could do this kind of work, then you wouldn't need to pay someone like me. So data analysts won't go extinct. Well-paid ones will. They'll still need humans to do this, but they'll make it a door-dash like situation.
Eh, we can agree to disagree, lol. When performing financial variances to budget, if you are over on revenue, gross margin, or net margin it's a "good guy", if you are over on COGS or OPEX it's a "bad guy". If you spent $5k more than budget, you do not want to reflect this as a positive.
Amazing to see someone with your expert level to be impressed by it. Thanks for the clear explanation and showcase
I'm soooo jealous right now!
I run here after seeing your post on LinkedIn
I've just discovered chatGPT, and I am going through the motions. I use excel in my small business, and your real example has set my head thinking. Excellent video 💯👍
The potential is incredible, surely! If you've got an idea for something you want to accomplish, at this point we can just ask the tool and see what happens.
@@mattbrattin and that is where the learning really begins... how to correctly instruct the AI to produce the outcome we seek... what a great time to be alive 😊
Dude this is amazing! I am thinking of all the possibilities with Sub Stats!
For real man, tons of possibilities!
Fascinating. Back in the day (retired now) I used to build VBA tools for this kind of work all the time. Manual processes that would take hours reduced to seconds of running a macro. But that would take days to build the needed code. Now along comes this and the potential for using the AI and python (or some other language) to create new data analysis reports is mind blowing.
Same here! People starting out in Analysis right now have no idea how incredible the opportunity for rapid growth is.
Great post. Thank you for sharing this information. This helps a lot. I've been seeing your posts for a while now, and I have some ideas for you to boost your viewers and engagement.
That was awesome Matt, thank you. You've got a new subscriber and I look forward to knew content.
Glad to hear it! New content definitely on the way!
I am impressed... My experience with GPT4 is how horrific it is with math.
I've had my fair share of spats with it so far as well. This is the part people need to really understand - we still need to "human check" what's happening.
Good demo!
Thanks! It was honestly a fun one to make!
Nice video! The Code Interpreter looks like it has a lot of potential.
It really does! Looking forward to seeing what others get it to do as well!
Great video. Awesome to see what ChatGPT can do in a real life situation. I'm a programmer and don't often have to use Excel for analysis tasks but, it's awesome to know that it's there and that work done with it should be pretty good (though you should always test the output to validate any ML model's work).
100%, and this being just the beginning is wild!
I just started with this myself and you did an amazing job with a great example. I'm a vba guy but this is the reason to learn python.
Nice, yeah I was so caught up in it this morning I just now started thinking I should have tried to have it create VBA or M code too! Next video!
Yeah it can write code in many languages
Couple of unique things about Code Interpreter is that it runs python, sees it failed, tries to fix, runs again before asking.
I see it can be way crazier, imagine it having access to databases and apis that it can query.
I honestly was underwhelmed by Code Interpreter as it does not install many libraries. Like ones for visual analysis.
While it actually generates code of how to use them.
So it can do it, limitation is just security and hardware resources considerations.
Now imagine attaching it to Jupiter notebooks or local environment!
I am actually playing with allowing it to work with JavaScript right in browser
I used regular GPT4 to create some VBA code a week ago to do a bunch of formatting I didn't want to do by hand. Took a little bit to get it to understand what I really wanted it to do, but once I figured out how to properly describe what I was asking for, it banged it right out. Would have taken me hours to figure out all of the edge cases by hand.
@@chopchop7871 That's great! Yeah I used it recently to clean up some VBA after some security change messed with some of my steps. It was actually kind of fun troubleshooting the re-write with GPT as I was feeding ideas and it was re-coding to test like I was sitting with an Analyst. Much more engaging than googling for solutions and got it done in under 10 min. Game changed!
I love your x l videos and shorts. Thank you so much for all your tips and tricks. Have a fast question What kind of mouse do you use? Do you have issues with your wrist and arm hurting? Do you use a wristpad ? I'm trying to come up with a way To help with mine. maybe getting a vertical mouse. Do you ever use adobe? I'm definitely needing any kind of tips and tricks with that program too.if yo c an. Please.
Glad to know you've been enjoying the content! I use an incredibly cheap little mouse, I think it's called Rii and because I don't use the mouse all that much it seems to be ok for me. In the past I had a lot of issues and ended up going with a vertical mouse, which plenty of people seem to like so it might be worth a try!
Regarding Adobe - which programs do you use? I use adobe for video editing and some graphics and photo editing, but I'm amateur at best and probably not one to be giving tips!
You will probably be able to self-host something like this in a few months time. I think that would be the way to go rather than uploading your confidential data to ChatGPT.
The AI tools that we first saw at the beginning of the year, you can now run on your own computer if you have something like a 3080Ti GPU and 32GB RAM.
Yup, it's coming! Too much value for it not to be.
Sir
please clear my doubt
Copilot 365 soon available in Excel & other ai tools are there
So
is it still important to learn ms Excel deeply all functions and advance formulas
what is the time to be alive !
OMG!!
Nice video
Why thank you!
If I were to attack this problem, I would use my brain and SQL.
If the data is in "excel", I'd save as CSV and import into SQL and then co-relate the data.
It would take a few minutes but it would not be difficult. But I am a professional.
If a simpleton could do this kind of work, then you wouldn't need to pay someone like me.
So data analysts won't go extinct. Well-paid ones will. They'll still need humans to do this, but they'll make it a door-dash like situation.
BUT DOES IT ALSO GIVE EQUIVALENT CODE IN R. (if needed for replication)
yes but it won't debug it like python
@@iritesh Oh interesting, I imagine it'll troubleshoot if you need to iterate though no?
overspend should be positive, and underspend should be negative.. I side with GPT on that one.
Eh, we can agree to disagree, lol. When performing financial variances to budget, if you are over on revenue, gross margin, or net margin it's a "good guy", if you are over on COGS or OPEX it's a "bad guy". If you spent $5k more than budget, you do not want to reflect this as a positive.
With this fast in ai development .
all repetitive work using computers can be automated within 3 years
hi
Hi Matt!!
First to comment!!
Hello! First to reply!
Hi,
Sorry, but you maybe better learn some other stuff.
Win copilot is coming for office tasks.
Bring it on!