PROJECTS that landed Data Jobs for my Subscribers

Рет қаралды 291,434

Күн бұрын

Sign up to Morning Brew for free today 👉🏼 morningbrewdaily.com/lukebaro...
Have a project that helped land your job? - share here 👉🏼 lukeb.co/ShareProject
Data Nerds! I'm looking to start a series where I showcase projects that landed my subscribers jobs in data science, analytics, and/or engineering! Here are some of the projects we cover in this vid:
Emiliano - SkillQuery 👉🏼 skillquery.com/#Dashboard
Stern - Credit Card Approval 👉🏼 github.com/semasuka/Credit-ca...
Sven 👉🏼 ‪@CodingIsFun‬
Valentin 👉🏼 Avacados: www.valentinjoseph.com/Portfo...
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
00:00 Intro to Intro
00:28 Actual Intro
01:08 Skillquery
03:43 Credit Card Approval
06:06 ‪@CodingIsFun‬
07:30 I NEED YOUR HELP!!!
07:53 Avacoda Project
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.
#datanerd #dataanalyst #datascience

Пікірлер: 340

@LukeBarousse 2 жыл бұрын

Thanks Morning Brew for my daily news and inspiring me with project ideas! Sign up for free here 👉🏼 morningbrewdaily.com/lukebarousse

@baghdadsaida1140 Жыл бұрын

I used to like morning brew until they started pushing political agendas.

@nayeem3360 6 ай бұрын

Do you have a discord server ?

@Here4TheHeckOfIt 6 ай бұрын

I'd like to see an update on this very topic in 2024.

@andrewskusi6980 2 жыл бұрын

Got my first Data Analyst job this month that I’ll be starting Monday. I landed this position with no projects and no experience at all, just bachelors degree in Health Informatics and google data analytics certificate and doing pretty well on the interview. 🤷🏾‍♂️💯 best of luck to everyone

@Aby-zy4ku 2 жыл бұрын

Congrats! How did the job posting look like? What were some questions you got during the interview?

@ayubben2919 2 жыл бұрын

congrats!!!

@andrewskusi6980 2 жыл бұрын

@@Aby-zy4ku they were looking for someone with 1-2 years of experience. It’s a hospital so I guess my background in Health Informatics impressed them too. They didn’t ask of any projects or test me at the interview. The questions they asked were mostly behavioral. Some few questions about the data analysis tools I’ve used in the past and so on.

@LukeBarousse 2 жыл бұрын

@Andrews Kusi congrats on the new role! This is awesome to hear how you landed it with the google certificate and your prior experience in health informatics!!

@andrewskusi6980 2 жыл бұрын

@@LukeBarousse Thank you Luke

@emilianopenanaloza9058 2 жыл бұрын

Wow I just saw this, thank you so much for featuring me! That project was an immense amount of work so really appreciate the good sentiment!

@LukeBarousse 2 жыл бұрын

Emiliano!! No problem at all, awesome work on this project my dude; so fortunate to share it here!

@ShashankData 2 жыл бұрын

LOLOLOL Loving the cameo. Also the personal connection that the people had with the projects they were working on really brought the projects home

@LukeBarousse 2 жыл бұрын

Ha, glad you liked the Cameo! 😂 I probably should have asked first 😜

@arjunrajeshirke9933 2 жыл бұрын

You are simply one of the best Data Analyst teaching channels on KZfaq. God Bless You buddy :)

@LukeBarousse 2 жыл бұрын

Aw thanks so much for this Arjun!

@CodingIsFun 2 жыл бұрын

*Thank you so much for featuring my KZfaq channel in your video, Luke!* 🙏

@LukeBarousse 2 жыл бұрын

No probs at all, Sven! Thanks for sharing your experience!!

@ccleanon5576 Жыл бұрын

@LukeBarousse - Please consider doing a video on practical ‘step-by-step’ guidance on how to present your findings as a data professional. For example, for every presentation I must lead, I ask myself these questions, I am sure not to overlook these steps, I make sure I know XYZ about the data, etc. I struggle with preparing for meetings with C-Suite. I always wonder, “What, exactly, should I say to them?”. Real world examples are always helpful. Thank you so much for your work.

@KenJee_ds 2 жыл бұрын

These projects are 🔥

