Is Excel Dead? Meet the ChatGPT Data Analyst.

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
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-whcwZq...
⌚ 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: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / 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 KZbin
kzbin.info?...
🙌 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

[@KevinStratvert]

Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/

[@FibaFanatic]

Please don't sensationalize titles. It's essentially clickbait.

[@bms4654]

O yes, the demo with this perfectly cleanly structured 100 row data. Gaining insights is 20% of a DAs role.

[@dreamcatcher3748]

What's the other 80%?

[@marcuskenyon5244]

​@@dreamcatcher3748 Getting the data sufficiently cleaned up and formatted to be able to glean those insights.

[@jwia007]

Structuring the data is the other 80% 😅

[@dreamcatcher3748]

@@jwia007 Yes. And... one the the hardest things I had to learn, after decades working with hierarchical and relational databases is the concepts of the Semantic Web and RDF. Perhaps in another 20 years, we'll move away from more structured approaches into a land where LLMs are much more comfortable and they will create structure and relationships on the fly when needed. IBM DB2 Ent Ser Ed and Amazon Neptune support this. Microsoft Trinity supports RDF too.

[@lloydmcleod629]

"Data Analyst" as a role is misleading. You're a Data-preprocessor with a side of analysis.

[@miamisasquatch]

If you think excel is dead you don't know excel

[@VikasBhargava1981]

Not excel, manual or formula data analysis is dead already. Excel is a data structure in tabular form to manipulate. All the power of analysis is on the AI side soon which will be faster and trivially done by anyone without knowing Excel. You can store all the data you want in it and just cause it's a table, it will survive as a data saving format. But not for much longer.

[@oscarzapatajr2]

I understand both points of view, new technologies have been trying to kill excel for more than 20 years now unsuccessfuly... But maybe this time is different? But also notice that when asked why profits when down the last year, the AI suggested different reasons without providing the correct answer... This will mean that the data analyst will still need to have skills in excel, powerbi or other data analyst tools to drill in and find the currect reasons... I believe that the data analysts that will survive the AI apocalypse are the one that can automate and speed up their work working WITH this new AI tools, no against them... We have done it before. When powerbi appeared, people that adapted and learned and added that tool to our arsenal did very well... AI could be another tool that data analyst power users can use to become faster and more skilled in our job... Beside, you still need to ask the right questions to the AI and decide on the best provided solutions, and that is exactly the kind of things that good data analysts can do very well...

[@danchris7179]

Excel has huge problems. You cannot use it in git. You cannot test it in a god way. The amount of data is limited and its slow. The reason why its still in use is, because people with an economics background need bullshit jobs. Thats why ai systems won't kill Excel

[@agentsmith7947]

Is it dead lol

[@scottbucky618]

If you think this KZbin video title is an accurate representation of what the creator thinks or what the video is about and not just a clickbait title then you don’t know KZbin

[@InnocentBoyV]

Problem is data privacy. We have been instructed not to upload any company data on ai sites. Lets see how they solve them.

[@robertk1834]

Us too

[@carlocalingasan998]

That is the business model of OpenAI and other upcoming AI companies. They will offer businesses customized, closed and secure AI engines that could only be used within the confines of the company's network.

[@mathijs9365]

Still dont recommend.

Exactly! This is useless because of lack of data privacy.

[@Sindigo-ic6xq]

gpt team is private, just upgrade it

[@marioustxexcel6375]

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.

[@aanlungyee9533]

appreciate you shared the idea which most of us had never looked into :)

[@piotrniec9638]

A cholera !! W ogloszeniach o prace ciagle chca SAP i ERP !!!

[@CarlosRamirezTrades]

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

[@pwells2389]

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.

[@dreamcatcher3748]

Another great video, Kevin. Have you tried the Microsoft Copilot add-in for Excel? I'd love to see a video on that too. Thanks!

[@PrimaryIgnition]

ChatGPT told me to take a break and come back later. Guess we all need a breather now and then. Amazing video btw, thanks!

[@JBB685]

Most of the time that happens I’ve hit a dead end. If you start over and summarize what you gained from the last conversation it gets going pretty well

[@uchennaduru8722]

The cool thing here is that it makes it easy to learn the tools faster and get personal projects dine in time.

[@RossMaynardProcessExcellence]

This is a really interesting video. Nicely done. I echo another comment about data privacy, but this seems worth exploring more.

[@joebee3438]

Yes, you are right, its truly incredible.

[@polyinprog1130]

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)

[@polyinprog1130]

I suppose my biggest solace lies in the fact that I’m employed in a secure facility. The data we work with requires security clearance to access it, so I don’t need to stress about losing my job to some yahoo who used this tool to “look good without learning” since we would never be permitted to have Chat-GPT on our devices or export a file to use on a personal device.

