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!! 🙌🏼
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!
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 : )
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! 🙌🏼
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.
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...
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.
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.
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
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.
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.
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.
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!
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.
@@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.
@@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.
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.
At my current role, I’ve found it absolutely pivotal in teaching the data analysts how to use SQL to get out of excel, as we need to analyse billions of rows. Learning sql is way more powerful for this sort of work. if you have a decent data warehouse, of course. Analysts have come to love SQL and understand it’s not as scary as it once was.
I just started learning a bit more advanced features in Excel, which are entry level for most people. Should I just go right into SQL now or master Excel first?
@@TheChicagoballer I think just continue with excel first... then learn sql to advance your excel or data processing. I think it'll be easier by then too rather than learning sql without knowing what to do/learn
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 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?
@@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
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!
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 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.
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!
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.
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
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?
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.
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.
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!
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!
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.
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!!🤓
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!"
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 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
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.
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
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.
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.
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
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
I'm a data analyst with a computer science background, I work for a retail company for the last 5 years, I pretty much do everything using excel and power BI with little use of code, I think it all depends on the size of the business and the amount of data needed to work on, in my case we have an outsource to provide all the external data "competitors, market share, loyalty", I do not work on raw data at all but I believe when the day they stop the outsource I will have to integrate Python in all of what I do, Excel has no capacity to process this much data, TBH before being an analyst I've gad little knowledge about Excel, now I know everything, well maybe not everything yet, but I have a decent knowledge about most of its aspects!
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!
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.
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.
@2:48 "...make it pretty so my boss thinks I've done some productive work." That truly seems to be a large chunk of the job! (At least from this non-data analyst, religiously watching through your channel!) Cheers! -Tim
I'm not interested whatsoever into being a data analyst, but I thought this video was super interesting. I didn't know VBA could automate the boring things across multiple spreadsheets. Likewise, I didn't know I could combine multiple hundreds worth of spreadsheets without crashing them via importing in the with PowerQuery. Thank you!
I do agree with most of the content, however I think VBA is under rated. As with any language program, the possibilities are "endless". As a data analyst you should fully become an advanced user of it, I'd say a master on it, thanks to the flexibility that VBA gives: you may connect java, SQL, python,etc to append for speed times/lack of functions that VBA does not have, but using Excel as a front end solution saves a lot of learning curves and development for user interfaces within our toolset.
Thanks for the video Luke, from my side, I think excel also lacks the statistical aspect of analysing deeply the data, also what I find missing in the video is the tool that makes the data updating automatically by using an API for live updates.
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😌💪🏾.
I'm also a data analyst, but I haven't used Excel in years. We call it a "ghetto" tool in my department. I only use SQL (SSMS/SSIS), Python, R, and Power BI. There is so much more power in those tools than in Excel
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.
Iam a SAM Analyst . I work mostly in excel..when my college frnds and my relatives ask what work u do..they laugh when i say i work using excel..🙄🙄😪but after seeing this video i got hope🤩
Explained everything in a very proper manner , but I want know which books are best for learning excel from basic to advance level ....can someone plz suggest me.
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.
I like that you use the same shirt in almost every video 😅 kidding aside, I’m studying to be a DA in my late 30s. Your content makes me strive more to do better even if it’s a challenge for me to study the tools required. Good job man 👊👊
Starting with data analysis, I think I will put Luke's face to my vision board to remind myself the final goal of being able to answer my boss in such a way an do all these reports for minutes