@enter_null 2 жыл бұрын

thank you (i'm the avocado guy hahaha)

@Seun-A-Ajayi 2 жыл бұрын

@@enter_null Good job boss

@sternsemasuka9716 2 жыл бұрын

Thank you Ken :)

@CodingIsFun 2 жыл бұрын

Thank you, Ken! :)

@ivanvinicios8509 4 ай бұрын

Thank you very much for this video and thanks to all the people that allow your data portfolio to be shared. I'm in the process of creating my first data project, and these examples helped me a lot.

@kenharp 2 жыл бұрын

You do such a great job on your videos, I find myself not even trying to skip through the sponsor section of the video and wanting to watch that section as well.

@LukeBarousse 2 жыл бұрын

Thanks for this Ken! Glad you are enjoying my content!

@archangel5437 2 жыл бұрын

As always, valuable and informative Luke. Great job, keep up the quality work

@LukeBarousse 2 жыл бұрын

Aw thanks so much for this!!

@EkeomaEAGU-wq2kb Жыл бұрын

Hi Luke, Thanks for sharing, this is probably the first time I will be hitting the like button on any KZfaq video. This one really got to me, and I appreciate the effort you made in putting this together.

@LukeBarousse Жыл бұрын

Aw heck yeah! Glad I could share these portfolio projects from these talented data nerds!

@gmsammyguitar Жыл бұрын

Luke, you totally rock! Love these videos

@mastersteve78 Жыл бұрын

I am still looking for my first data job. Just graduated from BloomTech and wanted to work on some more projects to give me a stronger chance of being hired. Thank you for these suggestions.

@craigjelf1 Жыл бұрын

This is super insightful. Thanks, Luke. Would you ever consider doing a video on the step-by-step process of how to approach creating a project? I want to begin working on projects for my portfolio but the process seems overwhelming and I'm afraid I'll miss out on crucial steps due to lacking knowledge in certain areas.

@pingyang8357 2 жыл бұрын

Thanks, Luke! this video is super useful and inspiring, I am setting my goal to complete a project like this.

@LukeBarousse 2 жыл бұрын

Heck yeah, good luck with the project!

@ryanyablonski2144 2 жыл бұрын

It's wild how new college students don't know these fields exist I remember being a polysci student twisting all my papers into what I vaguely understood was systems analysis to make predictions.. turns out I was into data science back then I didn't know what to call it or how to pursue it

@LukeBarousse 2 жыл бұрын

Yeah so true... tbh I worked in a data analyst type role and didn't even know it was working in the realm of data science... so I can really relate to this.

@densaket 2 жыл бұрын

Same here!

@Aydeenyce Жыл бұрын

Same

@ipodtouch470 Жыл бұрын

I did not realize how much data political science were exposed too. Had a buddy who worked on a campaign for his senior internship, the main thing he did was make sql queries.

@ghernandez2116 2 жыл бұрын

Thanks for the great video, Luke! This is very helpful 💯

@LukeBarousse 2 жыл бұрын

So glad this was helpful, Geronimo!

@Thuvu5 2 жыл бұрын

Ahhh I’m late to the party! 🤯 These projects are AMAZING🔥. Loved the ‘going above and beyond’ spirit!! I got such a big dose of inspiration.. gotta get back to my projects now! 🏃‍♀️🤣

@LukeBarousse 2 жыл бұрын

Ha! I felt the same about getting back to the projects... they put my projects to shame!

@user-gr3ue9nl3v 8 ай бұрын

I am taking the Google data analytics certificate course. When I learn more id like to do a project around the homeless problem, which is weird considering I am homeless myself at the moment. I enjoy your channel Luke. Keep up the good work!

@gamersant7466 2 жыл бұрын

This is exactly what I was planning to do. Selected few of the unique problems for my project which everyone is seeing on the news but very less think of solving it. I already had a project similar to the avocado project in collaboration with my 2other classmates where we had the ML, email verification, web session session allotment, a beautiful frontend defining the details in the simplest way, but I am looking so something on my own. And I also learned something which might be a good idea which is "if you are being lazy in learning start teaching that to others" in that way I will research on that and will be able to master it. Let's see what's the future holds for me. But I am confident that I am gonna do good in future 😊. Have plans to open a you tube channel. Starting to talk about tableau coz I am really passionate about the visualizations.

