Hello. I have a stupid question but I really want an honest suggestion. Can someone with no technical background or coding knowledge, not knowing even excel, will a Google analytics course be a good choice to enter data analytics field? Can that person actually learn data analytics and get a job if no such experience? Would really appreciate your suggestion!!
@@hksahota2414 There is information available for you to continue upskilling. All those skills you mentioned, you can learn them even for free. All the best. Keep pushing!
I have been analyzing datasets I found on Kaggle for my personal projects. However, based on this video and the projects that landed subscribers their first jobs I feel like I am just looking for trends rather than making a tool that solves a problem, so I feel more like a researcher at a university rather than someone working for a company. Can these types of projects land me a job?
Thank you so much for having me in this video, Luke!! 🙌 Loved the childhood clips and it’s amazing you created the Excel tracker for your friends as a passion project. I find that so motivating to do something with my hobbies as well! 🤔
Aw thanks for being in this video!! So much fun making this one 🙌🏼🙌🏼 Your project motivated me to dive back into my R skills and dust them off; so thank you!!
@@LukeBarousse Yes, it was fun indeed!! I loved the part of Shashank as well 😂. Glad to hear you're motivated to dust off your R skills! (maybe a new video on that? 🤣). R is getting less and less popular these days, but I still like it a lot 🤦🏻♀️
Explained perfectly! I’m a division 1 golfer and my coaches are not exactly up to date with data analysis. I’ve tried convincing them to use stat tracking apps but they don’t think the cost is worth the return. (They are kinda pricey). After listening to their thoughts I decided I could code an application that will be specific to our own team and help them understand where each of us individually need to improve. Perfect project because it’s something I care about and something that provides tangible benefits.
Jesse, this is a great beginner project! Good luck with this. Also (as I'm sure you know) Ken Jee has a lot of content on Sports Analytics (specifically golf) so i'd check out his channel as well.
My employer just upgraded me to the Z book! For a corporate-supplied notebook, it’s quite powerful. Not going to lie, I’m glad I found your channel as I had ran into a wall that blocked the joy and motivation I started with. I’ve been managing to find new ways of thinking, looking at, and approaching solutions to problems.
This video was 🔥! Thanks for having me on @Luke Barousse! This is one of the most common questions I get and this video covered some great content on it.
My dude! Thanks for guest starring. I get A LOT of questions about how to freelance as a Data Analyst and this helped out a bunch for those aspiring in data analytics!! BTW where you coding in the matrix when I called? 😂🤣
When I learn a new technology I would try to use it in a way that is interesting to me, preferably with someone that is more knowledgeable than me so I can steal some of their brain cells c:
Amazing contents. I think it's more fair to charge client per project than per hour, but I've heard that charging per hour is safer because it's guaranteed by Upwork if the client fled without paying. That Hackathon stuff is fascinating.
Luke! Great video, my snake charming friend. And thanks so much for introducing me to Thu Vu! How does this woman only have 1700 subs??? Her content is awesome.
Thank Al, my Pirate-friendly friend "RRRR"!! And I had the same thoughts about Thu, it is crazy the quality content she is pumping out; I love her channel! BTW, I'm thinking about doing a video on how to use LinkedIn for networking/job-searching. Curious on if you'd be down to be in the video?
Thanks for this I am 23 just graduated last year with Mech Eng degree (October 2021) and interested in data science cuz in my final year I learnt a course called experimental mechanics where we implemented data analysis/statistical analysis on tissue biomechanic data. One of the challenging assignments I had 💀 but it was fun and now I will do masters in data science this April 🙏
I finished my first project. I used a dataset of OSHA construction worker injuries from 2015-2017. It was before I started learning Tableau, so I used Python 100% for everything, including charts. Boy howdy, Tableau makes graphing so easily. I see why it's so necessary.
@@LukeBarousse The fact you reply to so many posts is not lost on me. I, and many of us I'm sure, appreciate your presence on the internet. We look forward to the next video.
One thing I failed to do in my early jobs was to keep projects and examples! I have so many that I would love to put on my website, but I didn't keep anything so I would have to make them over from scratch.
Same here! Mainly I’ve done a lot of Small projects for friends and at work that I just thought were nothing and didn’t bother to save them…. And now the regret sinks in 😮💨
So I just recently found your YT channel and been watching videos and then this one when it got to the 2:59 mark I recognized that RP logo and was like whoa 🤯
Thanks for your great video , i started for one year ago and half my journey on data i was not sleep well🥲, because i have a goal , i got out from my comfort zone " Fifa - call of duty - Netflix " , now i studied : - Excel for data analysis , functions - cleaning data - power query [M Language ]- power pivot [Dax] - SQL - power bi - Python for data analysis - Machine learning for regression problems . And all of that , now i am using it on my job as accountant , and really now i am not accountant because my new tasks all of it is data analyst job description , and really i found my self , i was another one . My advice to anyone is studying data analytics , Use it or Lose it . Good luck ❤
Love this advice "Use it or Lose it". Very much agree with application to learn but also retain what you have learned. Thanks for sharing your journey Ahmed!
I'm trying to get a bioinformatics job and Thu's section of the video about competing in a cancer focused hackathon seems like a great idea that I'll have to try
Thank you for the video. Can you please tell in the next video about finding cool offers for Data Analyst Seniors? Like the Talent Service site, where you are not looking for a job, but companies are hunting for you.
No problem at all! And thank you for noticing this! A good bit of time goes into creating and editing these videos; BUT I love making them so it's always worth it in the end!
dude I don't know if you know this, but RP came out with a diet app whose greatest strength is taking the feedback you give it (your weigh-ins, satiation levels, meal adherence etc) and dictating the macros you need for the following week. It then uses a large set of basic whole ingredients and foods to help you put your meals together for the week precisely for the new macros, and gives you a shopping list of all the ingredients in their raw form.
Ha! Yeah I have been following them. I was consulting with them before they built the app. But I think they were developing a similar solution at the same time with another team.
@@LukeBarousse well I’m sure you had something to do with it, showing the value, etc. What a powerful and simple tool! Taking something so tedious and uninviting and stressful as nutrition and making it intuitive… I’m sure you provided them with tremendous confirmation as to the viability of such a tool as a product! Way better than myfitnesspal. Thank you!
Insightful as always Luke! 💯 🔥🙌🏼 I very much liked the Listen-Build-(Feedback ) loop mindset you shared to solve problems. I’m taking notes! 😆 Also, as a suggestion, maybe you can add to your list of content how can one be part of the data analyst/data science YT group (like with you, Ken Jee, Tina, etc.)? Haha! 😆 P.S. PowerBI video anytime soon? Haha 😋✌🏼and btw, Pokemon cards (Charmander) spotted! Last time was the gameboy. I wonder what’s next, Tamagochi?
Thanks for this Rem!! Regarding Power BI, I am planning on doing a dedicated video in the next couple of months; so stay tuned!! That Tamagochi; comment got me 😂😂😂 I was actually more of a Digimon person... I gotta see if I can find that thing now that you said that!!
Hi Luke, I have the exact same same issue as your friend in finance with multiple excel files. Could you please expand a little more on how you solved the problem or direct me in the right direction as my googling efforts have come to a dead end :( Great content too! I'm currently trying to transition my career towards data analytics so your videos are really helpful!
YEah I highly recommend you check out PowerQuery. It's a powerful tool from microsoft that allows you to collect data from multiple excel files and put it into either an excel or power bi file. thanks for the kind words as well!!
@Luke Barousse I'm a recent MBA graduate, and I want to know what's the "best" course of action to become a Data Analyst? Should I focus on Excel and MySQL certifications to land an entry level position or should I focus my attention elsewhere?
Mannn those vids are sooo helpful, pleaseee keep going, this channel is great, can you make a vid on good resumes l, like where to place your github profile link ad where to place your certificates and projects i am struggling to make a good data analyst resumecan you please help?
Thanks Michel! So glad this was helpful; And great suggestion on the video idea for building a resume. This is def something i want to cover in a future video so stay tuned!
At 4:25 you talk about a creating a project where you helped other people using office data. If you wanted to share your projects with a potential employer, you can't share data from another company. In a case like this, how would you share the project you created with a potential employer?
In those cases, it's actually not as important to share the physical project IMO. I think what is more important is that you can share generalities about the project, BUT more importantly how your project made an impact on the team/company.
Hey, Luke! May I ask you a very silly question? There's something I simply don't understand: let's say you build a project, run the analysis and jump into an outcome. Fine. Project finished. What's next? Even if you build a dashboard, it becomes "their" problem because you aim them to self manage their decision making process. Is this right? If so, what is the daily basis activity of a data scientist? Would I be unemployed right after the project is finished? I'm kind of stuck with this doubt. Thabks for your great videos. Greetings from Argentina!
Dude, you developed RP? That’s helped a lot. I mean the app needs a lot of work because it won’t let you restart diets if stuff changes. But it is still a awesome diet planner.
Oh sorry, to be clear, I didn't develop the mobile app or develop the RP diet, perse. Just back when they were using excel templates to make you plan your diet, I made an this solution as an easier method to plan your meals and track your macros!
@@LukeBarousse Yeah, the downside is if you make a few mistakes or go back to re-tweak your diet plan more than twice it locks you out and you have to get in contact with them to reset it. Which is a huge "eh I learned what I needed to from this application, I don't need to pay for something that doesnt let me restart diets based on different stuff". Oh well.
Hope you're doing well also, Bouseux! Sorry I've been absent for a little bit, went on a vacation for a little bit; BUT I should have a video launching this Friday (if everything goes right... ha). Thanks for checking in on me I appreciate it!!
Beyond Excel, how did you find what programs to use? Was it what was readily accessible to you right away by purchases, something that employers provided, or did you rely on mostly open source free programs? And how did you come to the conclusion that 'yeah, this is the best program for this'.
it really depends on what your employer and client is using. Throughout my career, I've learned the program that my team uses, whether that is Power BI, Tableau, or Python. It really depends on what the end-user wants the solution in. Some solutions were free and others weren't
@@LukeBarousse Excellent, Luke. My workplace actually has quite a few options available (and I found someone who knows PostGreSQL pretty well, which is one of the many). We also have Tableau and Power BI. I believe that my job in HR (I deal with metrics of incoming and outgoing employees and create business solutions) will lend to me creating useful projects and eventually dashboards. Hope so, anyway.
This was eye opening. Just listening works. But I am usually alone at work. And would like some ideas for solo projects for a newbie to programming to go into my portfolio. I don't have a portfolio website for myself, but would like to add the experience on LinkedIn or the likes. I just cannot start working on Upwork because of the shifts I mentioned in your previous video. So I would like to get a little bit of experience in analysis and programming (I am learning R due to the Google Data Analytics Certificate) so I need lots of time for the projects. Are there any DIY Data projects for newbies like me? I searched Google but the projects mentioned there are either too difficult as I am new to programming or are very time consuming. I was thinking maybe I should just ask my boss to give me sales data from his business and then talk with you on how to approach the analysis, if he even agrees to provide the data to me. Other than that, I just can't seem to get working on my portfolio. My Google Certification Capstone took me almost 2 months to complete due to time limitations. I am sorry for my really long comments, I wish I could TL;DR them, but the TL;DR would remove the details that would make a person comprehend my situation on a fundamental level. This is Saudi Arabia. There is no team here. Expats just are thrown into a job and expected to do everything. My boss comes around at 11 usually. And we also have to do his job on the maintenance part. Basically, I do the job of my immediate Supervisor and he handles everything for the boss. And being Saudi Arabia, we cannot even raise our voice, because there is no rights here for expats, like literally. I hope you have a clearer picture of my situation. I have my family to take care of. And little to no savings. If I had savings, I wouldn't have stayed here. Most of my earnings go to my family to support them with the help of my sisters living in the US because I earn very less. They are trying to get me to the US but I cannot get a work visa if I have no experience and maintenance planner experience in Gulf nations are not appreciated there is no exposure to technical work in Gulf countries.
And the worst part of my job is that most people I do interact with are uneducated technicians from mostly Southeast Asian countries. I wish I hand't accepted this job in the first place. 4 years and I have learned how to work for others without any pay whatsoever. It had made me hate desk jobs because this is all there is to desk jobs, just work for bosses, have nothing to do with technical stuff unless you work in big companies like Google or NASA. But seeing you, Thu Vu, and your friends and others on CZcams and LinkedIn had given me hope for data analysis. The same thing happened with my CCNA, I saw an opportunity for it in the Saudi labor market, studied for 2 years and then when I finally got my cert, COVID-19 hit. And then Saudization hit me harder than COVID-19. I think I should just contact UNHCR to take me in as a refugee to some other country, LOL, at least there I can be around more people like you perhaps and learn from them.
WEll I think the biggest thing that you should commend yourself for is that you haven't given up. There are plenty of self-guided proects out there that you can check out. Many on CZcams and i've done more on platforms like Coursera and DataCamp. They are great for having you follow a plan to complete. BUT I really like this idea of getting data from your boss, as this would be a project you can use your current experience for. So I'd go for this! Keep your head up; you got this!
Hi Luke Can I ask you if vba is worth it? I didn't find anywhere that VBA is requested. I'd focus more on Python, SQL, Tableu, and some Excel. Unless vba being part of excel hence would be requested for a data analyst. Even though I always read and observed that python, Powerbi, SQL are somehow most used.
Yep, I agree with the skills you outlined above being more important that VBA. It isn't as much requested (and frankly I think it's a little outdated and not nearly as powerful as something like Python). In the example I shared with using excel and VBA, I was taking a college class that required the use of VBA. I used it once after this in a short project and haven't touched it since.
@@LukeBarousse Thank you very much. I appreciate a lot your feedback because actually I gave up using it, as it seemed so limited while R wasn't as catchy as python and less 'friendly'.
It really depends on the client and what format they want it in. If it is my boss; i'm probably giving her the insights via a power point; if its a client that is familiar with a tool; it may be just the code itself that I used. It really can truly vary depending on the client. BUT communication is always the key soft-skill needed when sharing these insights
Luke, your videos are so interesting and insightful :) Thanks a lot. Currently, I am figuring out which career path should I take? My MBTI personality type is INFP-T. I am in a befuddled state, not sure which should I choose between Data Analyst or Full Stack Developer ( Web Development ) Could you please share your thoughts? Would like to hear from you. Thanks in advance!!
Hey Anand, I'll be honest I'm partial to data analytics, but that's' just because of the career path I chose and what I'm working in currently. Not sure I am the best for helping you choose between the two, but I can say I love the field of data analytics and have no regrets in pursuing this.
Hey Luke I wanted to ask quick- do you think R- shiny apps are worth investing time and effort into? Mainly curious as to how I can leverage different r skills to stand out with employers. Thanks in advance!
Hey Jon, yeah, I think they can be; depending on if your employer/client will adapt to using them. R (and shiny apps) are very popular ways to communicate data insights. 'Thu Vu' has more content on her channel around this topic area and I suggest you check it out!
Hi Luke, I'm an industrial engineering student graduating next year and got really interested in the field of data. I've been researching data analytics and data science and trying to figure out which one I should focus on. While studying I currently work at a marketing agency and work with the analytics for Google ads, Facebook ads, and Google Analytics. Would you recommend me to focus on learning the data analytics part, or the data science part? I want to combine industrial engineering knowledge with data skills to really stand out in my career.
It's really depends on whta your interest relies for either looking at data analytics or data science. For me, I more analyzing data; so data analytics is where I go. Those in Data science typically have a different (or even broader approach). I don't want to tell you what your passion is in; but personally I think the data analytics would be an easier path to start for what you are wanting to do with marketing.
@@LukeBarousse Thank you for the response! I've thought about focusing on Analytics because Industrial Engineering is mostly that from what I've observed. From what I've seen until now, I believe I should learn to learn the programming languages required to get more deeply into the raw data.
@@La_Maquina806 In this case i'd focus on the data analytics part over data science in general. Data Science can be a very broad area that includes many subject areas (like data analytics). So it sounds like you are on the correct path.
Hi Luke What should I do after learn excel? I can use excel and visualization in excel also but I don't know what I need to do next !!! I heard that I can work as a data analysis with excel in the beginning but if I have data in an excel worksheet how can I know where to start?
I would get into learning SQL next as I discuss in this video: czcams.com/video/CC66RXeTn_4/video.html While doing this make sure you're building up your portfolio!
I don't have a template to share, so sorry... mainly just my own finances in an excel sheet that I curated for my use. It wasn't to hard to build and I think it's a great project to undertake.
Yes! I feel like projects (like the one’s we demonstrated here) are more impactful than a degree or training alone. It helps show that you not only know the skills but also that you can apply them in a real world scenario 🙌🏼
Ha! No I wish I did! I just made and application on Excel to make it easier to pick foods, when RP used to provide their templates via excel spreadsheets
Thank u Luke for this video ,I watched it Intel the last moment, I'm really enjoying watching ur videos , and I make sure to subscribe all the channels that u share with us , and yes I'd like to following the same steps that u gives us to know if it work with me or not , and I will text u back if any 🥰😊
Data Nerds! Where/how do you find projects???
Hello. I have a stupid question but I really want an honest suggestion. Can someone with no technical background or coding knowledge, not knowing even excel, will a Google analytics course be a good choice to enter data analytics field? Can that person actually learn data analytics and get a job if no such experience? Would really appreciate your suggestion!!
@@hksahota2414 There is information available for you to continue upskilling. All those skills you mentioned, you can learn them even for free. All the best. Keep pushing!
@@hksahota2414 I feel so! I have a few videos on this and think that many have done this already. The google certificate is a great choice to start
@@LukeBarousse ok thanku so much
I have been analyzing datasets I found on Kaggle for my personal projects. However, based on this video and the projects that landed subscribers their first jobs I feel like I am just looking for trends rather than making a tool that solves a problem, so I feel more like a researcher at a university rather than someone working for a company. Can these types of projects land me a job?
For my first data project, I took my passion for basketball and used that to create a project on an NBA player based on what I analyzed from watching.
Thank you so much for having me in this video, Luke!! 🙌 Loved the childhood clips and it’s amazing you created the Excel tracker for your friends as a passion project. I find that so motivating to do something with my hobbies as well! 🤔
Aw thanks for being in this video!! So much fun making this one 🙌🏼🙌🏼 Your project motivated me to dive back into my R skills and dust them off; so thank you!!
c Thư là người Việt ạ?
@@LukeBarousse Yes, it was fun indeed!! I loved the part of Shashank as well 😂. Glad to hear you're motivated to dust off your R skills! (maybe a new video on that? 🤣). R is getting less and less popular these days, but I still like it a lot 🤦🏻♀️
@@honganhle9646 Dung roi em! 😄
@@Thuvu5 I think R is on the comeback!! 💪🏼
Explained perfectly! I’m a division 1 golfer and my coaches are not exactly up to date with data analysis. I’ve tried convincing them to use stat tracking apps but they don’t think the cost is worth the return. (They are kinda pricey). After listening to their thoughts I decided I could code an application that will be specific to our own team and help them understand where each of us individually need to improve. Perfect project because it’s something I care about and something that provides tangible benefits.
Jesse, this is a great beginner project! Good luck with this. Also (as I'm sure you know) Ken Jee has a lot of content on Sports Analytics (specifically golf) so i'd check out his channel as well.
I appreciate how your phone is actually on a call when you call them. It’s the little details. 👍🏼
Ha! I'm surprised anyone noticed! And thank you!!
Always a great day when new data nerd content drops!!! I’ll be listening hard to find my next project!
We need to get you some hard working data nerds for your team!!
My employer just upgraded me to the Z book! For a corporate-supplied notebook, it’s quite powerful.
Not going to lie, I’m glad I found your channel as I had ran into a wall that blocked the joy and motivation I started with. I’ve been managing to find new ways of thinking, looking at, and approaching solutions to problems.
Have fun with the new Z book, sounds awesome!
@@LukeBarousse loving it. I can get through some Prep flows in under 5 minutes that took my old notebook about half-hour!
This video was 🔥! Thanks for having me on @Luke Barousse!
This is one of the most common questions I get and this video covered some great content on it.
YES!! shashank has the best data analyst project videos on yt!!
My dude! Thanks for guest starring. I get A LOT of questions about how to freelance as a Data Analyst and this helped out a bunch for those aspiring in data analytics!!
BTW where you coding in the matrix when I called? 😂🤣
@Ricardo Dayum straight he does! Love his project videos!!
Some of my favorite data analyst CZcamsrs in one video?!?! Just wow
Thank you for the explanation, im still learning Data Science and Analytics and this video motivates me to do some random Data Analytics Projects!
Heck yeah, glad this helped motivate Michael!
Your channel is like a goldmine! So much value, thanks Luke!
Aw thanks so much for this Konstantinos!!
When I learn a new technology I would try to use it in a way that is interesting to me, preferably with someone that is more knowledgeable than me so I can steal some of their brain cells c:
Stealing brain cells, through working with others, is also such a powerful method in learning something fast. Thanks for this Tina 🙌🏼
I enjoyed hearing you walk through the projects. It was cool to hear a natural way of integrating that STAR method.
Aw heck yeah. TBH I didn’t even realize I used the STAR method until you said this 😅
Amazing contents. I think it's more fair to charge client per project than per hour, but I've heard that charging per hour is safer because it's guaranteed by Upwork if the client fled without paying.
That Hackathon stuff is fascinating.
I haven’t dabbled as much in freelance work; so this is good to know. Hopefully I can make more content on this in the future
Luke! Great video, my snake charming friend. And thanks so much for introducing me to Thu Vu! How does this woman only have 1700 subs??? Her content is awesome.
Thank Al, my Pirate-friendly friend "RRRR"!! And I had the same thoughts about Thu, it is crazy the quality content she is pumping out; I love her channel!
BTW, I'm thinking about doing a video on how to use LinkedIn for networking/job-searching. Curious on if you'd be down to be in the video?
@@LukeBarousse always! Just say the word.
Thanks for this I am 23 just graduated last year with Mech Eng degree (October 2021) and interested in data science cuz in my final year I learnt a course called experimental mechanics where we implemented data analysis/statistical analysis on tissue biomechanic data. One of the challenging assignments I had 💀 but it was fun and now I will do masters in data science this April 🙏
Oh heck yeah, awesome to meet a fellow Mech Engineer! Awesome to hear this project motivated you to your masters. Good luck with it!
@@LukeBarousse thanks hey and I follow u on LinkedIn too 😳
1:20 I am glad that you guys are still getting along very well with each other.
🙌🏼 Aw thanks!
I finished my first project. I used a dataset of OSHA construction worker injuries from 2015-2017. It was before I started learning Tableau, so I used Python 100% for everything, including charts.
Boy howdy, Tableau makes graphing so easily. I see why it's so necessary.
That’s awesome that you used Python for your first project! But very much agree with using tableau! 🙌🏼
@@LukeBarousse The fact you reply to so many posts is not lost on me. I, and many of us I'm sure, appreciate your presence on the internet. We look forward to the next video.
@@seanmcgrady8688 Heck yeah!! May be a little bit of delay with the next one. Going on vacation later this week 😬
@@LukeBarousse Do it!
You are the man, thank you for guiding us data aficionados 🎉
One thing I failed to do in my early jobs was to keep projects and examples! I have so many that I would love to put on my website, but I didn't keep anything so I would have to make them over from scratch.
Same here! Mainly I’ve done a lot of
Small projects for friends and at work that I just thought were nothing and didn’t bother to save them…. And now the regret sinks in 😮💨
So I just recently found your YT channel and been watching videos and then this one when it got to the 2:59 mark I recognized that RP logo and was like whoa 🤯
Thanks for your great video , i started for one year ago and half my journey on data i was not sleep well🥲, because i have a goal , i got out from my comfort zone
" Fifa - call of duty - Netflix " , now i studied :
- Excel for data analysis , functions - cleaning data - power query [M Language ]- power pivot [Dax]
- SQL
- power bi
- Python for data analysis
- Machine learning for regression problems .
And all of that , now i am using it on my job as accountant , and really now i am not accountant because my new tasks all of it is data analyst job description , and really i found my self , i was another one .
My advice to anyone is studying data analytics , Use it or Lose it .
Good luck ❤
Love this advice "Use it or Lose it". Very much agree with application to learn but also retain what you have learned. Thanks for sharing your journey Ahmed!
Firstly Luke, you're incredibly smart 😭❤🙏🏽🔥! Your creativity is just out of this world
Ha I don't know about the first part, but thanks so much for the kind words!!! 🙌🏼
Just the video I was looking for , Thanks a lot !🙏🙏
Your channel is gold, Luke. Thank you!
Aw thank you for watching, Alina!
"hey did I wake you?"
"Yea - you did"
"oh thats nice"
🤣😂
😳🤣
I'm trying to get a bioinformatics job and Thu's section of the video about competing in a cancer focused hackathon seems like a great idea that I'll have to try
Heck yeah! Glad Thu's story was an inspiration!
Excelent content as always, thanks Luke🙏🏻🤙🏻
Glad you enjoyed it, Miguel!!
You rock Luke. Love your content alot. Thanks for sharing..
Glad you enjoyed Olajide! And I appreciate the kind words!
Main point is first try to find the problem and then dive in to the problem details and at the end start working to solve the problem
Very useful video! Thanks Luke 😃
Thanks for this Leandro!! Glad it was useful!
Thank you for the video. Can you please tell in the next video about finding cool offers for Data Analyst Seniors? Like the Talent Service site, where you are not looking for a job, but companies are hunting for you.
Thanks for this idea Nick; let me see what I can do!
solid advice thank you so much
Excellent content!! Keep'em coming!
Aw thanks Josep!
Always delivering Luke!
Aw thanks Alfredo!! Trying to keep the content coming!
@@LukeBarousse as always! Love your content !
I loved the collabs!😁
I did too! Love me some Thu and Shashank!!
@@LukeBarousse it's always fun when two CZcamsrs you watch suddenly Collab!
@@Arne_Boeses Ha glad you thought so... I was cracking up when editing the sections for introducing Thu and Shashank; they are natural actors!!
thank you ^^
I always think that how do u get time out of your busy schedule for making quality video
No problem at all! And thank you for noticing this! A good bit of time goes into creating and editing these videos; BUT I love making them so it's always worth it in the end!
@@LukeBarousse kudos ^^
🙌 🙌
dude I don't know if you know this, but RP came out with a diet app whose greatest strength is taking the feedback you give it (your weigh-ins, satiation levels, meal adherence etc) and dictating the macros you need for the following week. It then uses a large set of basic whole ingredients and foods to help you put your meals together for the week precisely for the new macros, and gives you a shopping list of all the ingredients in their raw form.
Ha! Yeah I have been following them. I was consulting with them before they built the app. But I think they were developing a similar solution at the same time with another team.
@@LukeBarousse well I’m sure you had something to do with it, showing the value, etc. What a powerful and simple tool! Taking something so tedious and uninviting and stressful as nutrition and making it intuitive… I’m sure you provided them with tremendous confirmation as to the viability of such a tool as a product! Way better than myfitnesspal. Thank you!
Great video. I liked this video a lot.
Insightful as always Luke! 💯 🔥🙌🏼
I very much liked the Listen-Build-(Feedback ) loop mindset you shared to solve problems. I’m taking notes! 😆
Also, as a suggestion, maybe you can add to your list of content how can one be part of the data analyst/data science YT group (like with you, Ken Jee, Tina, etc.)? Haha! 😆
P.S. PowerBI video anytime soon? Haha 😋✌🏼and btw, Pokemon cards (Charmander) spotted! Last time was the gameboy. I wonder what’s next, Tamagochi?
Thanks for this Rem!!
Regarding Power BI, I am planning on doing a dedicated video in the next couple of months; so stay tuned!!
That Tamagochi; comment got me 😂😂😂 I was actually more of a Digimon person... I gotta see if I can find that thing now that you said that!!
LOL "Did I wake you? Oh that's nice" 🤣
😂🤣 Well, we gotta get you in a future vid, Miki! But I promise I won't call and wake you to do it in the middle of the night!
Hi Luke, I have the exact same same issue as your friend in finance with multiple excel files. Could you please expand a little more on how you solved the problem or direct me in the right direction as my googling efforts have come to a dead end :(
Great content too! I'm currently trying to transition my career towards data analytics so your videos are really helpful!
YEah I highly recommend you check out PowerQuery. It's a powerful tool from microsoft that allows you to collect data from multiple excel files and put it into either an excel or power bi file.
thanks for the kind words as well!!
the biggest difficult i have is finding the raw data for my project ideas.
What I picked up from this video: This man likes Bubbly and has shadowless Charmander, Squirtle and Bulbasaur? Nice.
Love me some Bubbly!!! 😂😂
@Luke Barousse
I'm a recent MBA graduate, and I want to know what's the "best" course of action to become a Data Analyst? Should I focus on Excel and MySQL certifications to land an entry level position or should I focus my attention elsewhere?
Hey Manuel! Here is the video I recommend for that: czcams.com/video/aqRxZSrJLEc/video.html
Amazing content
Thanks, Nee!
Mannn those vids are sooo helpful, pleaseee keep going, this channel is great, can you make a vid on good resumes l, like where to place your github profile link ad where to place your certificates and projects i am struggling to make a good data analyst resumecan you please help?
Thanks Michel! So glad this was helpful; And great suggestion on the video idea for building a resume. This is def something i want to cover in a future video so stay tuned!
At 4:25 you talk about a creating a project where you helped other people using office data. If you wanted to share your projects with a potential employer, you can't share data from another company. In a case like this, how would you share the project you created with a potential employer?
In those cases, it's actually not as important to share the physical project IMO. I think what is more important is that you can share generalities about the project, BUT more importantly how your project made an impact on the team/company.
8:37 totally missed to insert the sponge bob "2 hours later" meme :D
🤣 Dangit! I should have! 😂
Hey, Luke! May I ask you a very silly question? There's something I simply don't understand: let's say you build a project, run the analysis and jump into an outcome. Fine. Project finished. What's next? Even if you build a dashboard, it becomes "their" problem because you aim them to self manage their decision making process. Is this right? If so, what is the daily basis activity of a data scientist? Would I be unemployed right after the project is finished? I'm kind of stuck with this doubt. Thabks for your great videos. Greetings from Argentina!
building dashboard is the "fun" part, 80% time you are arguing with clients about their requests,
Jump ropes,
Kettle Bells,
CrossFit
Power Query & Power BI!
You’re amazing Luke! 🏆
Ha! Love me some Power Query and Power BI! Thanks Frederick!
Dude, you developed RP? That’s helped a lot. I mean the app needs a lot of work because it won’t let you restart diets if stuff changes. But it is still a awesome diet planner.
Oh sorry, to be clear, I didn't develop the mobile app or develop the RP diet, perse. Just back when they were using excel templates to make you plan your diet, I made an this solution as an easier method to plan your meals and track your macros!
@@LukeBarousse ah okay makes sense. My buddy used it while it was excel and got me on it when the app came out.
@@Warpgatez You were fortunate to start it then! 😅 Love me some RP tho, I'm still following the concepts of this diet to this day.
@@LukeBarousse Yeah, the downside is if you make a few mistakes or go back to re-tweak your diet plan more than twice it locks you out and you have to get in contact with them to reset it. Which is a huge "eh I learned what I needed to from this application, I don't need to pay for something that doesnt let me restart diets based on different stuff". Oh well.
Hope you are doing well Luke. It’s been a while. Take care
Hope you're doing well also, Bouseux! Sorry I've been absent for a little bit, went on a vacation for a little bit; BUT I should have a video launching this Friday (if everything goes right... ha). Thanks for checking in on me I appreciate it!!
Beyond Excel, how did you find what programs to use? Was it what was readily accessible to you right away by purchases, something that employers provided, or did you rely on mostly open source free programs? And how did you come to the conclusion that 'yeah, this is the best program for this'.
it really depends on what your employer and client is using. Throughout my career, I've learned the program that my team uses, whether that is Power BI, Tableau, or Python. It really depends on what the end-user wants the solution in. Some solutions were free and others weren't
@@LukeBarousse Excellent, Luke. My workplace actually has quite a few options available (and I found someone who knows PostGreSQL pretty well, which is one of the many). We also have Tableau and Power BI. I believe that my job in HR (I deal with metrics of incoming and outgoing employees and create business solutions) will lend to me creating useful projects and eventually dashboards. Hope so, anyway.
you are the best
thanks
🙌🏼 ha! No you are!!
Luke that Pandas 🐼 T-shirt is so cool. Where did you buy it? I want it lol 😂
🤣 ha thanks Daniel, I love this tshirt too! It's actually on Amazon! amzn.to/3Cp29xd
Maybe one day i'll have my own merch
This was eye opening. Just listening works. But I am usually alone at work. And would like some ideas for solo projects for a newbie to programming to go into my portfolio. I don't have a portfolio website for myself, but would like to add the experience on LinkedIn or the likes. I just cannot start working on Upwork because of the shifts I mentioned in your previous video. So I would like to get a little bit of experience in analysis and programming (I am learning R due to the Google Data Analytics Certificate) so I need lots of time for the projects. Are there any DIY Data projects for newbies like me? I searched Google but the projects mentioned there are either too difficult as I am new to programming or are very time consuming.
I was thinking maybe I should just ask my boss to give me sales data from his business and then talk with you on how to approach the analysis, if he even agrees to provide the data to me. Other than that, I just can't seem to get working on my portfolio. My Google Certification Capstone took me almost 2 months to complete due to time limitations.
I am sorry for my really long comments, I wish I could TL;DR them, but the TL;DR would remove the details that would make a person comprehend my situation on a fundamental level. This is Saudi Arabia. There is no team here. Expats just are thrown into a job and expected to do everything. My boss comes around at 11 usually. And we also have to do his job on the maintenance part. Basically, I do the job of my immediate Supervisor and he handles everything for the boss. And being Saudi Arabia, we cannot even raise our voice, because there is no rights here for expats, like literally. I hope you have a clearer picture of my situation. I have my family to take care of. And little to no savings. If I had savings, I wouldn't have stayed here. Most of my earnings go to my family to support them with the help of my sisters living in the US because I earn very less. They are trying to get me to the US but I cannot get a work visa if I have no experience and maintenance planner experience in Gulf nations are not appreciated there is no exposure to technical work in Gulf countries.
And the worst part of my job is that most people I do interact with are uneducated technicians from mostly Southeast Asian countries. I wish I hand't accepted this job in the first place. 4 years and I have learned how to work for others without any pay whatsoever. It had made me hate desk jobs because this is all there is to desk jobs, just work for bosses, have nothing to do with technical stuff unless you work in big companies like Google or NASA. But seeing you, Thu Vu, and your friends and others on CZcams and LinkedIn had given me hope for data analysis. The same thing happened with my CCNA, I saw an opportunity for it in the Saudi labor market, studied for 2 years and then when I finally got my cert, COVID-19 hit. And then Saudization hit me harder than COVID-19. I think I should just contact UNHCR to take me in as a refugee to some other country, LOL, at least there I can be around more people like you perhaps and learn from them.
WEll I think the biggest thing that you should commend yourself for is that you haven't given up. There are plenty of self-guided proects out there that you can check out. Many on CZcams and i've done more on platforms like Coursera and DataCamp. They are great for having you follow a plan to complete. BUT I really like this idea of getting data from your boss, as this would be a project you can use your current experience for. So I'd go for this! Keep your head up; you got this!
nice video, quick one what's the most convenient way to run Power Bi on Mac ?
I use Parallels as a Virtual Machine on my mac
6:38 Ken jee is the best😅
😂🤣 you caught it!
@@LukeBarousse yess man.
You guys are best 🔥
Hi Luke Can I ask you if vba is worth it? I didn't find anywhere that VBA is requested. I'd focus more on Python, SQL, Tableu, and some Excel. Unless vba being part of excel hence would be requested for a data analyst. Even though I always read and observed that python, Powerbi, SQL are somehow most used.
Yep, I agree with the skills you outlined above being more important that VBA. It isn't as much requested (and frankly I think it's a little outdated and not nearly as powerful as something like Python). In the example I shared with using excel and VBA, I was taking a college class that required the use of VBA. I used it once after this in a short project and haven't touched it since.
@@LukeBarousse Thank you very much. I appreciate a lot your feedback because actually I gave up using it, as it seemed so limited while R wasn't as catchy as python and less 'friendly'.
Hey Luke, first of all thank you for your videos. How would you send your results to your client? In a PDF with Explanations?
It really depends on the client and what format they want it in. If it is my boss; i'm probably giving her the insights via a power point; if its a client that is familiar with a tool; it may be just the code itself that I used. It really can truly vary depending on the client. BUT communication is always the key soft-skill needed when sharing these insights
how do u use power bi on mac .
Luke, your videos are so interesting and insightful :) Thanks a lot. Currently, I am figuring out which career path should I take? My MBTI personality type is INFP-T.
I am in a befuddled state, not sure which should I choose between Data Analyst or Full Stack Developer ( Web Development )
Could you please share your thoughts? Would like to hear from you.
Thanks in advance!!
Hey Anand, I'll be honest I'm partial to data analytics, but that's' just because of the career path I chose and what I'm working in currently. Not sure I am the best for helping you choose between the two, but I can say I love the field of data analytics and have no regrets in pursuing this.
@@LukeBarousse Luke, I deeply appreciate your reply to the message. :)
Hi, Can I get your meal macros calculator spread sheet somehow?
Link is in description 🙌🏼
Hey Luke I wanted to ask quick- do you think R- shiny apps are worth investing time and effort into? Mainly curious as to how I can leverage different r skills to stand out with employers. Thanks in advance!
Hey Jon, yeah, I think they can be; depending on if your employer/client will adapt to using them. R (and shiny apps) are very popular ways to communicate data insights. 'Thu Vu' has more content on her channel around this topic area and I suggest you check it out!
@@LukeBarousse You’re an outstanding human being luke, thanks again!
Background song's ?
Hi Luke, I'm an industrial engineering student graduating next year and got really interested in the field of data. I've been researching data analytics and data science and trying to figure out which one I should focus on. While studying I currently work at a marketing agency and work with the analytics for Google ads, Facebook ads, and Google Analytics. Would you recommend me to focus on learning the data analytics part, or the data science part? I want to combine industrial engineering knowledge with data skills to really stand out in my career.
It's really depends on whta your interest relies for either looking at data analytics or data science. For me, I more analyzing data; so data analytics is where I go. Those in Data science typically have a different (or even broader approach). I don't want to tell you what your passion is in; but personally I think the data analytics would be an easier path to start for what you are wanting to do with marketing.
@@LukeBarousse Thank you for the response! I've thought about focusing on Analytics because Industrial Engineering is mostly that from what I've observed. From what I've seen until now, I believe I should learn to learn the programming languages required to get more deeply into the raw data.
@@La_Maquina806 In this case i'd focus on the data analytics part over data science in general. Data Science can be a very broad area that includes many subject areas (like data analytics). So it sounds like you are on the correct path.
I was in banking sales but i want to switch to data analytics what to do
A lot of great projects can be found in banking!
I am wondering. How you could run PowerBI on a Mac ?
I use a virtual machine, Parallels
Hi Luke
What should I do after learn excel?
I can use excel and visualization in excel also but I don't know what I need to do next !!!
I heard that I can work as a data analysis with excel in the beginning but if I have data in an excel worksheet how can I know where to start?
I would get into learning SQL next as I discuss in this video: czcams.com/video/CC66RXeTn_4/video.html
While doing this make sure you're building up your portfolio!
@@LukeBarousse thanks for the advice 🌸
Thank you for the video also it's amazing 🌟
@@magns2623 Aw I appreciate this!! 🙌🏼
Do you have financial tracker application you made?Can you share it ? I want to track my finances.
I don't have a template to share, so sorry... mainly just my own finances in an excel sheet that I curated for my use. It wasn't to hard to build and I think it's a great project to undertake.
what for fresher?
😅
I'd still recommend this!
4:10 essbase error? Is that Hyperion?
No I don't think so
What happend if I live in another country?
Hey Carlos! What do you mean by this?
so how do I secure a job as data analyst through doing these kinds of projects ? I wanna standout in my resume
Yes! I feel like projects (like the one’s we demonstrated here) are more impactful than a degree or training alone. It helps show that you not only know the skills but also that you can apply them in a real world scenario 🙌🏼
@@LukeBarousse Thank you
“Avengers is the most ambitious crossover-“ 🤭
🤣😂
wow im so far from aall these
HI! Do you know some pages to do internships as a data analyst?
Hey Franchesca, what do you mean by pages?
@@LukeBarousse companies or web sites where you can do work internships
@@franchescaayala3421 My platform of choice for jobs is LinkedIn; it seems to have a lot of opportunities listed there for internships as well
Wait... You built the RP Diet app??
Ha! No I wish I did! I just made and application on Excel to make it easier to pick foods, when RP used to provide their templates via excel spreadsheets
Ok dude, let's forget everything but do you always work standing on your feet by hours ? I am really wondering that 🤔🤔😅
Yeah, the majority of the day I do stand; I do have a bar stool as well, that i'll sit sometimes as well during the day at the desk
Do you need a degree to become a data analyst?
Investigating this!
@@LukeBarousse Did you find an answer?
Got data?
Love me some data!
Found it nvm loool
😜 Glad you found it!
Oof, those curved monitors.....hnnnnnnnggg
ha! I love... may never go back to flat.. hahaha
Cannot take you seriously when you refer to an excel sheet as an "app"...
😂
Thank u Luke for this video ,I watched it Intel the last moment, I'm really enjoying watching ur videos , and I make sure to subscribe all the channels that u share with us , and yes I'd like to following the same steps that u gives us to know if it work with me or not , and I will text u back if any 🥰😊
Aw thanks for this Wafae, good luck with implementing these steps; you got it!