YouTube2Text

AI For Data Analysis In 21 Minutes — Transcript

by Tina Huang · 5,098 words · 730 segments · language en · Watch on YouTube

Full transcript

  1. 0:00I learned how to do data analysis with
  2. 0:01AI for you. I guess we can call it vibe
  3. 0:04analyzing. But really though, I took 11
  4. 0:07courses on this topic. What can I say? I
  5. 0:09used to be a data scientist at Meta. I
  6. 0:10love data. I use data every single day.
  7. 0:12I'm going to save you the time and money
  8. 0:14that I spent buying these courses and
  9. 0:15give you the cliffos version of what I
  10. 0:17learned. As per usual, there'll be
  11. 0:19little quizzes throughout this video.
  12. 0:20So, pay attention. All right, let's go.
  13. 0:22A portion of this video is sponsored by
  14. 0:24LTX2. The outline of today's video is
  15. 0:26first I'm going to cover when is it
  16. 0:28useful to use AI for data analysis. Then
  17. 0:31we'll talk about the dig framework for
  18. 0:32how to approach analysis. But of course
  19. 0:34to make it all concrete we need some
  20. 0:36examples. So I'll then be showing you
  21. 0:37lots of examples. And finally I'll
  22. 0:39[music] explain how to take this even
  23. 0:40further and take your data analysis and
  24. 0:42build it out into dashboards or even AI
  25. 0:44applications. [music] I do want to make
  26. 0:45a note that a lot of the courses and
  27. 0:46examples are focused on using chatbt as
  28. 0:49the tool for data analysis. But that is
  29. 0:51not the case that you have to use
  30. 0:52chatbt. In fact, you can switch it off
  31. 0:54at Gemini and Claude would work the same
  32. 0:56way. In fact, sometimes they would
  33. 0:57actually work better. So, don't feel
  34. 0:58like you need to be married to a single
  35. 0:59tool. And I'll actually call out if
  36. 1:01there is a tool that I think would work
  37. 1:03even better. Okay, let's start off with
  38. 1:06when we should be considering using AI
  39. 1:08for data analysis. Well, from the course
  40. 1:10Chachi PT advanced data [music]
  41. 1:11analysis, Dr. Jules White, the
  42. 1:13instructor from Vanderbilt University
  43. 1:15has an acronym for this called achieve.
  44. 1:17He explains that there are five
  45. 1:19different areas that is useful for using
  46. 1:21AI in data analysis. Aiding human
  47. 1:23coordination, cutting out tedious task,
  48. 1:26help provide a safety net for humans,
  49. 1:28inspire better productivity and problem
  50. 1:30solving, and enable great ideas to scale
  51. 1:33faster, achieve. Aiding human
  52. 1:35coordination refers to helping people
  53. 1:37work better with each other because
  54. 1:39people actually tend to be quite messy,
  55. 1:41you know, and there's a lot of
  56. 1:42miscommunications. There's a lot of like
  57. 1:44back and forth between people. So,
  58. 1:46there's a lot of room for improvement
  59. 1:47here that AI can help with. Say, for
  60. 1:49example, you're in a meeting with a
  61. 1:50bunch of people and you have this
  62. 1:51meeting transcript. You can actually put
  63. 1:53it into AI and say, "Actal assistant.
  64. 1:56Read the following meeting transcript
  65. 1:57and provide me a summary of the key
  66. 1:59points of discussion." This is just an
  67. 2:00example. I'm sure you can think of a lot
  68. 2:02of other scenarios where there is a
  69. 2:04bunch of data that can be analyzed such
  70. 2:06that you can provide more clarity for
  71. 2:08humans. The second part of the framework
  72. 2:09is to cut out tedious task. Just as that
  73. 2:12suggests, it's best to let AI to be able
  74. 2:14to do things that are very repetitive
  75. 2:15and boring for people. For example, say
  76. 2:17you're hosting a workshop and you ask
  77. 2:19people to sign up for the workshop and
  78. 2:21provide different types of information
  79. 2:23like what their name is, what their
  80. 2:24occupation is, which department that
  81. 2:26they're in, what their interests are.
  82. 2:27Instead of having to go through this and
  83. 2:29manually analyze it, you can tell the AI
  84. 2:31that this is the list of people that
  85. 2:32registered for my workshop on prompt
  86. 2:34engineering and chatbt. Describe the
  87. 2:36data in this file. By the way, asking AI
  88. 2:38to describe data is is best practices
  89. 2:40which we'll cover a little bit later.
  90. 2:42But yes, so the AI will be like, okay,
  91. 2:44like you know, this file contains this
  92. 2:46type of information. It's a CSV file and
  93. 2:47it contains like timestamp, name, the
  94. 2:49email, the department, um this is a
  95. 2:52university workshop, how they're using
  96. 2:53chatbt and their tools already, the role
  97. 2:55that they hold, etc. You might notice
  98. 2:57that people are filling their department
  99. 2:58names in a lot of different variations.
  100. 3:00So you can actually ask the AI, there
  101. 3:02seems to be a lot of overlap between
  102. 3:03departments with alternate spellings.
  103. 3:05Can you list out all the departments and
  104. 3:06then do some intelligent grouping of
  105. 3:08them? And then you can ask it to create
  106. 3:09a bar chart showing the total number of
  107. 3:11registrations per department. This is
  108. 3:13the kind of data cleaning and
  109. 3:14visualization that is pretty mundane and
  110. 3:16AI is able to do this much more quickly.
  111. 3:19Third part of the framework is to help
  112. 3:20provide a safety net for humans. You see
  113. 3:23people often say like oh AI has a lot of
  114. 3:26hallucinations and that is true. AI does
  115. 3:28hallucinate but people hallucinate too.
  116. 3:31People make a lot of mistakes, like some
  117. 3:33really really dumb mistakes. I make dumb
  118. 3:35mistakes like literally constantly.
  119. 3:36Wrote my name wrong on a form yesterday
  120. 3:38for example. So that is why having AI as
  121. 3:41a backup is actually a really great
  122. 3:43idea. Say for example, you're on a
  123. 3:44business trip and you need to ask for a
  124. 3:46reimbursement. So you need to like
  125. 3:48generate some invoice thingy and then
  126. 3:49make sure you have all the fields
  127. 3:50covered. If you're anything like me, I
  128. 3:52am not very detail- oriented. I probably
  129. 3:54will make a really dumb mistake. So, as
  130. 3:55a safety net, you can actually upload
  131. 3:57this invoice into the AI along with the
  132. 4:00business expense policy and ask read
  133. 4:02each page of the attached business
  134. 4:03expense policy and see if the attached
  135. 4:05receipt complies with it. So many other
  136. 4:07examples of this. Every time you need to
  137. 4:08submit like an insurance claim, you need
  138. 4:10to like read some sort of document uh
  139. 4:12looking at like travel policy whatever
  140. 4:14like yeah so many examples of this. The
  141. 4:16next part of the framework for when to
  142. 4:18use AI for data analysis is the IEV
  143. 4:21which is inspire better problem solving
  144. 4:23and creativity. This is another thing.
  145. 4:25People always feel like AI is going to
  146. 4:27make people less creative and is going
  147. 4:29to take over creative things, but that
  148. 4:31is not the case. It's all about asking
  149. 4:33the right questions. Say, for example,
  150. 4:34you have a PowerPoint presentation that
  151. 4:36is really, really important. You can
  152. 4:37actually upload those slides into AI.
  153. 4:39Ask them to quickly summarize it and
  154. 4:41then ask it to act as a skeptic of
  155. 4:43everything I say in this presentation
  156. 4:45and find flaws, my assumptions,
  157. 4:46assertions, and other key points and
  158. 4:48then generate 10 hard questions for me.
  159. 4:50This is a way for you to actually force
  160. 4:53yourself to think about the questions
  161. 4:54that you could potentially be asked and
  162. 4:56come up with better ways and better
  163. 4:57solutions for answering them. People are
  164. 4:59actually very rigid creatures. We tend
  165. 5:01to think in a very specific way and it's
  166. 5:04very hard for us to actually expand past
  167. 5:06that. So using AI as a tool to help us
  168. 5:08expand our creativity is is actually
  169. 5:10really really helpful. And finally the
  170. 5:12last part of the framework for when you
  171. 5:14should be using AI for data analysis uh
  172. 5:16is the E, which is enable great ideas to
  173. 5:18scale faster. Let's go back to that
  174. 5:20workshop example. You're doing a
  175. 5:22workshop on prompt engineering and you
  176. 5:24have people coming from all types of
  177. 5:25different backgrounds um who are
  178. 5:27interested in all types of different
  179. 5:28things and all types of different
  180. 5:29levels. After you give the AI the signup
  181. 5:31form and analyze all the data about your
  182. 5:33participants, you want to create a cheat
  183. 5:35sheet for each of them that is most
  184. 5:37relevant to them. What you can actually
  185. 5:38do is ask the AI to map each attendee
  186. 5:40with their specific domain of interest
  187. 5:42and then generate a column called ideas
  188. 5:45that includes the corresponding
  189. 5:46idea/prompt
  190. 5:48um to put for their cheat sheet. This
  191. 5:49way now your CSV file for each attendee
  192. 5:52also contains a very specific prompt
  193. 5:54idea that is specific for that attendee.
  194. 5:57And then after the workshop, you can
  195. 5:59actually send them an email with their
  196. 6:00specific little cheat sheet. I'm sure
  197. 6:02you can see prior to AI, this would have
  198. 6:04been so hard to do if you have more than
  199. 6:05just like 10 attendees to be able to
  200. 6:07come up with like a custom cheat sheet
  201. 6:09for each person. So, whenever you're
  202. 6:10thinking about if you should use AI to
  203. 6:12do a certain analysis, you can think
  204. 6:13back to this acronym. Of course, I
  205. 6:15haven't yet covered exactly how it is
  206. 6:17that you should be approached to these
  207. 6:18analysis, which is what I'm going to be
  208. 6:19covering next.
  209. 6:23But first, let's do a little quiz.
  210. 6:25Please put your answers in the comments.
  211. 6:26This portion of the video is sponsored
  212. 6:28by LTX2, the new AI video engine for
  213. 6:30creative workflows. And this one
  214. 6:32honestly blew me away. What stood out to
  215. 6:34me isn't just the quality, it's how LTX2
  216. 6:37can finally tell a story. And if you
  217. 6:39can't guess by my career choice,
  218. 6:41storytelling is is what I live for. Most
  219. 6:43AI video models just give you short
  220. 6:45looping clips. A few seconds that look
  221. 6:47great but don't really say much. LTX2
  222. 6:50though can generate up to 15 seconds of
  223. 6:52continuous video with synchronized audio
  224. 6:54which means full monologues.
  225. 6:56>> Super villains also have feelings.
  226. 6:59>> Dialogues or even short scenes with
  227. 7:02music and natural sounds. [music]
  228. 7:07It's smooth, coherent, and feels
  229. 7:10cinematic. The kind of storytelling
  230. 7:12range that's missing from [music] AI
  231. 7:13video tools. As someone who's been
  232. 7:14creating content for over 5 years now,
  233. 7:17this one really impresses me. You can
  234. 7:18build short narratives, generate B-roll
  235. 7:20and snippets, or even cinematic
  236. 7:22transitions, all with a single prompt.
  237. 7:24You can now try out LTX2 to create your
  238. 7:26own AI videos. The link [music] is in
  239. 7:27the description. Thank you so much LTX2
  240. 7:29for sponsoring this portion of the
  241. 7:30video. Now, back to the video. From the
  242. 7:32course, ChatBT Plus Excel, master data,
  243. 7:34make decisions, and tell stories.
  244. 7:36[music] There is a nice little acronym
  245. 7:38for how it is that you should be
  246. 7:39approaching data analysis [music] using
  247. 7:41AI called DIG, which stands for
  248. 7:44description, introspection, and goal
  249. 7:46setting. By the way, if you do have a
  250. 7:47little bit of background in data, like
  251. 7:49data science or data analysis, um it's
  252. 7:51basically the same as EDA, exploratory
  253. 7:53data analysis, but specifically for
  254. 7:55using AI. The first step of dig, which
  255. 7:57is describe, it's a way for you and the
  256. 7:59AI to explore the data together. [music]
  257. 8:01This step is very important because it
  258. 8:02helps both you and AI gain a familiarity
  259. 8:04for the data and to also notice if
  260. 8:06there's any issues with that data. This
  261. 8:08is going to help a lot with
  262. 8:09hallucinations and issues [music] down
  263. 8:11the road. So very similar to normal EDA
  264. 8:13processes, after you upload like a
  265. 8:15spreadsheet or whatever data it is that
  266. 8:17[music] you give to the AI, like let's
  267. 8:19just say like a spreadsheet in this
  268. 8:20case, you would ask the AI to list out
  269. 8:22the columns in the attached spreadsheet
  270. 8:24and show me a sample of the data in each
  271. 8:26column. For example, if your spreadsheet
  272. 8:28contains data about different roles um
  273. 8:30and different salaries, [music] the AI
  274. 8:32would be able to output and say, "Here
  275. 8:34are the columns for your spreadsheet
  276. 8:35along with a sample of the data for each
  277. 8:36[music] column." So the column name you
  278. 8:38could have like salary ID, job ID, max
  279. 8:40salary, med salary which is median
  280. 8:43salary, min salary, pay period, currency
  281. 8:45and compensation type. You can already
  282. 8:47notice that under max salary and min
  283. 8:49salary you have nan which is not
  284. 8:51available. This is important to note
  285. 8:52because hallucinations tend to happen
  286. 8:54when you have things like missing data
  287. 8:55or incorrectly formatted data. So if you
  288. 8:58see something like this, the first thing
  289. 8:59you actually want to do is to confirm
  290. 9:01that is it just that DAI [music] is not
  291. 9:03parsing your data correctly. So you
  292. 9:04actually want to go in and see like is
  293. 9:06it actually not available or is there
  294. 9:08like a parsing problem? And if there
  295. 9:09actually is a parsing problem, you want
  296. 9:11to then tell the AI, hey, you are
  297. 9:13parsing this incorrectly. This is
  298. 9:14actually how you should be parsing it.
  299. 9:16Or maybe the data is just not available.
  300. 9:17Then you just want to make a note of
  301. 9:19this for the future. We will get back to
  302. 9:21that. [music] But first, you actually
  303. 9:22want to do a few more random samples.
  304. 9:24Just ask your AI like take a couple more
  305. 9:26random samples of the data for each
  306. 9:28column. Make sure you understand the
  307. 9:29format and type of information in each
  308. 9:30column. What we're basically doing here
  309. 9:32is verifying that the data is being
  310. 9:34parsed correctly and the AI has correct
  311. 9:37understanding of each of these columns.
  312. 9:39You can even ask it what do you think
  313. 9:41each of these columns represent and it
  314. 9:42might tell you that salary ID appears to
  315. 9:44be a unique identifier for each entry.
  316. 9:46Job ID is likely unique identifier for
  317. 9:48jobs or position max salary, min salary
  318. 9:49and med salary not all entries have
  319. 9:51complete salary data etc etc. So this is
  320. 9:53a way for you to validate that the AI
  321. 9:55understands what's happening also that
  322. 9:57you understand what's happening. The
  323. 9:58best way to think about this is that
  324. 9:59your AI is a very competent but still
  325. 10:01very junior developer or data scientist
  326. 10:03or data analyst. So you need to make
  327. 10:04sure it understands what is the data
  328. 10:06that it's actually receiving. Otherwise
  329. 10:07any analysis that you do on top of this
  330. 10:09could potentially be wrong. So after you
  331. 10:11do this, you want to move on to the next
  332. 10:12step of the dig framework which is
  333. 10:13introspection. This is when you want the
  334. 10:15AI to start looking at the data that it
  335. 10:18finished describing [music] and think
  336. 10:19about the patterns and relationships
  337. 10:20that exist in the data. This is also
  338. 10:22another great way to catch any
  339. 10:24misconceptions that the AI may have.
  340. 10:26Notices were just being like very
  341. 10:27skeptical all the time. Very important.
  342. 10:29You can just ask tell me some
  343. 10:30interesting questions that could be
  344. 10:31answered with this data set and why they
  345. 10:33would be interesting. And it might come
  346. 10:34with some questions like is there a
  347. 10:36relationship between compensation type
  348. 10:37for example base salary and variability
  349. 10:39in salary ranges. It's saying why it's
  350. 10:41interesting is that understanding
  351. 10:42whether certain compensation types like
  352. 10:44bonuses or equity are more likely
  353. 10:46associated with higher salary ranges can
  354. 10:47help employees and employers make more
  355. 10:49informed decisions about how they
  356. 10:50structure pay packages. Here's a
  357. 10:52question that came up with that could be
  358. 10:54a red flag. The question is, are there
  359. 10:55any noticeable patterns in salary data
  360. 10:57for different currencies if additional
  361. 10:58currencies exist? So, when you see this,
  362. 11:00you want to think to yourself, oh, like,
  363. 11:01is there actually other currencies that
  364. 11:03exist? And you might want to double
  365. 11:04check yourself to see if if there's
  366. 11:06actually data that is not USD. In this
  367. 11:08case, there actually are no other
  368. 11:09currencies. So, that's when you want to
  369. 11:11tell the AI all currencies are actually
  370. 11:13listed in USD. [music] So, it knows that
  371. 11:15information moving forward. If you catch
  372. 11:16your AI asking questions like these or
  373. 11:18you're catch your AI like asking
  374. 11:20questions that you know cannot be
  375. 11:22answered by the data set and ask you to
  376. 11:24generate some more questions that can be
  377. 11:25answered from the data set. In this way
  378. 11:27you're really helping the AI and
  379. 11:28yourself make sure that you really
  380. 11:30understand what's happening in the data
  381. 11:31set. It's also actually quite a good
  382. 11:33exercise because sometimes AI will come
  383. 11:34up with different things and different
  384. 11:36analyses that you might have not have
  385. 11:37thought of doing. I know this might seem
  386. 11:39a little tedious and you just want to
  387. 11:40skip to like making graphs and charts
  388. 11:41and doing analysis, right? But do not
  389. 11:43skip [music] these steps, okay? Trust
  390. 11:44me. Because like that's the thing with
  391. 11:46data. It's one of those things where if
  392. 11:48you mess up, it will just propagate
  393. 11:49throughout your entire analysis. So it
  394. 11:51is really worth the effort to actually
  395. 11:52make sure that everything is understood
  396. 11:54correctly. And this is actually the same
  397. 11:56with humans too. It's not like an AI
  398. 11:57problem. Even when I was a data
  399. 11:59scientist, [music] I spent a significant
  400. 12:01amount of time doing exploratory data
  401. 12:02analysis, making sure that I understood
  402. 12:04exactly what was happening in data and
  403. 12:05clarifying all that information as well
  404. 12:07because I knew if I just like rush into
  405. 12:10things, I'll probably end up making a
  406. 12:11mistake and be very embarrassed when
  407. 12:13someone catches my mistake or worst case
  408. 12:14scenario get fired because I made a
  409. 12:16really dumb mistake and then, you know,
  410. 12:17lost the company a lot of money or
  411. 12:18something like that. Anyways, so after
  412. 12:20you do this, the third step of the
  413. 12:21[music] framework is goal setting. It's
  414. 12:23very important that your AI understands
  415. 12:24what it is that you're trying to
  416. 12:26achieve. Like if you just went like
  417. 12:27analyze this data, your AI is going to
  418. 12:29be like what what the heck like you know
  419. 12:30what does that even mean? What am I
  420. 12:31supposed to analyze? What's the result?
  421. 12:33So it's the same. You got to be like
  422. 12:34very clear about what the goal actually
  423. 12:35[music] is. So you could tell the AI, my
  424. 12:38goal is to answer a couple of these
  425. 12:39questions, the questions that you know
  426. 12:41it it [music] generated previously and
  427. 12:43turn them into a really exciting
  428. 12:44interesting report to post on LinkedIn.
  429. 12:46This really helps provide context
  430. 12:48because then your AI is able to do this
  431. 12:50analysis and then is able to do things
  432. 12:52like give you LinkedIn ideas how it is
  433. 12:54that you can put it together [music] in
  434. 12:55the form of LinkedIn. This is going to
  435. 12:56be very different if you were actually
  436. 12:58analyzing this data [music]
  437. 13:00in order to, you know, like do something
  438. 13:02very serious like generate like a report
  439. 13:03for your boss. This is also just part of
  440. 13:05good prompt engineering practices. So,
  441. 13:07if you do feel like you want to brush up
  442. 13:09your prompt engineering a little bit to
  443. 13:10be able to be more clear about what it
  444. 13:12is that you want, I do recommend that
  445. 13:13you check out a video that I have over
  446. 13:14here which covers the foundations of how
  447. 13:16to do good prompt engineering. So, check
  448. 13:17it out over here. Anyways, whenever you
  449. 13:19have a data set that you want AI to help
  450. 13:20you analyze, it would be really helpful
  451. 13:22for you to go through this dig
  452. 13:24framework. It is a really great
  453. 13:25foundation and you can build on top of
  454. 13:26this as well. [music] Now all the stuff
  455. 13:28that we talked about earlier uh is
  456. 13:30pretty standard for if you're doing any
  457. 13:31type of data analysis using like Excel,
  458. 13:34Python, SQL or whatever. It's just like
  459. 13:36maybe more convenient doing in a
  460. 13:37conversational fashion with AI. But
  461. 13:39there are certain things that you can do
  462. 13:40with AI that would be extremely
  463. 13:42difficult for you to do just using these
  464. 13:44traditional tools. Like for example, if
  465. 13:45you're job hunting right now and you
  466. 13:47have access to this data set, you could
  467. 13:48be thinking like, oh, like I'm looking
  468. 13:50for a job that is between like 50 to
  469. 13:52$80,000 based on the East Coast and
  470. 13:55specifically works with [music] wood. I
  471. 13:58don't know, something like that, right?
  472. 13:59So in this data, there is no specific
  473. 14:02section that's like works with
  474. 14:03wood/notwork with wood, you know, or
  475. 14:05[music] like materials that you're
  476. 14:06working with. And it also doesn't
  477. 14:08specify like is it east coast or west
  478. 14:09coast. It's just like the location like
  479. 14:11Chicago, [music] right? But because of
  480. 14:12Genai's capabilities, you're able to
  481. 14:14like filter through this data um in a
  482. 14:17way that's far more intelligent to be
  483. 14:19able to find the rules [music] that you
  484. 14:21could be potentially interested in. This
  485. 14:23would be so hard to do if you didn't
  486. 14:24have Genai. And later on in the video, I
  487. 14:26have a lot more examples which I'll show
  488. 14:28you uh like Genai specific really cool
  489. 14:31data analysis things that you can do.
  490. 14:32There's also one more thing that I
  491. 14:33thought was really cool in this module
  492. 14:35of the course, which is the idea of
  493. 14:36traceability and replication. I thought
  494. 14:38this was like super clever because a
  495. 14:40major issue that people face when doing
  496. 14:42traditional data analysis is that they
  497. 14:44would like come up with some sort of
  498. 14:46thing and then it would be stuck in like
  499. 14:47a Jupyter notebook or like whatever and
  500. 14:49it would actually be very difficult for
  501. 14:51other people to reproduce that analysis.
  502. 14:52[music] But with AI, you can actually
  503. 14:54ask AI to come up with a traceability
  504. 14:56document that allows other people to be
  505. 14:58able to perform the same analysis to
  506. 15:00validate the results. You [music] can
  507. 15:02ask let's create a traceability document
  508. 15:04to make sure that others can one know
  509. 15:05what data was used two how the analysis
  510. 15:08was performed and three threats to
  511. 15:09validity. We want a guide for someone
  512. 15:11else to be able to replicate and know
  513. 15:13the limitations of the analysis. You can
  514. 15:15you can save this traceability
  515. 15:16information as like a readme.md. Uh
  516. 15:18don't worry if you don't know what that
  517. 15:19is. It's just very common for software
  518. 15:21engineers to be able to store it this
  519. 15:23way but you can kind of store it like a
  520. 15:24word document whatever doesn't actually
  521. 15:26matter. And then for each analysis and
  522. 15:27visualization, you can actually ask it
  523. 15:29to write a [music] single Python script
  524. 15:31that performs the full analysis to
  525. 15:33produce the visualization and the
  526. 15:34results. I think it's a really really
  527. 15:35clever idea and really smart thing to do
  528. 15:37if you're doing any type of data
  529. 15:39analysis using AI.
  530. 15:42All right, time for our next little
  531. 15:43quiz. Please answer the questions on
  532. 15:45screen in the comments. Yay. Okay, we
  533. 15:48can move on to some examples. I'm really
  534. 15:50excited for this section. First example
  535. 15:52is super simple but is actually really
  536. 15:53helpful is it's pretty much like any
  537. 15:56type of small document you can just
  538. 15:58directly upload do dig on it and then
  539. 16:00have it proceed to analyze that
  540. 16:02information and transform it in whatever
  541. 16:03way like if you have structure data like
  542. 16:05say you have a CSV form that has like
  543. 16:07all the different types of inventory
  544. 16:08throughout the past few months you can
  545. 16:10ask it to filter it for different types
  546. 16:11of inventories you can ask it what are
  547. 16:13the trends in the inventories over time
  548. 16:15are there certain items that are
  549. 16:16becoming more popular certain items that
  550. 16:18are becoming less popular maybe you want
  551. 16:19to like remove those if there's too much
  552. 16:21of that in the inventory. You can even
  553. 16:22ask to come up with a predictive model
  554. 16:24to see what are the inventories that you
  555. 16:26should be stocking for the next few
  556. 16:27months so that you're able to optimize
  557. 16:29[music] the amount of inventory so you
  558. 16:31don't have too much and you also don't
  559. 16:32have too little. You can also do
  560. 16:33visualizations both static
  561. 16:35visualizations. You might want to make a
  562. 16:36bar [music] chart that's ranking all the
  563. 16:38different types of inventory that you
  564. 16:39have. You might want to make a time
  565. 16:40series graph over time. What are the
  566. 16:42changes inventory? And you can also make
  567. 16:44dashboards as well, interactive
  568. 16:45dashboards. for this specific one. Cloud
  569. 16:47as of [music] the filming of this video
  570. 16:49um is a lot better than the other models
  571. 16:51to create interactive dashboards. It
  572. 16:53also usually is the best at writing the
  573. 16:55code as well in order to do the analysis
  574. 16:57and it tends to hallucinate less. Again,
  575. 16:59this is at the time of this filming,
  576. 17:00[music] so I don't know if this is going
  577. 17:01to change in the future, but just FYI,
  578. 17:03AI data analysis with different media
  579. 17:05forms is also a really cool application.
  580. 17:07For example, you can have like a video
  581. 17:08and you can ask it to extract 10 [music]
  582. 17:10frames from this video evenly spaced out
  583. 17:12from 1 second apart. Then you can ask it
  584. 17:14to take these images, resize the images,
  585. 17:16make it like 300 pixels wide and say
  586. 17:18convert it to grayscale and increase
  587. 17:20contrast by 30%. You can ask it to do
  588. 17:22things like combining the images to
  589. 17:24animated GIFs that flip the to the next
  590. 17:27image at 1second intervals. You can ask
  591. 17:28you to turn the images into PowerPoint
  592. 17:30presentations and then catalog all of
  593. 17:32the images into a CSV file with the name
  594. 17:35of the image and the name of the movie
  595. 17:36file that the image was extracted from
  596. 17:38and the operations applied to it. So
  597. 17:39really really cool that you can
  598. 17:41manipulate uh multimedia using AI. Prior
  599. 17:44to AI, this would have been so difficult
  600. 17:46to do. Another example of data analysis
  601. 17:48using AI is by automating things using
  602. 17:50zip files. Zip files are very, very
  603. 17:52convenient and they're amazing because
  604. 17:54not only are you able to put a lot of
  605. 17:56different files into a single zip file,
  606. 17:58you're also able to maintain folder
  607. 18:00hierarchy in the zip files themselves,
  608. 18:02which means that you can actually zip
  609. 18:04together a bunch of different files
  610. 18:05together and ask the AI to mass analyze
  611. 18:08them all together. So you can have
  612. 18:09multiple Excel files that you're telling
  613. 18:10it to combine and search and do whatever
  614. 18:12with it. Then afterwards, you can build
  615. 18:14all back together and then send it back
  616. 18:16to you. Also, Grave, if you need help
  617. 18:17organizing different files, you can ask
  618. 18:19the AI, one, I want you to help figure
  619. 18:21out what is in them by opening and
  620. 18:22reading each one to create a summary.
  621. 18:24Two, I want you to propose a folder
  622. 18:26structure that would better organize the
  623. 18:27files. Three, I want you to propose
  624. 18:28better naming for each file using just A
  625. 18:30to Z and 0 to9, keeping the extensions.
  626. 18:33And four, when you have all of this
  627. 18:34done, show me your proposed folder
  628. 18:35structure and name. Then it's going to
  629. 18:37do that. And then finally, once you're
  630. 18:38happy with it, you can ask her to zip
  631. 18:40everything up again and then send it
  632. 18:41back to you and and voila, everything is
  633. 18:43well organized and beautiful. And the
  634. 18:44final example I'm going to show from the
  635. 18:46course is a little bit more advanced,
  636. 18:47but so cool. This is when you can
  637. 18:49actually turn conversations into
  638. 18:52software programs. Let me explain. So,
  639. 18:54say for example, you have like a
  640. 18:55sequence of analyses that you did,
  641. 18:56right? Like for example, maybe you have
  642. 18:57like some sort of movie and then you ask
  643. 18:59it to get like 10 frames from this movie
  644. 19:01spaced 1 second apart. uh maximized it,
  645. 19:04I don't know, like did some photo
  646. 19:06manipulations on it um and then combine
  647. 19:08them together and then generate some
  648. 19:10descriptions for it and then put them
  649. 19:11all together into a CSV [music] file.
  650. 19:13You can then ask the AI, turn this
  651. 19:16process into a Python program that I can
  652. 19:18download and run on my computer and
  653. 19:20provide the path to the documents as
  654. 19:22command line arguments. Zip up the
  655. 19:24program for me to download and then it
  656. 19:26can literally go and actually like write
  657. 19:28a script that performs all of [music]
  658. 19:30these different steps and then put them
  659. 19:32all together in an executable program.
  660. 19:35That is so cool. You can literally do
  661. 19:37this for any sequence of analyses that
  662. 19:40you do. You can just like automate it
  663. 19:41like that. At least for me, that blows
  664. 19:44my mind. That is so cool.
  665. 19:48[music] All right. All right. I can
  666. 19:49literally go on forever, but I'm gonna
  667. 19:50stop for this section for now and I'm
  668. 19:53going to put the next little quiz onto
  669. 19:55the screen. Please answer these
  670. 19:56questions and put them in the comments.
  671. 19:58Okay. So, I wanted to include this final
  672. 20:00section because I wanted to make sure
  673. 20:02that you understand that just doing the
  674. 20:04analysis using AI, you don't need to
  675. 20:06stop there. There's actually so much
  676. 20:07more that you can you can do on top of
  677. 20:09that. From the examples that we already
  678. 20:11seen, we [music] can take this data
  679. 20:12analysis and then use it to generate
  680. 20:14emails, use it to make like social
  681. 20:16posts, use it to generate reports,
  682. 20:18PowerPoint slides, even build software
  683. 20:20programs and dashboards. But that's not
  684. 20:22all. You can even build full-on
  685. 20:24applications based upon these analyses.
  686. 20:26And no, you don't actually need to know
  687. 20:28how to code. You can just use pipe
  688. 20:29coding. Say you've analyzed a lot of
  689. 20:31traffic data. You can actually make this
  690. 20:32into an application that analyzes
  691. 20:34real-time traffic data and then like I
  692. 20:37don't know gives alerts to people. uh
  693. 20:39where generates reports based upon
  694. 20:40traffic incidents. You can have
  695. 20:42application that's able to take videos
  696. 20:44and blur out people's faces or like
  697. 20:46different identifications within the
  698. 20:48video. Here's an example of an
  699. 20:49investment research AI agent uh that
  700. 20:51people who join our AI agents boot camp
  701. 20:53will build that has an entire database
  702. 20:55with information about investments and
  703. 20:58it has this interface where the user is
  704. 21:00able to ask it specific questions and it
  705. 21:02will analyze that data to generate
  706. 21:04certain types of responses,
  707. 21:05conversations and reports. Yeah, there
  708. 21:07is so much that you can do. Data truly
  709. 21:09is power and being able to analyze and
  710. 21:11harness that power by using AI just
  711. 21:14opens up so many possibilities. All
  712. 21:16right, [music] I'm going to stop here.
  713. 21:17If you do want to dive into how to
  714. 21:19actually build out these like
  715. 21:20applications, agents, and things like
  716. 21:21that, I'll link a few videos in the
  717. 21:22description that you can check out that
  718. 21:24goes into a lot more detail about how to
  719. 21:25do this. But for this video, I'm going
  720. 21:27[music] to end it for now. I really hope
  721. 21:28that this was a very helpful video for
  722. 21:30you and you have lots of ideas for how
  723. 21:32to analyze your data now using [music]
  724. 21:34AI. Vibe data analysis. As promised,
  725. 21:37here is the final little assessment.
  726. 21:39Please answer the questions on screen
  727. 21:40and put them into the comments. Thank
  728. 21:42you so much for watching until the end
  729. 21:44of this video and I will see you in the
  730. 21:45next video or live stream.

About this transcript

This page contains the full transcript of AI For Data Analysis In 21 Minutes by Tina Huang, generated from the public captions YouTube serves with the video. The transcript has 5,098 words across 730 segments, with the original timestamps preserved so you can click any line to jump to that moment in the embedded player.

What you can do with it

Use the transcript to take notes, quote the speaker, build a study guide, generate a summary with ChatGPT or Claude via the YouTube Summary tool, or export it as a timed subtitle file with YouTube to SRT. You can also re-open it in the transcriber to translate the transcript into 100+ languages.

Free YouTube transcript tool

YouTube2Text is a free YouTube transcript generator — no signup, no daily limit. Paste any YouTube link and get the full transcript instantly, with timestamps, click-to-jump, translation to 100+ languages, AI prompts for ChatGPT, Claude, and Gemini, and exports to TXT, SRT, VTT, or Markdown.