@LukeBarousse 2 жыл бұрын

Heck yeah, thanks for sharing your project experience Santos’s!! Good luck with your future endeavors, highly recommend starting the KZfaq channel!

@acsy10000 2 жыл бұрын

Very nice topic! Very helpful if you want to start working in your own portofolio. Thanks for the video!

@LukeBarousse 2 жыл бұрын

Aw thanks for this Marius!!

@MorrisandApril Жыл бұрын

I am sure that so many people thank you for your channel. I am deeply appreciative for your channel because this give me the much needed information that I need for changing my career later in life and giving my family better opportunities. Thank you 100 times for all of your hard word. You are my go to as well as Thu Vu. I think she even is the reason I know of your channel. Thank you both! - April

@LukeBarousse Жыл бұрын

Aw thank you so much for this thoughtful note! Glad you're getting use out of the videos! Thu Vu is the best🙌🏼

@meghk5147 2 жыл бұрын

I just came back to this video solely to comment that I just saw you in a submarine documentary today!! My husband is a submarine officer about to end his shore tour and transition out of the navy. We’ve been watching lots of submarine docs and KZfaq videos recently lol

@LukeBarousse 2 жыл бұрын

😂🤣 oh no… I was hoping nobody ever saw that video 🙈 ha! Good luck with y’all’s transition out of the Navy!

@TapiwaWakatamaVHP 2 жыл бұрын

Excellent video. This is the type of advice I’m looking for. Thanks

@LukeBarousse 2 жыл бұрын

Glad it was helpful, Tapiwa!!

@walegbads 2 жыл бұрын

Luke always killing it! 💪😁

@LukeBarousse 2 жыл бұрын

😜 Trying to keep up with you my dude!!

@unpatel1 2 жыл бұрын

This was a great video. Very informative. Thank you.

@LukeBarousse 2 жыл бұрын

Glad you found it informative, Umesh!

@ArunKumar-bp5lo Жыл бұрын

i need a more videos like this .reviewing top data science projects

@thedataguy3863 2 жыл бұрын

Another great video drop! I love seeing the real life projects + real stories.

@LukeBarousse 2 жыл бұрын

WHO IS THIS!?! AND WHAT HAVE YOU DONE WITH THE REAL BEN?!?!

@SeattleDataGuy 2 жыл бұрын

@@LukeBarousse I honestly forgot I was on my other account.

@LukeBarousse 2 жыл бұрын

@@SeattleDataGuy I was wondering 🤣Sometimes I comment from my other account just to throw people off.. haha

@CodeEmporium 2 жыл бұрын

I absolutely love this format of video!

@LukeBarousse 2 жыл бұрын

My dude!!! So good getting to meet you in person this past weekend. We gotta all get together again soon!!!

@CodeEmporium 2 жыл бұрын

@@LukeBarousse We definitely will

@CodeEmporium 2 жыл бұрын

In the mean time, hit me up if you want to collaborate on something

@dumisaralane 2 жыл бұрын

Cool projects, thanks for sharing Luke :-)

@LukeBarousse 2 жыл бұрын

Heck yeah, no problem at all, Dumisa!

@enter_null 2 жыл бұрын

Thank you for sharing my project on avocados :) awesome projects from everyone :D

@sternsemasuka9716 2 жыл бұрын

Great job Val! 😊

@LukeBarousse 2 жыл бұрын

Excellent work on the project, Valentin! Thanks for sharing it with the community!

@ShashankData 2 жыл бұрын

That was an amazing project!

@enter_null 2 жыл бұрын

@@sternsemasuka9716 you too Stern!!

@TheMISBlog 2 жыл бұрын

Great Video Luke, Thanks

@LukeBarousse 2 жыл бұрын

Aw thank you!!

@psfgtech Жыл бұрын

Great breakdown, like morning brew too

@emmanuelrodriguez1970 2 жыл бұрын

I know your main focus is on data in the business realm. Do you have any tips for public policy or more social related development tips??? This would be GREATLY helpful. ❤️

@behrad9712 Жыл бұрын

thank you so much!🙏

@wafaeelhijary5163 2 жыл бұрын

Yes I did, I get value , I'm really thank u for ur effort to give us a great content 😇😇🌹🌹

