How I use Excel as a Data Analyst
Рет қаралды 450,617
Күн бұрынA better solution than Excel for SaaS team (ChartMogul) 👉🏼 lukeb.co/ChartMogul
Follow the Data 👸🏻 & 🤴🏻 @TinaHuang1 @KenJee_ds
📊 My recommended course for Excel 👉🏼 lukeb.co/ExcelBusinessAnalyst
Certificates & Courses
==================================
Coursera Courses:
📜 Google Data Analytics Certificate (START HERE) 👉🏼 lukeb.co/GoogleCert
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
Coursera Plus Subscription (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
DataCamp Courses:
🐍 Python 👉🏼 lukeb.co/PythonBasicsDataCamp
📈 Power BI 👉🏼 lukeb.co/PowerBIDataCamp
📊 Tableau 👉🏼 lukeb.co/TableauDataCamp
🏴☠️ R 👉🏼 lukeb.co/RDataCamp
🐍 Data Analyst w/ Python 👉🏼 lukeb.co/PythonAnalystDataCamp
DataCamp Subscription (Monthly $25USD) 👉🏼 lukeb.co/DataCampSub
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Build a Portfolio Online
==================================
👩🏻💻Build portfolio here 👉🏼 hostinger.com/luke
Rebate Code: "LUKE"
My Portfolio 👉🏼 lukebarousse.tech/
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Science Must Read 👉🏼 geni.us/StorytellingWithData
📙 Tableau 👉🏼 geni.us/tableau
📘 Power BI👉🏼 geni.us/powerbi
📕 Python 👉🏼 geni.us/pythontricks
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows on a Mac (Parallels VM) 👉🏼 lukeb.co/ParallelsFreeTrial
👨🏼💻 M1 Macbook Air (Mac of choice) 👉🏼 geni.us/M1macAir8GB
💻 Dell XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 geni.us/AsusVivoBook15
💻Lenovo IdeaPad (Best Value PC)👉🏼 geni.us/LenovoIdeaPad15
Social Media / Contact Me
======================
🙋🏼♂️Newsletter: www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: luke@lukebarousse.com
As a member of the Amazon, Coursera, Hostinger, Parallels, Interview Query, and Data Camp Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
00:00 Intro
01:46 Spreadsheets
03:39 VBA
06:04 PowerQuery
09:16 PowerPivot
#datanerd #dataanalyst #datascience
@LukeBarousse 2 жыл бұрын
Data Nerds!! Shoutout to ChartMogul for sponsoring this video!! Help support this channel by checking them out here 👉🏼 lukeb.co/ChartMogul Also, thank you Tina and Ken for your help with this video!! 🙌🏼
@direct.skc.2 2 жыл бұрын
Would definitely check it out, any trial offers?
@LukeBarousse 2 жыл бұрын
@@direct.skc.2 Yeah, actually you can track up to $10k in MRR for free; so it's a good option to try it out
@Mareeyaaaaa 2 жыл бұрын
I personally took this Excel course in Coursera and I absolutely love it! This course introduced me to Power Query and building an interactive dashboard. I applied all the skills I’ve learnt into my current role and created a wow moment to my boss. I created an automated interactive dashboard and with just a single click on the refresh button, all the data is automatically updated. Highly recommend for someone looking to improve excel skills. I am hoping there will be another course released soon!
@LukeBarousse 2 жыл бұрын
Heck yeah! This is awesome to hear Maria, thanks for sharing your experience with the course!
@bicyclekikz14 Жыл бұрын
course link?
@itdataandprocessanalysis3202 Жыл бұрын
@@bicyclekikz14 is in the description
@itdataandprocessanalysis3202 Жыл бұрын
Did you take the Excel course on a Mac? I would love to hear if it is suitable for Mac Users as well.
@Mareeyaaaaa Жыл бұрын
@@itdataandprocessanalysis3202 Hi, I used Mac but I had to install boot camp to use Excel windows version as Mac version doesn't support PowerQuery
@1197kendall 2 жыл бұрын
HI Luke, I wanted to thank you. I come from an Education Background and I make a carreer shift. Your videos inpired me to become a Data Analyst. And a week ago I starded my first job as a Finance Analyst at Citi. This has been a long year and half Journey but I made it happen. Than you so much for all your tips and advice. Gretting from Costa Rica. Keep good content coming : )
@LukeBarousse 2 жыл бұрын
Hey Kendall! 👋🏼 This is so awesome to hear, thank you for writing to let me know this! So glad my videos inspired you for this, this achievement is nothing short of your hard work. Congrats again and keep up the studies! 🙌🏼
@Chanchan-gz4kr Жыл бұрын
I am also starting to learn my way to become a Data Analyst. I hope these hard works will someday make me to become one. Anyways, Congrats on your career.
@ricardohernandez5046 Жыл бұрын
Hello!! I have an education background too and want to transition into data analytics. Would you like to connect on LinkedIn?!
@dhawalgore9338 11 ай бұрын
@@LukeBarousse❤
@KenJee_ds 2 жыл бұрын
LUUUUUKKKEEE. Great video bud. Can you re-do it completely for Vimeo though?
@LukeBarousse 2 жыл бұрын
🙄 Yes Mr. Jee… 😪
@Quantumvp 2 жыл бұрын
Lol 🤣
@lindadelalisey5408 Жыл бұрын
😂😂😂😂😂
@eltoski01 Жыл бұрын
🤣🤣
@saltesc 2 жыл бұрын
I feel this. I was hired as a Workforce Analyst and the past 6 months have just been migrating everything into Power BI because I made a BI report. Now life is data wrangling, cleaning with queries, and mooshing so many data source together into different reports for different departments...
@LukeBarousse 2 жыл бұрын
The skits are all too real...
@raghunandanr3979 2 жыл бұрын
I'm taking notes for every videos, Luke. You are like my mentor. Love to see your videos every week. Your videos are impressive. Love you!
@LukeBarousse 2 жыл бұрын
Heck yeah! Thank you so much for tuning in Raghunandan!
@aliaziz1145 Жыл бұрын
This video deserves at least 2 mil views. High production value and fantastically edited! Great job!
@komanguy 2 жыл бұрын
I followed a similar path. As a business analyst in a bank, my main tool to deal with huge amounts of data was excel. Processing files with almost a million rows per sheet was a daily routine. Vlookup here, sumifs there and you got your aggregations done. But it was cumbersome. Later, I wrote some vba macros in ms access to do all the dirty stuff of cleaning data, aggregating the data and exporting it into csv before doing analysis in excel. That was better but not optimal. One day, I was wondering if it was possible to overcome the 1 million rows limitation in excel, because I needed to create a new particular dashboard. I did some research and found powerpivot! Wow! That was the discovery of the century. It was so easy now to embed all the data in one file and do all the calculations there! Dax is so powerful. But again, archiving piles of data became tedious, so I learn how to use databases especially sql server. I created a data warehouse and linked all my excel to that database. Learned powerquery. The new challenge was to feed the warehouse daily: vba macros and tsql. Once you use power query and powerpivot, adopting power bi is just natural. Using excel can push you to learn lots of useful things but this app is so powerful that it’s difficult to drop it totally for other tools.
@LukeBarousse 2 жыл бұрын
Heck yeah, thanks for sharing this journey!
@IvoryGoonz 2 жыл бұрын
If you learned to store your Ms access tables in SQL and export only pivots that need graphs you’re done. As for excel have a look at Index function. Saw a functioning multiyears, multi clients financial dashboard working perfect with that instead of vlookup. Vlookup is fine for punctual replacement but doesn’t replace 2 mismatch queries and 2 joins.
@komanguy 2 жыл бұрын
@@IvoryGoonz exactly! Index with match is much more powerful.
@user-fb3iy1wh9v Жыл бұрын
@@komanguy , xlookup wants to have a chat with you!
@komanguy Жыл бұрын
@@user-fb3iy1wh9v xlookup didn’t exist at that time.
@chuchuabe1723 Жыл бұрын
Love to see all data nerds together. Thank you Luke. Your videos are inspiring!
@928khaled 2 жыл бұрын
The best crossover ! again a wonderful video, seeing you guys cheer me up all the time, the video is not only informative, but its also fun to watch! , keep it up Luke ! The BI Analyst joke at the end is HILARIOUS!
@LukeBarousse 2 жыл бұрын
Ha! Glad you enjoyed the collab. This was such a fun video to shoot with Tina and Ken! 🙌🏼
@dmitry5233 Жыл бұрын
This guy really knows what he's talking about. Kudos to you Mr. Luke Barousse! You've been an inspiration not just to me but to many aspiring Data Analyst out there.
@jaemms2957 2 жыл бұрын
I loved this Video plus the collaboration with Tina and Ken, Very insightful and it's always great to see what you all do for the data community. I was just thinking of upping my Excel Skills, the coursera course you highlighted will surely do the trick. Thanks
@LukeBarousse 2 жыл бұрын
Glad you enjoyed it, it was fun to collaborate with them! Good luck with the excel studies!
@moisesadames9668 2 жыл бұрын
Great video! It was very interesting since Excel is normally not talked about enough in the DA/DS world, given there are other tools to use instead. Loved the collab! Also, keep up the good work!
@LukeBarousse 2 жыл бұрын
Thanks for this Moisés! I loved the collab too, so fun hanging with these two!
@nurtihani3953 2 жыл бұрын
I just got started with Data Analysis recently. I have no background in programming so I’m learning a lot from online resources among them are Luke’s videos. Such a lucky time to live in terms of skills sharing for people with the access to the internet.
@LukeBarousse 2 жыл бұрын
So true of being lucky to live in these times!! Good luck in your journey Nur!
@katiam.6615 Жыл бұрын
What online sources did/are using for becoming a Data Analyst?
@serahannamathew2111 Жыл бұрын
Can you share your journey with us?? I am interested in this field and like you, have no background in programming.
@milner267 2 жыл бұрын
Wow! This video was amazing! I've always wondered what a data analyst does, and the way you broke it down was as simple as could be. Especially enjoyed the way you'd "bosses" came in with certai requests/demands which further emphasizes situations that you are put into. This was a great one? Thanks again Luke, and looking forward to more of your content!😃
@LukeBarousse 2 жыл бұрын
Aw thank you so much for this and so glad it could help you with understanding this tool! More content to come!
@milner267 2 жыл бұрын
@@LukeBarousse I've realized that Data analytics would be very helpful in the construction industry, as it pertains to planning and project controls. The way you've been able to illustrate how useful VBA and query functions can be for regular reporting tasks, it almost motivates me toward learning those functions as well. Any recommendations where I can begin, with VBA?
@LukeBarousse 2 жыл бұрын
@@milner267 Yeah the course I recommend in this video is a good start, link in description. Also this book is a good resource and is how I learned it: kit.co/lukebarousse/book-recommendations/excel-basics-to-blac
@elmago1298 2 жыл бұрын
LOVE the collab with Ken and Tina!! Great video!
@caneman707 2 жыл бұрын
You pretty summed up my daily work and my bosses! May the force be with you Luke. Great video!
@LukeBarousse 2 жыл бұрын
Ha! Glad you can relate, these were all based on real life scenarios! 🤣
@godsfavoritedaughter1795 2 жыл бұрын
The video is quite engaging and informative. Thank you Luke, I really look up to y'all, Tina, Ken and the rest of the data family 🤗❣️. Keep doing what you know how to do best😌💪🏾.
@LukeBarousse 2 жыл бұрын
Aw thank you so much for this Ada! So fun making this video with Tina and Ken and glad you enjoyed it!
@nelsona1879 2 жыл бұрын
Hey Luke, I just subscribed to your channel and I’m also a Navy Veteran. Really enjoy your videos. It is helping me to look into becoming a Data analyst. I am soon going to transition from working in the Oil and Gas field to a Tech field. Going to take the Google Data Analytics course soon through Hiring our Hero’s. Will continue to watch your content.
@LukeBarousse 2 жыл бұрын
Heck yeah! Always glad to have a fellow Navy vet following along with my content! 🙌🏼 Good luck with the Google Certificate and let me know if you have any questions along the way!
@txreal2 2 жыл бұрын
Hey Nelson, I had the same path- Navy MM CV63, O&G, and currently Data Analyst. Good luck. Btw. doing Capstone on Google Data Analytics. Don’t give up. Full speed ahead.
@txreal2 2 жыл бұрын
@@LukeBarousse Glad you talked more about Data model Pivot, M and DAX. That’s how I’ve sticked more with Power BI in the last two years. It’s quick and easy for a small data especially if you used Excel.
@nelsona1879 2 жыл бұрын
@@txreal2 Thanks for the encouragement, and can’t wait to get started. I was a EN LSD42 and CVN76. I am hopeful to start this week on the course. Started watching Luke’s content last week. Very cool stuff.
@victorbegnini5754 8 ай бұрын
Man, it’s fantastic the funny ways you put things up on KZfaq channel 😂 Always a pleasure to watch. Thanks for that! 🎉
@LukeBarousse 8 ай бұрын
Glad you enjoyed it! 🙌
@benmatt8940 Жыл бұрын
I like how united you are as data nerds!
@GUARIVERA81 2 жыл бұрын
One of my fav videos yet. For my first data analyst role they only use excel but this video helped me look beyond what I am doing now.
@LukeBarousse 2 жыл бұрын
Glad it was helpful, Pito; and thanks for the kind words!
@anna-878 2 жыл бұрын
Love your videos Luke! I am more a Tableau/Python/SQL girl, and left Excel long time ago and never used Power Queries - now at least I know what they are :D Thanks and make more of them:)
@YlmazDALKIRANscallion 2 жыл бұрын
Ms. Dyderska, Tableau is easy to learn compare to BI and it has a language like DAX?
@LukeBarousse 2 жыл бұрын
Glad you enjoyed it Anna! PowerQuery is such a powerful tool! But I think you are in good hands with your current data analytics stack 🙌🏼
@anna-878 2 жыл бұрын
@@YlmazDALKIRANscallion yes, tableau is very user friendly, has it's own syntax which is very easy to pick up, many functions will be very similar. Tableau Dashboard is a tool like Power BI, I find it very useful for mapping data (spatial analysis). Tableau Prep in comparison is great for cleaning data - a bit like SSIS or Azure Data FActory, but I guess more user-friendly :) I am not a great expert of Power BI, can't compare much.
@jmorsejr 2 жыл бұрын
Great video! I already started working on the Google Data Analytics Certificate, but decided to take a break and work on Excel. I completed the first course in Excel Skills for Business, this last weekend, and half way through course 2.
@LukeBarousse 2 жыл бұрын
Heck yeah!! Keep up the studies Jon!
@jmorsejr 2 жыл бұрын
I am almost done with the Advanced, and last course in the Excel Skills for Business specialization. Any recommendations for practicing these skills?
@Data_maven 2 жыл бұрын
Very insightful and needed. Thank you Luke! I love the collaboration too Hi Tina and Luke❤️
@LukeBarousse 2 жыл бұрын
Aw thank you! And loved the collaboration as well, Tina is so awesome to work with! 🙌🏼
@devinbarnes 2 жыл бұрын
I love how Ken is holding the Google Data Analytics cert in his hand while he's telling Luke what to do
@jadedunia 2 жыл бұрын
Lol, this is a subliminal message that encourages me to complete that google certif 😅
@LukeBarousse 2 жыл бұрын
😂 I didn’t think anyone would notice that! 😂
@devinbarnes 2 жыл бұрын
@@LukeBarousse Maybe for my next interview I can use you as a reference and you can mention my attention to detail ;)
@LukeBarousse 2 жыл бұрын
@@devinbarnes 🤣😂 Do it!
@christophercarlstrom7505 2 жыл бұрын
Damn! I’m one of the best excel slingers at my company and I never heard about half the things you mention AND make it sound like excel for dummies. You have my sub.
@risan. 2 жыл бұрын
This video is gold! Lot of insights about limits of excel and how power query, power pivot comes together in power BI.
@LukeBarousse 2 жыл бұрын
Thanks for this Risan!!
@frak7190 2 жыл бұрын
This is not only the best but the ONLY helpful video about this topic. I've been searching for months for a video like this
@LukeBarousse 2 жыл бұрын
Glad it was helpful, frak!
@kateb9918 2 жыл бұрын
Great video! And collab is amazing, all the fun and irony! Thank you
@LukeBarousse 2 жыл бұрын
Aw thank you Kate! We do love some Tina (and Ken)!!
@laismaiarasantos1571 2 жыл бұрын
Your videos are always very entertaining! I loved the collab!
@LukeBarousse 2 жыл бұрын
Aw thanks for tuning in for this!! The collabs were so much fun!
@vitorpereira7511 2 жыл бұрын
Hey, Luke! Great content! Congrats!! I am thinking about switching from Google Sheets to Excel as it is, of course, industry standard spreadsheets software, and also because I believe I can have have more possibilities using it. I'd like to hear some thoughts on it from you though. You believe that this switch is needed or can I stick to Google Sheets only? Thank you in advance!!
@Gs-Excel 2 жыл бұрын
Your video is a nice one. I do have plenty in my channel. Yet, its something i have ever liked to watch the method of teaching.
@iamBede 2 жыл бұрын
Awesome stuff.. I was kinda contemplating lately bout the role that I would like to get into. I'm currently doing vulnerability reports but after seeing your video, I think I want to become a Data Analyst or Data Scientist.
@GUARIVERA81 Жыл бұрын
Really enjoy the videos, I watch most of them multiple times.
@LukeBarousse Жыл бұрын
Thanks Pito!!
@aldrinpano9062 2 жыл бұрын
I'm two months into Courera and stumbled upon this channel (algo gods) Great content. Thanks for creating these!
@LukeBarousse 2 жыл бұрын
Aw thanks so much for the kind words Aldrin!
@erin1220 2 жыл бұрын
Yay Tina!! This was a great video. Very informative and the comedy makes it fun to learn as well!
@LukeBarousse 2 жыл бұрын
It was so awesome having Tina in this video! Glad you enjoyed it Erin!
@andreyseas 2 жыл бұрын
Seeing the three of you data nerds together makes me smile! Great job :)
@LukeBarousse 2 жыл бұрын
Ha! Glad we could do this Andrey!
@SeattleDataGuy 2 жыл бұрын
So many great cameos! And a great explanation about how to really take your skills to the next level in Excel. I will say I am not a huge VBA fan 😬.
@LukeBarousse 2 жыл бұрын
After my fiasco with VBA i'm the same way! !pend your time learning better languages 🙌🏼 Also hope to have the video with you launching next week! 🤞🏼
@Postntalkmemes 2 жыл бұрын
I really like your all-detailed Information, Thank you
@dzeng Жыл бұрын
Great video. I use vba kind of by design because I don’t have access or permissions to use python or R. Was able to automate a bunch of tasks with it but if I am ever granted permission to use python I would convert my macros over to that language instead.
@SandyCoco1 2 жыл бұрын
I'm happy I found this lol.. I recently started learning Power BI and I could use some motivation right now. Thanks Data nerd 😬 and Tina and Ken. Thank you guys.
@LukeBarousse 2 жыл бұрын
Glad you found this as well Sandra!
@danielboyd7810 2 жыл бұрын
A couple of years ago I discovered the wonders of power query and power pivot. The unfortunate problem with data visualization tools is getting people to adopt something other than excel so I've had to build 1 or 2 excel dashboards for clients against my better judgement.
@chengwang411 2 жыл бұрын
Love how you always slip a few sketches into your video to make it more fun to watch ~~ Yeah. Power Query and Power Pivot are such useful tools. and just a few M codes could be of great uses.
@LukeBarousse 2 жыл бұрын
Gotta keep this data stuff interesting; thanks for the kind words Cheng!
@equiwave80 2 жыл бұрын
Absolutely loved the video!!! Thanks for the valuable information shared.
@LukeBarousse 2 жыл бұрын
Thanks for this, Deepak!
@s_z_fry 2 жыл бұрын
Man I love the crossover in this one. All my fav analysts in one spot.
@LukeBarousse 2 жыл бұрын
Thanks Seth! This was a fun one to make!
@ramonanthony 2 жыл бұрын
This was excellent!!! Thanks for this video. Keep em' coming!
@LukeBarousse 2 жыл бұрын
Thanks Ramon!!
@jadedunia 2 жыл бұрын
Wow, this is impressive! I come just to finish the Intermediate Excel skills for business for Macquarie university on Coursera, can't wait to start the next course on powerquery and powerpivot
@sifrank9268 2 жыл бұрын
On the same path, now nearing the end of Part 4... Good luck dude
@jadedunia 2 жыл бұрын
@@sifrank9268 💪💪💪
@venkatprasath01 2 жыл бұрын
Me too! Just completed Intermediate part I and on the way to Intermediate Part II
@jadedunia 2 жыл бұрын
@@venkatprasath01 good luck dude 💪
@MurderBirdExpress 2 жыл бұрын
I just started on it
@ikeslo 2 жыл бұрын
That was so funny, Luke. I love it.
@user-nn5tr5ei2c Жыл бұрын
Thanks Luke for the brilliant content.
@damalsena Жыл бұрын
Look! Data people can be fun too! More, please. I am inspired.
@carlosantunezmeza 2 жыл бұрын
Nice! Just one question. Can you automate the data collection from the company systems ? Does excel have any feature that can conect to the data bases directly whithout having to select the file location every time?
@VhangorD2 2 жыл бұрын
Great video Luke! Looks like I should dive deeper in the Excel universe!
@LukeBarousse 2 жыл бұрын
It's not a bad skill to have
@axion8788 2 жыл бұрын
Most sensible overview of spreadsheets I've seen I started using them 38 years ago. What Microsoft finally did is add RDBMS capabilities (Power Query) and quasi-multidimensional data management (Pivot Tables). So, it really is now a 3-headed monster: Spreadsheet, RDBMS and OLAP. Still can't compete with TM/1.
@LukeBarousse 2 жыл бұрын
I like this analogy of 3-headed monster!
@himanshupandey9902 Жыл бұрын
It was really awesome. I know now what to learn in excel. Thanks buddy.
@tedanthonytarona8355 2 жыл бұрын
Hello luke! Thaank you so much for these videos. This game me my aha moment. I want to be a good data analyst. Currently learning excel in coursera. Love from Cebu, Philippines!
@LukeBarousse 2 жыл бұрын
Keep up the hard work Ted!
@gatorpika 2 жыл бұрын
I don't think it's really an either/or decision on tools but use what is best for what you want to do. BI tools are good for repetitive stuff and automated distribution, but I use Excel a lot when I want to model more complex output that would take a bunch of coding to get right. You also tend to get a lot of data in Excel in the business so instead of importing it into a BI tool to analyze, you can just quickly pivot it straight on the source document to start looking at it. It's also good to know because it's pretty much universally available and in some companies you might not have access to the best available BI tools that will do everything you want.
@olemew 2 жыл бұрын
Great video, 4:30 I'd say that 'Record macro' is a great tool for learning/remember commands but I don't remember ever using them directly. Tipically you will declare variables and at lest remove all the "Select" "ActiveSheet" and hardcoded logic.
@LukeBarousse 2 жыл бұрын
Very much can agree with this!
@vicvallery120 Жыл бұрын
OMG I LOVE THE COLLAB
@scottdcarter 2 жыл бұрын
Amazon warehouses depend on Excel for daily reports and there are some crazy complex VBA modules involving get/post http requests, converting JSON data, and sending webhooks. Seeing that recorded macro made me taste my lunch.
@LukeBarousse 2 жыл бұрын
Thanks for sharing this Scott
@MultiCristian102 21 күн бұрын
Thanks for making this video interesting and easier to consume.
@AndrewTanielian Жыл бұрын
This is very well done. Thank you for making it!
@LukeBarousse Жыл бұрын
Thanks Andrew!
@Seftehandle 2 жыл бұрын
I love this vid. Great content especially recommendations about coursera spec which is great and dax, powerbi for dashboard, db jn py. And of course Tina's appearance :)
@LukeBarousse 2 жыл бұрын
TIna’s appearance was my favorite as well! 😜
@lijstthuispiano 2 жыл бұрын
Haha “that was fast, we gotta give you more work”. And that is why you should wait a couple of days before sending your work to your boss (unless doing more work results in a pay raise). Awesome video!
@LukeBarousse 2 жыл бұрын
Completely agree with the waiting a few days mentality! hahah
@pj4733 2 жыл бұрын
I usually used Excel as more of a drafting/observe tool to observe a small sample data, build mock pivot tables, know what tables and/or columns I should use as a final interpretation for the project at hand because it would be a pain to do it on a bigger database program
@LukeBarousse 2 жыл бұрын
Yep! Excel can be great for this use at prototyping!
@spilledgraphics 2 жыл бұрын
Long Live Excel! Thanks for making this video! 🤘🔥
@LukeBarousse 2 жыл бұрын
Thank you my dude!
@jowardcabrera1186 2 жыл бұрын
Ohhh, this is the path I want for future career. Thank you 😍
@LukeBarousse 2 жыл бұрын
No problem at all!!
@MrBustroj 2 жыл бұрын
Love the crew in the video :)
@LukeBarousse 2 жыл бұрын
Heck yeah love me some tina and ken!
@Yupppi 2 жыл бұрын
I saw my uni teacher of mechanics pull out an excel sheet that had some spec values of a spring and mass or a piston. It also had a picture with animation of that. When he changed one value, some kind of designative number, the picture and animation changed. That's when I knew it can be used for wild stuff if someone shows you how.
@LukeBarousse 2 жыл бұрын
This sounds interesting, thanks for sharing this Yuppi!
@ShiftyXC 2 жыл бұрын
For the first time, I had to slow down the video, haha. Thank you Luke for this insightful video.
@LukeBarousse 2 жыл бұрын
😜 Maybe I tried to jam too much info in. ha!
@Thuvu5 2 жыл бұрын
Absolutely THE best video about Excel for data analysts I've ever watched, Luke! 🤩Loved the way you explained PowerQuery and PowerPivot, and there's so much detail you covered. Sick quality as usual!!🤓
@LukeBarousse 2 жыл бұрын
Aw thanks so much, Thu! I’m just trying to keep up with your quality of content! 🙌🏼
@Thuvu5 2 жыл бұрын
@@LukeBarousse Aw I'm so flattered🙈🤣
@gabrielkiss5636 Жыл бұрын
As a Sales Ops i always have worked with excel data from CRM and plugged on BI tools, i moved to SQL and python before learning how i can make some bullshit tasks only with pivots and vba (since my crm pipelines dont have native power bi integration) holy shit, thanks a lot man
@LearnAvecAmeen Жыл бұрын
Thank you, Luke, Best teacher on youtube :) Keep rocking insh'Allah
@LukeBarousse Жыл бұрын
🙌🏼🙌🏼🙌🏼
@keerthanavivin450 2 жыл бұрын
Great video. Super useful. And love the humor! :D
@LukeBarousse 2 жыл бұрын
Thanks Keerthana!
@KaraboMoremi 2 жыл бұрын
Nothing could've prepared me for the Tina Walk-in as the Boss' Boss😲🙌🏾💥🔥
@LukeBarousse 2 жыл бұрын
She’s the only acceptable person to play this role!! 🙌🏼
@ladislauandre4492 2 жыл бұрын
I loved the collaboration. And learned new features from excel that I didn’t know
@LukeBarousse 2 жыл бұрын
Ha! Love me some Tina and Ken as well! Thanks for tuning in!
@ladislauandre4492 2 жыл бұрын
@@LukeBarousse it’s me to thank you. Following ur videos has been the base of my Data analyst journey
@avishekbiswas4121 2 жыл бұрын
This is too genius Luke! Thanks for the funny role playing of real world relevance of data analytics with Tina and Ken :)
@LukeBarousse 2 жыл бұрын
Ha! Thanks for this Avishek! Glad you enjoyed it!
@WoW360WoW 2 жыл бұрын
It's been awhile man! Excited for the new video drop lol
@LukeBarousse 2 жыл бұрын
It's been waaaayyyy tooo long! haha Thanks again for meeting with me last week Bryan! Super great getting to know ya!
@santiagobardelli5675 2 жыл бұрын
The video was very instructive. I tried Power query two years ago but it was not a good experience. I am sure it was because of lack of experience. It is the first time that someone mention when to use each of the tools. I mean when to use SQL, python, power query, power pivot or power BI. It would be great if you could show more exemplars on each of the steps... Thanks
@LukeBarousse 2 жыл бұрын
Thanks for this Santiago!! And let me see what I can do about this video idea! 🙌🏼
@jonyeatman6610 2 жыл бұрын
Awesome video really love the content would you be willing to explain more of the process on how you use python to upload downloaded data into a database
@LukeBarousse 2 жыл бұрын
Yeah let me see what I can do about this in a future video. Hoping to do more project based videos
@Veggieindia Жыл бұрын
Nice presentation
@NeLzKieTV Жыл бұрын
Nice video! Very informative and entertaining😅
@serwinator658 2 жыл бұрын
Дякую, дуже корисне відео. Шкода що не натрапив на цей канал раніше.
@LukeBarousse 2 жыл бұрын
Я радий, що ти знайшов його
@claymcclendon 2 жыл бұрын
This video is my life. Love the end. Because I get task exactly like this.
@LukeBarousse 2 жыл бұрын
Ugh can relate all too well with this kind of tasking 😥
@thomashogan1985 2 жыл бұрын
Great video, 100% my experience with macros PQ is a game changer
@LukeBarousse 2 жыл бұрын
PQ is SUCH a game changer and wish I would have known about it sooner!
@sergiosanabria7854 2 жыл бұрын
This is such a great and funny video!!!
@hussamelshehawy Жыл бұрын
Dude made me love data analysis in one video. 😂
@davidmiller-td1sl 2 жыл бұрын
Great video! You really excel at editing these!
@LukeBarousse 2 жыл бұрын
😂🤣 Aw thank you Dave! 😘 Next video I need to get you in for the collab!
@davidmiller-td1sl 2 жыл бұрын
@@LukeBarousse a collab! That sounds pretty hefty!
@LukeBarousse 2 жыл бұрын
@@davidmiller-td1sl Nothing is too hefty for Dave Miller!!
@pouyan74 2 жыл бұрын
On an unrelated topic, could you please share some images/videos of your workstation setup? And maybe some explanations? I noticed that it allows you to work in standing position, which is really beneficial for this type of job that necessitates being in front of the screen for several hours a day, and I was thinking about building a similar setup. Suggestion: you could do a full video on how do you cope with potential health hazards of this job. E.g. is there any physical exercises that you would recommend us?
@LukeBarousse 2 жыл бұрын
Love this idea for desk tour / ergonomic recommendations for a healthy lifestyle… let me see what I can do on this!!!
@Alanlift Жыл бұрын
hey I have decided to become a data analyst, I've math degree, I fall in love with your contents since I stumbled across
@LukeBarousse Жыл бұрын
Heck yeah! Thanks for following along!
@evianowisdom7671 2 жыл бұрын
is possible to get a job as data analyst only with your excel skills and what kind of job roles did you apply for?
@venujosyula2444 2 жыл бұрын
You were great bro!! keep it up :) ILU
@LukeBarousse 2 жыл бұрын
Aw thanks Venu!
@JoshBabin 2 жыл бұрын
Awesome video as always! Perfect explanation of how Excel goes from being helpful, to being mutated into an entirely new application. And not in a good way. I feel that Excel+VBA is the gateway to "proper" DA, since you get to dip your toes in and eventually say "there's got to be a better way!"
@LukeBarousse 2 жыл бұрын
So true! After I started using VBA with excel it really opened my eyes and made me realize that I need to look into the capabilities of other tools. Thanks for this Josh!
@lawrencedoliveiro9104 2 жыл бұрын
But if we all know that now to begin with, why would we waste our time with Excel?
@JoshBabin 2 жыл бұрын
@@lawrencedoliveiro9104 1) it still has its uses and oftentimes we're forced to use it by the business 2) many people become data nerds by virtue of being exposed to Excel first, and looking into how to do what it does but better and more efficiently
@lawrencedoliveiro9104 2 жыл бұрын
Surely the smart businesses are those that learn from, not just their own mistakes, but those of others as well.
@homejonny9326 2 жыл бұрын
@@JoshBabin And excel vba has the Declare statement, so you can insert C pure code into your solution (Win32 API).
@felipe7x 2 жыл бұрын
Amazing video, thanks guys
@LukeBarousse 2 жыл бұрын
Our pleasure!
@TinaHuang1 2 жыл бұрын
Thanks for lending me your suit! 🐙
@LukeBarousse 2 жыл бұрын
Anything to get you from stop showing me those "I am the octopus" videos 😱🙀🫣
@TinaHuang1 2 жыл бұрын
@@LukeBarousse kzfaq.info/get/bejne/sJ94aq-cq6nPg6s.html
@parahiamin6765 2 жыл бұрын
These are the tools I think I will need to learn in the next few years... Excel - intermediate level Power Query - intermediate level Power Pivot Power BI Python SQL Server IMHO, the key to any project is to use the right set of tools and to try to future proof it with what if scenarios. PS great video!
@LukeBarousse 2 жыл бұрын
Very much agree with the last point on using the right set of tools being the key!!
@philmanyeung 2 жыл бұрын
Love those youtuber cameos! This video is such a good time
@LukeBarousse 2 жыл бұрын
Thanks for this Philman! This video was super fun to make with Tina and Ken!
@GodwinMutai 2 жыл бұрын
I love this. Very educative
@LukeBarousse 2 жыл бұрын
Thanks Godwin!
@SearchingforScraps 2 жыл бұрын
Thank you for your videos! I have just begun my journey and wokring on my excel skills. Is there a way to excel for chromebook so Ican messing around with it ?
@LukeBarousse 2 жыл бұрын
I'm not sure on this one, so sorry
@ShaikAmirHussain 2 жыл бұрын
Thank you unlocked a new dimension of excel 😳👍
@LukeBarousse 2 жыл бұрын
Glad it helped!
Sergio Outdoors
Рет қаралды 91 МЛН
Maven Analytics
Рет қаралды 89 М.
KingStore_astrakhan
Рет қаралды 4,1 МЛН