ImmersiveAmbientModecolor: #d0b2aa (color 2)
Video Format : 22 (720p) openh264 ( https://github.com/cisco/openh264) mp4a.40.2 | 44100Hz
Audio Format: Opus - Normalized audio
PokeTubeEncryptID: a827a5a8a54515ac0fd18f823d6d3d2cba608b7512572a85f6524d4ef85fa6f619b7d9e63a57ac5a15bf1e5a023494b1
Proxy : eu-proxy.poketube.fun - refresh the page to change the proxy location
Date : 1716365405618 - unknown on Apple WebKit
Mystery text : VkNiWTFxWlZ3dm8gaSAgbG92ICB1IGV1LXByb3h5LnBva2V0dWJlLmZ1bg==
143 : true
402,933 Views • Feb 14, 2024 • Click to toggle off description
Sick of endless Excel formulas and clunky pivot tables? Tired of wrestling with messy data? This video explores how the Data Analyst in ChatGPT, the powerful AI chatbot, is revolutionizing data analysis, potentially making Excel a thing of the past! Whether you're a seasoned data analyst or just getting started, this video will challenge your perceptions and spark curiosity about the future of data exploration.
📚 RESOURCES
- Sample data to follow along: 1drv.ms/x/s!AmxrofZZlZ-whcwZqwQljIiKYk1eQQ?e=lEEBW…
⌚ TIMESTAMPS
0:00 Introduction
0:31 Get the ChatGPT Data Analyst
1:07 Explore GPTs
2:24 Load data
3:06 Preview data
3:43 Simple example
4:41 Connect multiple sheets
5:58 Make chart
7:28 Advanced analysis
8:39 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on OpenAI: • OpenAI
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official website: www.kevinstratvert.com/
- LinkedIn: www.linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: www.facebook.com/Kevin-Stratvert-101912218227818
- TikTok: www.tiktok.com/@kevinstratvert
- Instagram: www.instagram.com/kevinstratvert/
🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | squarespace.syuh.net/XYaqYM
✅ 🔍 Grammarly | grammarly.go2cloud.org/SH3nL
✅ 🛍️ Shopify | shopify.pxf.io/XY9rPa
✅ 📋 Notion | affiliate.notion.so/rffva4tr71ax
✅ 🖼️ Figma | psxid.figma.com/lqjg97licpry
✅ 🤖 ElevenLabs Text-to-Speech | try.elevenlabs.io/taqepq60mptr
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz
⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.
#stratvert #chatgpt #excel
Views : 402,933
Genre: Science & Technology
Date of upload: Feb 14, 2024 ^^
Rating : 4.84 (372/8,934 LTDR)
RYD date created : 2024-05-22T07:37:14.707833Z
See in json
YouTube Comments - 504 Comments
Top Comments of this video!! :3
If you think excel is dead you don't know excel
157 |
Problem is data privacy. We have been instructed not to upload any company data on ai sites. Lets see how they solve them.
219 |
O yes, the demo with this perfectly cleanly structured 100 row data. Gaining insights is 20% of a DAs role.
139 |
Excel VBA is still the most widely use tool for engineering and finance. Wait until you have a question from an external auditor. You still need to know the underlying process. Engineer questions are not that simple to infer. For example I just asked co pilot why the coefficient of correlation doesn’t display correctly in charts sometimes and he didn’t know why.
34 |
This is fantastic for ease of use, but slightly terrifying as an analyst watching a tool created that can allow entry-level hires to complete high-level tasks with no actual knowledge (which were prerequisites for hire initially)
190 |
Instead of a data analyst you now need a fancier-sounding and more expensive prompt writer. Progress!
3 |
I always love the "If you'd like to follow along" feature to videos and you've added this and done well with it! Thank you for sharing! Let's connect
6 |
The cool thing here is that it makes it easy to learn the tools faster and get personal projects dine in time.
3 |
Super vid! I uploaded your KCC to gpt and asked it a bunch of questions. Very helpful results and useful insight into how far this can go.
3 |
ChatGPT told me to take a break and come back later. Guess we all need a breather now and then. Amazing video btw, thanks!
7 |
This is a really interesting video. Nicely done. I echo another comment about data privacy, but this seems worth exploring more.
1 |
As someone who is an analyst, this is both terrifying and amazing. However, your data is very clean. If you give it some data that’s dirty, it does a terrible job and will fail.
15 |
Yes, you are right, its truly incredible.
2 |
...this won't replace data analysts because you still need someone to curate and collect the data and make certain there's no discrepancies in the real world. If anything, it makes a Dat analysts life easier. You're always going to need a human to communicate. Experience is key.
22 |
Chat is really useful. It’s even more useful if you have some sort of background in what you’re trying to excel at (no pun intended). That’s why people are so scared to use it, it can be used for almost anything but most people don’t have the necessary information and knowledge to maximize its use.
3 |
Very cool! I enjoyed it. Art of asking is going to be valuable.
1 |
wow truly instructive videos do exist after all, wow. props bro.
|
The value now comes from knowing how to ask the right question no longer how to use the tool.
Domain knowledge+Prompt engineering. Thank you Kevin 😊
16 |
You have to watch how you structure your data rows and columns, especially when trying to query (part description to get a part number). You have to order the columns as if a person was reading it. If you are looking for a part number, when using just the description, the description needs to be in the first column, a category column would be even better category>description>part number, instead of the other way around, I was getting some hallucinations the first go ‘round, with my initial format.
1 |
@KevinStratvert
3 months ago
:yt: Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ :learning: Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
13 |