@LukeBarousse 2 жыл бұрын

Thank you so much for this, Wafae!!

@smellypunks 2 жыл бұрын

Great to see what others are working on and what tech they are using. Seems like Python is becoming more widely used not just SQL.

@LukeBarousse 2 жыл бұрын

Yeah, I think Python is def catching up with SQL

@YasinNabi 2 жыл бұрын

woww this video is a wonderful video and pushed me to some other videos in your channel. great content. thanks for uploads. .,,.

@LukeBarousse 2 жыл бұрын

Heck yeah, so glad you found the channel, Yasmin!!

@davidmiller-td1sl 2 жыл бұрын

Prettty hefty projects! I wonder if I could find a data set for the relative fitness levels of people that switch to E-bikes?

@LukeBarousse 2 жыл бұрын

I bet you would find a high correlation between the amount of fun they had and the power of the e-bike! 😜🤪

@konstantinradu4399 2 жыл бұрын

Hi Luke, got my first interview with the firm, despite not having a project they wanted to hire me, and weren’t even interested in projects I Would have done. They have seen my interest in analytics and they way I was describing each stage of data cleaning and storytelling. Not sure but I’ll likely be hired as an intern. Thank you very much

@LukeBarousse 2 жыл бұрын

This is awesome to hear Konstantin!! Here's to hoping for the intership, Konstantin! 🙏🏼

@jamesessiet1339 2 жыл бұрын

Wishing you the best Konstantin

@konstantinradu4399 2 жыл бұрын

I had a online interview to record for Goldman Sachs for internal audit. Offerings are coming so Hoping the best. Thanks guys

@andrewskusi6980 2 жыл бұрын

@@konstantinradu4399 keep we updated

@LukeBarousse 2 жыл бұрын

@@konstantinradu4399 you got this Konstantin!!

@eduardofreire3387 6 ай бұрын

Dude, that's cool, you gave me several insights to enrich my portfolio; At the moment, I'm leaving my job, and I want to add my experience in management (I'm a customer experience coordinator) with data that I'm passionate about and have been using for a long time; I want this upgrade for my customer service coordination career, operations with BI is the combo. Thank you very much! Hugs Edu, straight from São Paulo | Brazil

@LukeBarousse 6 ай бұрын

Good luck with the transition! You got this!

@aashishmalhotra Жыл бұрын

Bro love ya really helpful

@uditghosh3247 2 жыл бұрын

Hey Luke, I've another suggestion. How about sharing links of some projects, like some honorable mentions that couldn't make up to the video , but would be good for us to look upto? It would be really helpful. Cheers!!

@LukeBarousse 2 жыл бұрын

I like this idea!! Let me see what I can do, looking to make a spreadsheet or something to share these projects with the channel.

@relax9286 2 жыл бұрын

I just saw your course on Power BI in datacamp! I'm planning on taking it.

@LukeBarousse 2 жыл бұрын

Heck yeah! I hope you enjoy it, that was a fun one to make!

@AhmadArain_UK 2 жыл бұрын

Love the Content, It's Very helpful to Build a Better Career. 👌

@LukeBarousse 2 жыл бұрын

Thanks so much for this Ahmad!

@sternsemasuka9716 2 жыл бұрын

Thank you Luke for featuring my project 😊

@LukeBarousse 2 жыл бұрын

Thank you for sharing your project Stern!!!

@ShashankData 2 жыл бұрын

Loved the personal motivation behind your project

@sternsemasuka9716 2 жыл бұрын

Thank you @@ShashankData

@syhusada1130 2 жыл бұрын

Great, I'll read up on Valentin's project.

@LukeBarousse 2 жыл бұрын

Heck yeah! Check it out!

@gurmanjotsingh4081 9 ай бұрын

That's wonderful, being a fresher I personally believe that Projects fills up the lack of experience in my resume. Though I was wondering, If you could mention some free platform to deploy & showcase our data science projects

@ashalonchiq 2 жыл бұрын

Luke, this question isn't related to taking on data projects but rather a concept: Data Analytics Life Cycle. Do you utilize the CRISP-DM model when conducting your projects in a professional setting? I'm currently taking a graduate course and wanted to know your thoughts. Thanks for your content, it's been a great help in my career.

@LukeBarousse 2 жыл бұрын

I don't use CRISP-DM in my projects, but it looks like a good framework to know of and learn.

@aatapiap 2 жыл бұрын

wonderful video!

@LukeBarousse 2 жыл бұрын

Thank you very much, Andy!

@lukexu2674 Жыл бұрын

Hi, Luke. Fantastic video! May I ask where to find a unique dataset? I found it may be too time consuming and difficult to collect data by myself

@sonujossyabraham 2 жыл бұрын

I'm new to data science. I find your videos as well as Shashank's videos extremely useful. Thanks Luke

@LukeBarousse 2 жыл бұрын

Well welcome to the community, glad you are finding them useful!

@jghormley69 2 жыл бұрын

love how you have Tina and Shash in the background like easter eggs =)