[@sa34w]

@@polyinprog1130it could change drastically there are LLMs which are being developed which will run on premise servers , training will be done on Large Datasets but no data will be sent outside 😂 no one is safe in AI revolution

[@Ccyt954]

Good, triumph in darkness, assuming there's no Sun at all 😊

[@DuAuskenner]

Sorry, but what kind of „high-level task“ were presented here?

[@chipcook5346]

It can allow entry-level people to make huge and horrifying mistakes because they can't tell what they are looking at, just like highly automated industrial equipment can be run by a noob, but...

[@user-ec1hz4zn8i]

wow truly instructive videos do exist after all, wow. props bro.

[@OmideToraby]

Very cool! I enjoyed it. Art of asking is going to be valuable.

[@peterdavis9403]

But can it add data to the spreadsheet? I'd love to have it as an assistant that you could tell to add a new stock purchase to my existing portfolio in all the right places and formats and links to tax portions of same spreadsheet.

[@Dragontbone]

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.

[@tok1879]

How are you so sure that's what will happen?

[@Dragontbone]

Because I’ve tested it. I’ve tested its ability to clean data and it usually ends up screwing it up. It’s not optimized for cleaning data right now.

[@tok1879]

@@Dragontbone oh ok

[@Drfresh1402]

The thing is, dirty data is data full of bad patterns like null rows and columns. If you ask me data cleaning will eventually be a breeze for AI.

[@gd8205]

Today is the worst AI will ever be….

[@manny8479]

This was awesome! How would we get it to add those created charts and visuals to an Excel or other output file? Thanks again!

[@willkydd]

Instead of a data analyst you now need a fancier-sounding and more expensive prompt writer. Progress!

[@josephw9690]

Great video! You missed to show that you can ask GPT for a downloadable png of the graphs You can also do so much more, like flowcharts, mind maps, heat maps, etc

[@KevinStratvert]

Good point!

[@josephw9690]

@@KevinStratvert In my case, I had a sheet with several thousand rows of Amazon sales data, including daily and hourly data. GPT was able to analyze it and give me deep insights, such as hourly and daily trends. Plus, it provided me with super cool graphs to show YoY comparisons and hourly sales heat maps too. I was super impressed and actually found it very useful.

[@KeneDigital]

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 😊

[@sergiocampodonico6992]

Hi Kevin, could I use this function to solve and learn step-by-step resolution on Calculus problems?

[@subratadatta3914]

Brilliant and it is very useful Presentation.👌

[@Oilcruzer]

Will it coordinate an in depth analysis of internal and world event driven items such as the loss of a key employee, bringing on a new vendor, a flood in the region, the Suez Canal impacting just in time delivery dates, changes in laws or government, multiple data souces… and things you have not considered, when making predictions?

[@yoursubconscious]

if you could do more of these, super helpful

[@NICOLASLAM-xy6mn]

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.

[@jerrydellasala7643]

Great video. Next, show how to use it to generate files (PDF, PowerPoint, Excel w/Charts/Dashboard, Power BI) to convey the information!

[@steven871]

Thanks. Can the GPT run solver , goalseek? Can it run breakeven and pricing optimization?

[@silolojose]

Curious to know if it can it do a regression analysis and turn it into a model? thanks

[@grisheldamarks-webster-noa1706]

What is a good alternative to Excel spreadsheet that uses functions that auto-populate depending on a cell's value and auto-calculate also? Some users were not able to use the excel workbook.

[@kevinjoseph9023]

Is it possible for this tool to use the two tables and create a3 by combining column from the first two tables?

[@yoanperez172]

This is very interesting, I wonder if you could just write can you analyze the data and give me insights? And for example he would found the seasonality without having to ask for it directly. Also this seems like a very small excel table, does it work with large files?

[@AlomMohammad]

Wow! This video blew my mind! ChatGPT's Data Analyst is a game-changer for data analysis. Thank You Kavin!!

[@sebastianfranco8115]

If you have experience in data analysis, you will know this is pretty basic stuff and it’s far from being a game changer

[@LeaMaria2020]

Your channel is one of my few, very few favorite subscriptions on KZbin ever.😺Straightforward. With substance.🎀🏆🏆

[@talkinghat88]

Great video! Companies paid their price to avoid hacking and yet many are going to pay to expose themselves with AI.

[@statesman6379]

From ChatGPT's solutions, if you click the [>-] hyperlink, does that give you the formulas that it's using to do its calculations?

[@manymoms920]

