ChatGPT Code Interpreter - Analysis Test!
📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/download-your-guide-timeline-yt
Wow!
I was so excited to put the new ChatGPT Code Interpreter tool to the test, and it did not disappoint! In fact, it impressed me greatly!
There is so much potential here and I have to say I was skeptical at first, but I am beginning to really see the potential here - and I already knew there was a TON!
In this video I took three fake datasets from files I created and asked ChatGPT's Code Interpreter to combine and analyze these files in a way that it aggregated spend data by department and created a budget comparison as the output.
Further, I asked it to convert this exercise into a Python script, which it did with exceptional results.
You have to see it to believe it, and then try it yourself!
If you're interested in learning how I would have approached this using PowerQuery in Excel you can learn all about it in my Excel 4 Academy training here: https://www.tmbanalytics.com/excel-4-academy-beta
📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/download-your-guide-timeline-yt
🌍 Interested in learning more about a career in Analytics? Pick up my free career foundations course today:
https://www.tmbanalytics.com/freetraining
👉 Connect with me on social!
Linkedin: https://www.linkedin.com/in/mattbrattin/
Tiktok: https://www.tiktok.com/@mattbrattin
00:00 Intro
01:40 Overview of task
04:05 Begin Prompting
06:08 ChatGPT Begins Work
08:53 Initial reaction
10:25 Request Python Script
11:20 Run Python Script
12:00 Check results in Excel
14:45 Wrap Up
Видео ChatGPT Code Interpreter - Analysis Test! канала Matt Brattin
https://www.tmbanalytics.com/download-your-guide-timeline-yt
Wow!
I was so excited to put the new ChatGPT Code Interpreter tool to the test, and it did not disappoint! In fact, it impressed me greatly!
There is so much potential here and I have to say I was skeptical at first, but I am beginning to really see the potential here - and I already knew there was a TON!
In this video I took three fake datasets from files I created and asked ChatGPT's Code Interpreter to combine and analyze these files in a way that it aggregated spend data by department and created a budget comparison as the output.
Further, I asked it to convert this exercise into a Python script, which it did with exceptional results.
You have to see it to believe it, and then try it yourself!
If you're interested in learning how I would have approached this using PowerQuery in Excel you can learn all about it in my Excel 4 Academy training here: https://www.tmbanalytics.com/excel-4-academy-beta
📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:
https://www.tmbanalytics.com/download-your-guide-timeline-yt
🌍 Interested in learning more about a career in Analytics? Pick up my free career foundations course today:
https://www.tmbanalytics.com/freetraining
👉 Connect with me on social!
Linkedin: https://www.linkedin.com/in/mattbrattin/
Tiktok: https://www.tiktok.com/@mattbrattin
00:00 Intro
01:40 Overview of task
04:05 Begin Prompting
06:08 ChatGPT Begins Work
08:53 Initial reaction
10:25 Request Python Script
11:20 Run Python Script
12:00 Check results in Excel
14:45 Wrap Up
Видео ChatGPT Code Interpreter - Analysis Test! канала Matt Brattin
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Single Biggest Mistake Analyst applicants make when applying for data jobs / Analytics Careers](https://i.ytimg.com/vi/75GHthFNi7o/default.jpg)
![Analytics is a Team Sport](https://i.ytimg.com/vi/JzWd0R_dZ5E/default.jpg)
![How to use CONCATENATE, CONCAT, TEXTJOIN & More in Excel](https://i.ytimg.com/vi/CAgOT8kMuj0/default.jpg)
![Google Data Analytics Certificate Course 4 of 8 - Process Data from Dirty to Clean](https://i.ytimg.com/vi/KCWQ0YO6Enw/default.jpg)
![Do you use the Camera Tool in Excel? #excel #shorts #short](https://i.ytimg.com/vi/nUBFF9bCtkA/default.jpg)
![Data Analyst Tips To Overcome Analysis Paralysis](https://i.ytimg.com/vi/t3uAcwReETQ/default.jpg)
![5 Tips for Learning Analytics Online](https://i.ytimg.com/vi/Nd7h6qKaP3w/default.jpg)
![Excel Quick Tips - How to add a date and time stamp in your Excel file #excel #shorts](https://i.ytimg.com/vi/JP6mneQtl3w/default.jpg)
![Top 4 Excel Shortcuts for Beginners #excel #shorts](https://i.ytimg.com/vi/aNO-ttb2urY/default.jpg)
![What is the most important skill to have in business today? #data #analytics #shorts](https://i.ytimg.com/vi/N0reABpa7kg/default.jpg)
![Create a Dynamic Drop Down Menu in Excel #excel #shorts](https://i.ytimg.com/vi/lnA10P27xGg/default.jpg)
![Seven Steps to Land You More Analytics Interviews](https://i.ytimg.com/vi/JK0qhI2pr3I/default.jpg)
![Top 4 Tips to Crush Your Analytics Interview](https://i.ytimg.com/vi/E5uHCk2Oa0g/default.jpg)
![Excel Conditional Formatting to Highlight Duplicate Values #excel #shorts](https://i.ytimg.com/vi/Q02A0f2URYU/default.jpg)
![Excel Quick Tips - Use the UNIQUE and TOCOL Functions to organize messy data in Excel #excel #shorts](https://i.ytimg.com/vi/8hyKhNRSRtQ/default.jpg)
![Excel Quick Tips - How to quickly format a data set in Excel using shortcuts #excel #shorts](https://i.ytimg.com/vi/XHFVagMYiXc/default.jpg)
![Excel Quick Tips - How to reorder slicer options in #excel](https://i.ytimg.com/vi/O6y2Ro2Mn-4/default.jpg)
![Excel Quick Tips - How to use the SUMIFS function](https://i.ytimg.com/vi/s6dTAHCY1rU/default.jpg)
![3 Tips to Think Like an Analyst](https://i.ytimg.com/vi/93Vz-uVSHiA/default.jpg)
![Excel Quick Tips - XLOOKUP vs other Lookup methods in #excel #shorts](https://i.ytimg.com/vi/uf5CUXT_wQY/default.jpg)
![Excel Quick Tips - How to use conditional formatting to make data look like a table in Excel #shorts](https://i.ytimg.com/vi/FIRHkRFr-E4/default.jpg)