@LukeBarousse 2 жыл бұрын

Ha! Trying to hide them!

@almullaonline Жыл бұрын

To help summarize this great video, here are the Key tips to make your project stand out: 👇 1- Projects that help other people 2- A dataset that is unique and has a common interest with the person 3- Coding everyone can do, summarizing and visualizing data is what showcase YOU 4- Create your own data analysis ecosystem (Your own dataset, insights, and all the above points) All are free to add, edit or enhance the above points 🙏

@briabree7683 Жыл бұрын

I'm currently doing my google certificate in data analytics, however, up until i watched your videox i didn't realise that there was this much that went into landing a job in data anlytics, I don't know where to start now

@safeerahmad7547 2 жыл бұрын

Great, Very helpful 😃

@LukeBarousse 2 жыл бұрын

Glad it was helpful, Safeer!

@imemmag 2 жыл бұрын

I've failed you, I missed your two last uploads. But now I'm catching up! Great content as always. I don't have a degree, and I'm working in digital analytics after completing the Google certificate and while taking some courses. Tomorrow I have an interview for the Disney regional BI team, as well as another one for a senior analyst role for a global marketing agency. So good things are happening in south america job market.

@LukeBarousse 2 жыл бұрын

Emanuel, this is so awesome to hear! Good luck on the interviews my dude, I’m sure you are going to do well! Thanks for tuning into my content!

@shraddharattnel6435 Жыл бұрын

After completing Google Certificate did you do any projects , i am about to complete the course i don't have prior experience and i have done a course on MySQL bootcamp, i am kind of scared will i get any job cuz its new and i am not even sure if i am right for this stream.

@pritamchougale Жыл бұрын

This is really nice projects to know about, thanks for making this video. I have one question where do these people got the data from? Did they use any scrapers and also to build the dashboard like this one should use BI tool or no code tool ? Thanks actually I am new to data analytics, learning on my own

@nishitambresh8691 Жыл бұрын

@KhaiTran-se7sn Жыл бұрын

Do you guys know how long will the project take? Maybe 2-3 months? I'm thinking of starting my own SQL-Tableau project.

@bigtuna16 2 жыл бұрын

Hey Luke! Was wondering if you could do a video or a simple recommendation on some good books for people interested in data analytics. I’m on part 4 of the google certificate and am interested in reading some useful books in my free time! Thanks ahead of time!

@LukeBarousse 2 жыл бұрын

Yeah let me see what I can do on this topic, def something i'm interested in sharing!

@northpaul3276 2 жыл бұрын

Hey Luke, long time from your last video, is everything ok? Would like to see you cover the topic of a/b tests in the future🙂

@LukeBarousse 2 жыл бұрын

Hey! Yeah everything is good! New video coming out on Monday… I got a little behind due to traveling and collabs, but hope to return to normal soon!! Also thank you for the video recommendation, let me see what I can do on this!

@emiliamatrejek5605 Жыл бұрын

Hello, I am really impressed by the projects. This summer I started my pathway to become a data scientist, following Luke's steps. I would like to make a project similar to the one from Milano, but for job market in Poland, especially student job market. Could anybody give me an advice, how to jump into writing a kind of crawler, getting the keywords from job offers? I already know Excel, SQL, Power BI tools and basics of R (I was writing a project about decision trees in R). I know that my programming skills aren't good enough to make this project even this summer, but I would like to know which direction to follow and get some learning resources that may help me. For now, coding something that will crawl through the web sounds impossible to me :)