Love it. I can think of a problem however. My boss would probably be unsure of the accuracy. She'll want to see the workings out. If we ask chagpt to put the workings out in a table would it ?

[@anthonygikuri]

Thank you Kelvin, what about qaulitative data analysis? IN VIVO?

[@LatifAmars]

Hi Kevin, can you do another video of Excel with Copilot Pro or Copilot for Microsoft 365? Want to see how it compares to this

[@user-tg9pz4oh2y]

🎯 Key Takeaways for quick navigation: 00:00 *🤖 Introduction to ChatGPT Data Analyst* - Introduction to ChatGPT's functionality as a personal AI Data Analyst. - Overview of premium subscription features and custom GPTs. - Demonstrations of various GPT capabilities, including data analysis and visualization. 02:16 *📊 Data Analysis with ChatGPT* - ChatGPT's ability to analyze data from Excel files. - Demonstrations of simple and complex data analysis queries. - Explanation of how ChatGPT aggregates data from multiple sheets and performs calculations. 06:19 *💵 Data Visualization with ChatGPT* - ChatGPT's capability to create visualizations, such as bar charts, from data. - Demonstrations of modifying chart properties, such as axis formatting and bar colors. - Ease of making visual adjustments through simple text-based commands. 07:42 *📈 Advanced Data Analysis Queries* - ChatGPT's ability to provide detailed analysis and insights for complex queries. - Examples of querying trends, identifying potential reasons for flat profits, and analyzing seasonal patterns. - Illustration of ChatGPT's potential to assist in decision-making processes and business insights. Made with HARPA AI

[@HenrySuarez-ix7zt]

EXCELENTE VIDEO HERMANO, GRACIAS POR LA INFORMACION.

[@canslimmaster1]

Yes, truly incredible thank you, Kevin

[@douglasblackburn7396]

Is the "Data Analyst" tool available within the current GPT-4? I do have a premium subscription and access to the custom GPT's. So my question is: If I were to upload an Excel file to the GPT-4 chat, would the results be the same as the results inside Data Analyst?

[@emmanuelezenwere]

I’m interested in the answer to your question

[@sunflash101]

Is the data that you upload into ChatGPT confidential? Could the data be used to further develop the model and/or be utilized as supporting evidence/data for prompts by other users or is it isolated? Would you redact the workbook before uploading it?

[@michelangelomatteoda4814]

Thanks for this. I was trying this function of chat gpt before it becomes a separate gpt but I was not impressed by the results. The deduction from the exel file were pretty obvious. I should retest this. Thanks!

[@yacineatroune]

Thanks for sharing very interesting.. how your data is safe in the internet?

[@kuto1]

What is the maximum number of lines chat-gpt 4 can analyze this way per excel tabl?

[@kevinknight997]

Thank you Kevin I hope your company makes even more profit.

[@Spatial_Computer]

Sumif equation for the revenue for one customer, reports though with tables and graphs definitely could hasten doing analytics on a per workbook basis.

[@SoonerStoneAI]

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.

[@salvadorseekatzrisquez2947]

2:24 I was wishing you would click on the Clip to see if it any other option such as a Google Sheets instead of just Excel or what other format type there were, or maybe to pull a file from Dropbox, etc.

[@zander9486]

can ai help understand general ledgers in excel for accounting?

[@agentsmith7947]

Yes, just tried it, it's insane, my company is sending us to Texas to get some AI training lmao

[@purplebenisimo]

I wonder if you can ask the AI what questions and insights should a prudent business leader apply to the data? (i.e. ask AI to ask and answer prudent questions and suggest prudent business decisions to be made accordingly )

[@yannkitson116]

This is true, but these functions are better exploited by analysts because they have the knowledge of how to perform analysis and what type of analysis is most appropriate for various cases.

[@timstone869]

Chat GPT is a wonderful tool for somethings, but I for one would not be prepared to upload my very sensitive financial data to anywhere in the "cloud" to anyone for any reason!

[@pablovent8622]

It’s great. I wonder though, about privacy and data governance issues. Here in Europe, we have pretty stringent rules on data protection like GDPR

[@csaladjenei5230]

Hi Kevin! Can You say something about privacy? If I send my company data to ChatGPT, will my data stay forever on ChatGPT servers? I'm not sure I want to give my secret company data to them forever. What You think?

[@carlosa7175]

Question can PQ merger and append 2 files, call them file A and File B and place them on a master file C? But files A and B are cleared and new data is add daily. I saw people doing so for monthly but they had 12 files for each month. I don't want to have 365 files at the end

[@carolb8343]

Thank you Kevin. You are just amazing.

[@maloyaircraft1174]