@gabrielroomvm6209 Жыл бұрын

with all that knowledge... my advice is just finish it! Best Luck!!

@BlazinStreets 2 жыл бұрын

Somehow you just know how (and when) to come up in my algorithm… this is exactly what I needed to know upon trying to land a Data Analyst position… I needed a direction on my capstone project and this was it! Thank you!

@LukeBarousse 2 жыл бұрын

Ha! I'm glad this video could help, good luck with the project!

@ILOVEISLAM-cw1io 8 ай бұрын

thanks

@user-xz9pq5ko5o 4 ай бұрын

Hi. How would one get the dataset for the first project? I have some ideas for is as well. But how to get a good, relevant dataset on jobs and skills?

@GUARIVERA81 2 жыл бұрын

I got my first data analyst role without a degree and the project from a previous job help land my job.

@LukeBarousse 2 жыл бұрын

Heck yeah! I’m looking for people like you, Pito!! Is the project shareable?!?

@tfritch34 2 жыл бұрын

@@LukeBarousse I am in the process of this right now - I do not have a BA, but I do have a couple of professional certs and 5 years of leadership in Quality Assurance. I am cleaning a couple of datasets that I built for my current job to showcase how building a metric scoring system to evaluate sales performance per item they sell can lead to increased profits and lower cost of quality through disputes and returns. Once I have all personalized information cleaned from the datasets, I would like to put together a blog style portfolio that showcases a TLDR style of highlights and screenshots of the process from building a metric system to where I have presented a dashboard to executive staff members to create actionable tasks for the company.

@LukeBarousse 2 жыл бұрын

@@tfritch34 This is awesome to hear, Tanner; let me know how it goes! I like the idea of putting to gether the blog style portfolio, this is an excellent idea. Love me some QA BTW

@ahmedmostafa8751 2 жыл бұрын

Im in quality field also (process control) What type of projects can help

@jabba8417 2 жыл бұрын

These projects are amazing! I have a question though. Say I’ve just finished a project, and the core of it is made with SQL.. what platform can I showcase the code at? As far as I know, github and notebooks are for programming languages like python and r.. how about SQL?

@o0laieta0o 2 жыл бұрын

I would say you can write it in a readme if it's not that long, but following for Luke's response lol

@umarahmed6853 2 жыл бұрын

@LukeBarousse 2 жыл бұрын

Yeah, sql is perfectly fine to be shared on GitHub. That’s how Valentin shared his SQL code. I also agree with Laia that you could use the readme to highlight specific things about the code you want to highlight

@dakotasmith57 2 жыл бұрын

I use Medium to publish the story part, and within that hyperlink to my SQL in GitHub. Medium has a simple GitHub snippet integration too so if you want to break your code into pieces to explain what you're doing/why in the story you can do that as well!

@adamtoth7679 Жыл бұрын

Great video! It's been a year since this one, I think you should make a new one! 💙

@nayeem3905 2 жыл бұрын

Luke, any statistic methods that we should know before going for interviews? Thank you

@LukeBarousse 2 жыл бұрын

I think a basic understanding in probability and statistics is good enough. I actually have an upcomign video on this so stay tuned

@Mitang188 2 жыл бұрын

Hi Luke, Thank you for all the great job videos! I'm working at a small company that manages data only using Excel. Do you have any plan to make a video about gathering data from multiple Excel sources automatically using Python? Good luck, and keep up the great work!

@LukeBarousse 2 жыл бұрын

Hey Rai Kou, let me see what I can do on this topic, thanks for the suggestion and also thanks for the positive vibes!!

@GerryThePigeon 2 жыл бұрын

I want to get involved with football/soccer metrics, I think that will be the area I’ll be most passionate about and hopefully I can create something useful for others

@LukeBarousse 2 жыл бұрын

Always great to go with a project that is aligned with your passion!

@reynardtcloete6959 2 жыл бұрын

I think I speak for everybody when I say everybody likes you bro. Thanks for the cool channel.

@LukeBarousse 2 жыл бұрын

My dude, thanks so much for the positivity and kind words! 🤙🏼

@muhammadqasim8978 Жыл бұрын

i am learning excel and i want excel projects for data analysis but you share only related to SQL

@JavedKhan1588 2 жыл бұрын