Is it possible to train a GPT to become familiar with say regulatory requirements? You feed in various amounts of data and then when asking it a question it can respond based on the knowledge you shared with it. For instance 1,000s of pages of scanned regulations

[@c.l4219]

No. Chatgpt has amnesia. It for now does not use any new data, or does not keep on learning. It only uses data from before 2022. And in terms of regulations... It has hard times to answer. I tried and chatgpt failed big time.

[@mukundpandey9083]

Things will go to next level when it cab do things for you in excel like making dashboards, etc

[@alir.9894]

Awesome video! Thanks so much!!

[@nomcebontombela8897]

My goodness this is amazing.

[@blessingeperetun5183]

Damn! Mind blowing About to show my boss some levels

[@Atanepes]

oh wow Kevin Doing great videos again . Thanks for your hardworking for us!!! Super Video I needed

[@ivantrump4022]

Can it make actual changes to the Excel file or just show analytics?

[@SuperMarko.]

Can it do data cleaning? Or can it analyze raw data, data thats not yet cleaned?

[@Saiyajin47621]

You’ll just have to explain to it what is “cleaning” and make some samples for it to know what do you mean and then prompt it to work on it.

[@infinger2006]

Yes, it can clean the data, but it's not perfect. You'll likely need to guide it, but it can pick up on the basics.

[@hikikomorihachiman7491]

That last quote was a banger Kevin!!! “You don’t need to know how to use the tools , you just need to ask the right questions and to make the right decisions.”

[@agoogleuser6937]

For the moment it took me more time the prompt engineering with chatgpt 4 turbo than doing it directly myself. Furthermore, with the same prompts, chatgpt was outputing a different result each time…😢 I hope it improves soon…

[@randeutch7866]

Yes it's incredible so the conclusion is what the video title saying that this tool can replace excel or we are still not there and can only use it as assistant?

[@willkydd]

The conclusion is that clickbaity titles make more money on KZbin.

[@mattyz2385]

It’s great for simple data, would be great self serve for basic request…feed it specific data

[@SD-eu7ht]

What the data size that can be ingested? Where does the data sit? Confidentiality?

[@bhaarpropertiesllc3095]

How secure would your data be ? Ie could third parties get access to the data in the excels ?

[@carljonascords1392]

Can confirm. I threw a sheet with different daily rates for 3 roles in 3 tiers each by staffing companies ( procurement data) . WIth the initial prompt "Which company is the cheapest" and a couple of replies to GPT asking me I arrived at a list cheapest to most expensive on average. WIld.

[@ahmedelkadi4021]

Kevin Hope Every thing is alright , Could you please Explain How can I send or Email using AI or Excel VBA please if you don't mind

[@DeepThinker193]

...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.

[@Cybertruck1000]

AI will communicate it better than a human. I think you are overestimating humans in that respect. It's early days for AI and it moves and improves faster than we can imagine.

[@thisismarkbro]

you don`t need to paid full price anymore

[@distilledgogilba]

It might not replace human analysts per se but it will definitely have an impact on how many analysts it takes to do the same amount of work. If AI tools help reduce the need for technical know-how and allow analysts to do a piece of work 2x-3x as fast, that increases the pool the people who could do analysis AND reduces the number of analysts required, a double whammy when it comes to the job market for analysts.

[@kingwesleyXIV]

​@@thisismarkbro no... I'm not a data analyst... But my prefomance is tied to my pay... If i get paid less than I'm not going to give my best

[@mithunshet5922]

​​​@@distilledgogilbaThere is hell lot of big data to be analysed .. Excel in this era is totally outdated as it hardly handles a million row data .. You need skills to work on cloud, build ETL to automate process and connect to a BI tool which again comes with set of measures to be created, BI has to be optimised to perform stutter free especially on realtime big data.. plus data handling comes with set of security that needs to be handled.. First understand what data analyst do and then think how AI will help in certain tasks.. I use chat gpt to correct my DAX measure or M codes, create customised plots through python, understand business problems if it's out of my domain and many more.. The one showed in video is very basic for industry standards.. Don't get panicked or panic others who are passionate in this area..

[@marksw5499]

Very cool and useful for my data science career

[@KChrisWatching]

So amazing. People/businesses will need to encrypt their spreadsheets. Are we ready for this?

[@TACNERD1]

Amazing, simply amazing!

[@fwy4478]

Great video. Thanks 🙏

[@JFox29]

Kevin - can you do a youtube video/tutorial about access foreign movies/content using VPNs? I have tried to do a search on youtube and for other articles but didn't find one that was easy to follow. Also, can you recommend a TOP paid VPN you would buy? Thanks!

[@steveplyler8077]

Last night I was reviewing companies I could contact to analyze data I receive from small market surveys - now I have an alternative that is less expensive per month - good for me ----however I ponder AI impact on various industries as there are currently many small to large companies EMPLOYING many people who provide data analyzing services. We as an economy are in a dramatic state of change ----- an opportunity? Thanks for a well done video.

[@teeing9355]

Dude just gave all his company's secure information to bigdata and now all his competitors can have access to it for a price. Later, the Cookie Company went belly up.

[@nuevocomienzotampa6052]

Awesome demonstration, thanks

[@zacharytripp2548]

If I am 34 and just now entering into the workforce in business, and my only knowledge is knowing how to navigate in excell well, what use am I to the world of business? What do you recommend someone like me learn, in order to stay marketable?

[@speedymr]

Everything changed today's world. If you are just started learning excel you're way behind it... Sorry, but the truth.

[@ICTNuggets]

Thanks Kevin for making this video. Does the data analysis tool within ChatGPT has the feature of predictive analysis based on the data. I mean can it extrapolate the data to predict future trends? and if yes, is there a way we can integrate this with the web application where data is coming on a regular basis?

[@-Tharos-]

GPT-4 can run any ML algorithm over your data to create predictions. GPT is running python on the backstage, so basically you can clean data, analyse it, and make predictions just like if you were coding it yourself.

[@davidblack1970]

If you upload an Excel file into ChatGPT as highlighted in this video, would you not worry that all the data within the file becomes part of the AI, and therefore part of the whole AI realm? If that's the case, then your data is part of the AI realm, and might be accessible to/by other users.

[@tech6474]

Where do you save your Excel files?

[@velious2121]

Does this mean that sql is dead if we can query a database with a simple, more English friendly chat prompt? I would assume that gpt can even edit data in rows and columns too?

[@BigGuy10Points]

No sql has been available for a long time.

[@speedymr]

@@BigGuy10Points LOL "has been" not anymore. Last 1-2 years everything changed and will change faster. RIP SQL and Excel and Data Analysts and video editors and graphic designers etc.

[@Redmanticore]

@@speedymr it just makes their work faster

[@cloudz83]

This might be a nit pick that gets solved in time...but how does this playout when you have an LLM providing analysis to analysts that dont have the knowlede or skill to independently confirm the results? I wouldn't be comfortable in GPTs current state (far from infallible) using it's analytics features for work or for my other primary use case (investment analysis) without some method to confirm the model is producing verified results.

[@josephilipno9741]

Hi Kevin, I loved the video. Could you help me with an AI that can copy pdf information to an Excel?

[@dmintz2]

How is it really different than the regular chatGPT? because when I do regular data analysis with the regular charge GPT I get excellent results so I was wondering how is this going to be different and better?

[@TenderTums]

Why don't you just watch the video which clearly demonstrates the difference?

[@BEN90_]

To be honest it looks good, but i would save time if i use directly a pivot table and insert a chart, at some point you need to do stuff by yourself and not always rely on AI.. :)

[@imconfused1237]

Exactly. This IS done better with software. And you can save that file too. You can’t save the output from Chat GPT because it doesn’t produce a saveable file.

[@InnocentiusLacrimosa]

Indeed. This can help some total novice, but nothing showed here looks like a time saver, or perhaps those verbal interpretations could be if I write bullet points/hypothesis and ask gpt to elaborate from those.

[@user-yr6xc7gg8q]

Can you make a course on this for using chat gpt for data analyst and scientist

[@utube101x]

I think it's nice that AI is able to read through spreadsheets and derive some meaning, but it's still a far cry from actually working with the data. These tools are still evolving not able to handle complex or dirty data and have limits. It's the same as using AI for any other work, you must be aware of what it knows, ask your questions carefully and double check the results. At the moment the only danger to anyone's job will come from managers who don't understand the job. It's up to you (the data analyst) to make them aware of what you do over what the tool does. Turn it on its head and show how the tool could help you but not replace.

[@BPMa14n]

Yeah once it starts interpreting dirty data and cleaning it up like a good human analyst does but in 10 seconds vrs an hour for a human that will be cool to see

[@kuriousoranj]

can you export the charts to Excel?

[@user-eo7yo8qr8q]

it's sad and here I am learning excel hard this past week

[@graphguy]

This is fine but…. How secure and private? Say I have medical phi data? Or real company data?

[@user-on2xd9cp5d]

you have to have premium subscription for this right?

[@Scalp269]

Is Google AI able to do this in Google Sheets as well ?????? Great Video !!!!!!!!!!!!!!!

[@Asif-Ali92]

Very informative video