I am going to give you good news about my story. But let me tell you one thing upfront, please keep up your youtube efforts. You are helping people beyond your comprehension.

@LukeBarousse 2 жыл бұрын

Aw thanks for the positive vibes Javed!! Excited to hear the good news about your story

@kokinuts Жыл бұрын

Hi Luke, love the videos. I was wondering after completing the google analytics cert, should I start doing projects? And how many projects should I do?

@LukeBarousse Жыл бұрын

I highly recommend getting into projects. I don't think you should worry about number of projects but quality of projects and that they are helping you learn new skills

@kokinuts Жыл бұрын

@@LukeBarousse thanks Luke for getting back to me. I’ll do projects after the google cert 🤙

@maheshghorsaine6919 2 жыл бұрын

Hey Luke. I have a question. How do you use same mouse and keyboard for both laptop and desktop computer? Thanks for great content.

@LukeBarousse 2 жыл бұрын

My Laptop is connected to those monitors, so it just goes through the laptop

@nzothemage2624 2 жыл бұрын

Long term listener first time caller. I think what's lacking on this channel & others similar is the narrowed focus on SQL & a BI tool. That may be enough for a Business Analyst job, but you're going to be expected to know a lot more for a Data Analyst position, especially at a tech company or you will suffer from imposter syndrome.

@LukeBarousse 2 жыл бұрын

Thanks for sharing this perspective, def will try in the future to include different tools

@nashbalraj971 2 жыл бұрын

Hi great video really helpful, unrelated note to the video but what databases will you recommend for a startup to manage data across Africa

@LukeBarousse 2 жыл бұрын

Thanks! And it really depends what data your tyring to store. If its mostly tabular than I'm a fan of Postgres... but that's just personal opinion and there really are a lot of good options. I made a whole video on my recommendations: kzfaq.info/get/bejne/fatyrdarncC3iKc.html

@harsingh6451 2 жыл бұрын

Hi Luke, fantastic video. I am from the UK and have recently decided to change my career and become a Data Analyst. Would you recommend completing the google data analytics course as the first step? I would love to learn data analytics skills and land my first role. Would you be able to provide a few tips on the starting point? much appreciated. Thank you.

@LukeBarousse 2 жыл бұрын

Yeah I think you found my follow on video that answers your question. (judging by your comment on my How I would learn to be a Data Analyst). But if not, yeah, I recommend starting with the google certificate.

@rushilkeshav4977 10 ай бұрын

Relating to the Avacado project, all of this can be done in Excel, from data cleaning to the reports without having to type a single code. What makes SQL so special to land a data analyst job? I feel like I'm missing something, but none of the projects mentioned here are hard to do within Excel itself. I know Excel can lag the bigger the file gets, so I can then understand why SQL Table would work better. But everywhere I look people are cleaning data on Excel and storing it as tables on SQL. There's a few queries to pull data, however it's faster to get the solutions to these queries on Excel through the formulas.

@LukeBarousse 10 ай бұрын

Not sure if you checked it out, but I have a video on How I use SQL; think it'll answer the difference on why this tool is important

@rushilkeshav4977 10 ай бұрын

@@LukeBarousse Thanks, had a look at the video. It gives a lot of insight as to why SQL is relevant. Seems like Excel is good if you have smaller sets of data and if there is a lot of data across multiple sources then SQL is best.

@kaosisoakam7113 Жыл бұрын

Please I'm just starting up as a Data Analyst and I'm starting with Excel, where can I find Excel Problems to solve or Excel projects that I can use to build my portfolio to showcase during interview.

@johnbarrington2526 Жыл бұрын

Where is a good place to find datasets for projects?

@beenay18 Жыл бұрын

can i run excel in system tray and display just the user form on the screen? I don't want the users to mess up the excel file. I just want to get the job done via user form like standalone app. i dont want excel to be displayed on screen or task bar.

@Jules-69lol 11 ай бұрын

Well I definitely can't afford any certificate whatsoever, I hope having a nice portfolio will compensate, I'm quite nervous about it ngl

@romanreigns8184 2 жыл бұрын

How to become associate product manager , please make a video on this topic

@LukeBarousse 2 жыл бұрын

let me see what I can do on this

@lazytocook Жыл бұрын

should the portfolio always be on github or its ok to open my own domain and put my portfolio there? Thanks Luke for the help u have given us. You are an awesome brother.

@LukeBarousse Жыл бұрын

Yeah perfectly fine to not be on github; for code I feel it's the best place to host as it's made for this... but then if you're doing something else then a portfolio website would be better. I have a video on portfolio websites

@izd129 4 ай бұрын

how and where did the first guy get the data from?

@solidpomp3185 Жыл бұрын

Are all of these projects doable after only doing the google certificate?

@SebaVargas1 2 жыл бұрын

Hi, Luke! Great content, as usual! I have just started the Google certificate. I was wondering how possible (if possible at all) it would be to get a remote job from a US-based company for someone from Chile, or do you know anyone who would know this? Thanks!

@LukeBarousse 2 жыл бұрын

Hey Sebastian, this is a topic i've been trying to research but haven't found much information on. Will share if I get any information on this!

@joshthomas6493 Жыл бұрын

@@LukeBarousse I just finished the DA Google Certification and about to do 1-3 projects to get some more experience under my belt while still getting my resume up on linkedin in the meantime. This is my big question too. I'm American but living outside the US for the last 3 years and just hoping I can find a remote job that won't require me to be in the US or at least with very minimal travel back. I'll keep you posted because I'll be doing just this although a little different since I'm American and have a US address and bank account.

@stephentitus9902 2 жыл бұрын

This is such a good show don't tell bunch of examples!

@LukeBarousse 2 жыл бұрын

Heck yeah! Thanks for this, Stephen!

@guillermolapelosa2062 2 жыл бұрын

hi luke, have you tried knime analytics platform? and what's your opinion on low coding data science.?

@LukeBarousse 2 жыл бұрын

I think they are a viable option and seen them used by members I work with... just don't feel that things like this are as highly stressed as tools like Excel, SQL, Python, R, Power BI, and/or Tableau

@finance596 Жыл бұрын

Hi, i am working with a USA based MNC and having experience in P&C insurance and now i want to change my career in data analyst field so what you will suggest for me, i am not getting a idea from where should i start.

@chrisaycock5965 2 жыл бұрын

I already have 3 ideas I want to do when I finish my certificate… so we’ll see hopefully it’ll get me an entry level job.

@LukeBarousse 2 жыл бұрын

Heck yeah! Love to hear this! Good luck with the project!

@AlexMar-r Жыл бұрын

Luke 4 months ago i took your suggestion about taking the coursera Data Analytic course, i'm done all i need is to pick a dataset as my Capstone project. any suggestions for a Relevant Dataset that would shine on my resume (like to think i'm an Orange Belt ) ? ill appreciate from the heart .

@LukeBarousse Жыл бұрын

I’d pick a dataset unique to you. Doesn’t have to be big or fancy. Something you have an interest in so this emotion will be conveyed to your interviewer

@SubhaForever21 2 жыл бұрын

Hi Luke, please kindly help me should i have to complete the case study project and than finish the course or just complete the full course get certificate than do the project? I'm a new to this course don't have a any background in this field please help and show me how to do the project. Thanks

@LukeBarousse 2 жыл бұрын

Hey Subhathra, what course are you referring to?

@shresthaditya2950 Жыл бұрын

1:42-Solve real problems 3:08-Used Entire Data Science Pipeline 4:14- 4:35- 6:33- 9:02-

@aditijamahangoe7456 Жыл бұрын

Can someone tell me where i can find remote data jobs?

@La_Maquina806 2 жыл бұрын

I want to start a project helping my swim coach keep track of his swimmers’ progress and energy levels with swim meets and VO2 max tests that he does. It would factor in the times he/she would do in the meets or tests and also the heart rate after said meets or tests. Until now it sounds like a simpler project I can do with an excel spreadsheet. My question is: Which excel for data analysis course would fit best for this type of project starting out? The Excel Basics for data analytics, or the excel skills for business specialization? I would like to start off with the essential skills to accomplish my coach’s goal and then start diving deeper in the subjects of excel and SQL and the other programming languages.

@LukeBarousse 2 жыл бұрын

I think the excel skills for business may be a better option in understanding all the aspects of Excel that are important; so that would be my recommendation. But overall, the project that you are about to take on sounds super interesting and def doable in Excel!