Great Luke, we'll be following the series. Hey guys, I am glad to announce that I have started a new role, my first full-time DA job, as a Business Analyst for a global Supply Chain and Logistics company. For context, I've been working for almost 10 years in project management roles and made a move beginning this year to switch to data analytics. I'm from Ghana - West Africa and hold a BSc. degree. Thanks, Luke and all of you who were an inspiration.
Great video, Luke! As I'm still dipping my toe in learning SQL, Python & Tableau, I'm leaning heavy on my industry knowledge to find data sets. Thanks for makin' me feel as if I'm on the right track!
Thanks Sai!! Not sure if you noticed this but when I was answering comments In this video. One of the comments I was answering was from you back when I had 700 subs. Hahahaha we’ve come quite a ways
@@LukeBarousse yeah i saw the notification, i rememeber subscribing to your channel back when it was 500 subs and my personal fav video where you discuss "M1 macbook - python packages capabilities". Crazy journey, and long way to go. 100k now and then 1 million
I have been inspired by your TH-cam videos. Every month we get a 2500 row excel with different transplant patients data. I have some ideas on what questions I want this to answer and hope to use it to develop analysis skills. Do you have any videos that specifically talk about cleaning data?
Hello luke, You've been doing a great job sharing information and values towards as a data analyst. One question as a beginner which tool should i start with as a data analyst student. And thanks for all the info
Fantastic Luke ! This is exactly what I needed now . Also Ive got one more question Luke . Being a student how do i learn more about a domain since i dont have hands on experience with the field . i dont know how each attribute contribute to the data set as a whole. Can you post a video about how to learn more abt domain before working on a dataset ?
Hey luke im working on a similar project as yours trying to build a chatbot to whom i can ask about the latest job posting in the field of ML/Data analysis and he would reply me with "these are the latest job posting in the field of Ml/Data analysis" for this im using dialogue flow to train my bot with the intent and entity then trying to connect the webhook to the backend of my flask framework the problem is i thought i could just use an api of LinkedIn or glass door or any such platform but now i get to know that's not possible and im stuck now after researching i found i should use a crawler that would get me all the data from these playform but i don't know how to proceed further it feel like im stuck with my project kindly help!
Hi luke what do you think i have to focus if i want to become an it security and compliance analyst. Please help me because i don’t know where to start.
'What problem are you trying to solve' , is it same as 'Frame the business question you want to answer ', example, What factors are associated with low sales?
What are good data sets to use for a project. Like i want to organize my music (which is over 800 different mp3 files) is lack of organization a problem or do i need to answer a specific question?
Great video Luke, but i would like to also say that you have great communication and presentation skills..I think you can absolutely make some videos about that giving us data nerds some tips and tricks
"Finding the problems and keep it in mind during the whole project is the key components all the Data Analyst should maintained " this is the key things I learned from coursera and now got the detailed overview of this from this vedio Thanks luke💖💖 for this kind of great vedio.
Love this channel. I'm really excited to get back to Data Analytics. I've been taking care of my dad (dementia) he is no longer with us. So now back to focusing on the Analytics. I've got a background in management, real estate, and government contracting.
Awe thanks for following along LaTonya. So sorry to hear about your father. My Dad actually passed away recently (so I feel your pain 😢). I like that you are using analytics to get back into it, I'm motivated by this!
@@LukeBarousse lol...I could look at my life as a tragedy as I am the only 1st generation person left living in my immediate family (Dad-Died in 10/2020, Mom-Died Cancer, Brother-Heartattack@48). But striving for this Google certification gives me a new focus and all I see is the opportunity, guess I am a glass-half-full kinda personality.😃
@@LaTonyaHiggins Well i'm motivated by your passion and desire to succeed. I hope this cert gives you some new-found motivation as I think you'll excel in data analytics with your positive attitude!
Hi Luke, can you give me some advice, I am curiently working on a project in which I have to extract the data from a local SQL database, which comes from biometric attendance device, and integrate it into a program called Zoho People which is also time and attendance program, i have been folowing advice from Zoho team of building a plugin caled Tomcat Apache which uses java but someting isnt right it does not get the data. Do you thing there is another better way, maybe using Python or other tools ?
That's a great question. It really depends. If you don't know the data source then you may have to perform an indepth EDA to see if it credible. But I don't think there is a one-size fits all approach for this
Hey Bouseux, thank you so much for checking in! I've been missing making content. Unfortunately, I had a death in my family and had to take a break for a bit. Hope to have a new video in the next week or two!! I hope you are well too my friend!
@@bouseuxlatache4140 Aww thanks so much for this Bouseux. I very much appreciate it! Just got back into making the next video so stay tuned and take care as well!
Hi there! my old laptop is dead and I need an urgent one. I thought about buying a Mac book air m1 with 16 gb RAM and 256 gb SSD for university use (taking advantage of the discount) and I am thinking about the possibility of doing a master in "big data and business analytics". It is not sure but I wanted to know if it would be ok for that and excel, sql, power BI, access. Or if I should buy a windows pc. I saw that in a previous video of yours you had compared it to a Dell but this one is more expensive. Thanks in advance. 🙏
Due to overzeal, I embarked on a project only to find out that the problem has already been solved by someone else. I found this half-way and since then I was demotivated to complete the project. Piece of advice: research thoroughly your problem first. Chances are a solution already exists. Maybe it only needs customization to your context.
Just because a project already exists to solve a problem doesn't mean you can't continue with it and potentially design a better solution. Better yet, you may find that the other project has faults!
I recently made a mistake and got a dataset before I hopped on a plane ride and started to clean the data once the plane took off. I thought it would be a quick and easy Tableau project but I had more questions and needed to look up how to somethings in Tableau. Lesson learned.....
Ha! Thanks for sharing this lesson Abe! I always feel i'm going to accomplish large tasks on plane trips and inevitably result to napping the entire trip.
probably my most viewed channel. im very much interested in this and mainly the tools used. so can there be a detailed step-by-step guide on how the tasks are carried out?
This video came in time for me. I have a project that I thought was just fine for getting data from a website that updates its stats on players and teams in the EPL (English Premier League). I scraped the site using python with the aid of Selenium, Beautiful Soup and Requests libraries, then I used pandas to load the data and clean it up, the n matplotlib to visualize that data. All of that was done in Jupyter Labs IDE, and for me it was fine. But now I'm thinking of exactly what you're trying to do, because I need to look at historical trends for even better analysis, which a database would be useful for, and I need even better and more seamless visualization which I'm thinking Tableau would be useful for. Long story short, my roadblocks are first getting a database to load it into every game week, and also to find a way to get the code to run that automatically (preferably on the cloud, I was thinking AWS Lsmbda but I'm still learning about that). Any help on this is greatly appreciated.
I think you're off to a great start and this is all part of the learning journey. From what you've shared I think you are looking into the right solutions, so just keep up the hard work!
@@LukeBarousse Thanks for the reply!. I see that this video is quite old, do you have one where you show how you used the database?. Or should I just use excel as a database for now?
I am a bit more than halfway done with my project. This is what I did/am doing: 1. Imagined I was a consultant who received a problem from a client: They want to know where they should place new shops 2. I created a few questions of my own: a. if I combine all of the zip codes in a greater area, are there fewer existing shops in certain zip codes? b. is there a correlation between income or population and the number of shops in the zip code (ie. does the average income mean there will be more shops). 3. Collected my data from two sources: State license to find out where the shops are located and census income/zip data. 4. Cleaned the data. 5. Today I will do my calculations and predictions from above then decide if I can come up with more questions. 6. Make my predictions presentable for the general public. Then I will package it for opinions online (Kaggle? )
This is awesome! Loved how you stepped through your thought process for creating a project and how you are tackling. THIS is exactly the thought process that employers want to see when hiring. Keep up the awesome work, looking forward to the results!
Great video! Looking forward to the series... then the book! Hey, like the TH-cam founders Gutenberg solved the 'I would like to self-publish some books' problem 600 years ago! Your fingers are already on the keyboard anyway ;-) Cheers!
@@LukeBarousse Seriously, I think you could look at doing a book in the 'Teach Yourself Visually ...' book series, perfect format for this type of thing. Send them an email and see what they think.
@@rem9486 Heck yeah!! I was thinking a video about sharing all my learnings along this journey on TH-cam, so others could learn and apply my faults. But a data party sounds quite awesome as well!! Maybe both!
Hi Luke! Hope you find this comment. Thank you so much for putting out these videos. They really help me a lot on my journey to becoming a data analyst! I've been trying to comment here but my comment is too long. It keeps disappearing after i comment... Hope you don't mind if i send you an email. In need of advice. :(
My email ended up like an essay because i had so many questions and did want to keep asking here and there to annoy you haha.So please ignore the email. Haha I just wanna ask what skills and tools i need to learn to create dashboards on my blog (word press). Like what programming language and data visualization tools i need to learn to make dashboards on my blog. I want this to be my first project as i learn more skills to become a data scientist After completing my current online course, i will take the Google course and more data science related courses on Coursera!! Thank you! You advice will be much appreciated!
@@LukeBarousse just realized i sent to a wrong email. Will send it soon. Thank you so much for your help Luke. I’m so excited for this. Been studying online for 3 hrs a day. I just cant wait until i’ve enough skills to create some project!!
Great Luke, we'll be following the series. Hey guys, I am glad to announce that I have started a new role, my first full-time DA job, as a Business Analyst for a global Supply Chain and Logistics company. For context, I've been working for almost 10 years in project management roles and made a move beginning this year to switch to data analytics. I'm from Ghana - West Africa and hold a BSc. degree. Thanks, Luke and all of you who were an inspiration.
Congrats on the new role & awesome news! Thanks for sharing your news & some inspiration!
Congratulations brother!
Congrats brother
Great video, Luke! As I'm still dipping my toe in learning SQL, Python & Tableau, I'm leaning heavy on my industry knowledge to find data sets. Thanks for makin' me feel as if I'm on the right track!
Heck yeah these are great tools! Prioritize SQL for sure
@@LukeBarousse which sql variation would you suggest ?
How’s it going?
Landed a job yet ?
Watching with anxiety before starting data project right now 🐈⬛
🤣😂 I find procrastination is the best way to reduce anxiety! 💙💙 Hey Tina! 👋🏼
same here! 😂
Luke's video pops, *grabs popcorn* Awesome stuff. Super helpful!
I knew you would appreciate the editing Wale! 💙
I'm hooked to these videos. Very informative.
So glad to hear this!
thank you Luke for this video it fit exactly my Google certificate learning path !
So glad this could compliment it!!
Great video! Can't wait to for the next part!
Same, I'm stoked as well to make it!
Great video to start the day! ❤
10k more for 100k , GG Luke
Thanks Sai!! Not sure if you noticed this but when I was answering comments In this video. One of the comments I was answering was from you back when I had 700 subs. Hahahaha we’ve come quite a ways
@@LukeBarousse yeah i saw the notification, i rememeber subscribing to your channel back when it was 500 subs and my personal fav video where you discuss "M1 macbook - python packages capabilities".
Crazy journey, and long way to go. 100k now and then 1 million
I have been inspired by your TH-cam videos. Every month we get a 2500 row excel with different transplant patients data.
I have some ideas on what questions I want this to answer and hope to use it to develop analysis skills. Do you have any videos that specifically talk about cleaning data?
I don't have a dedicated video to just this topic of cleaning data, but the next video in this series does touch on cleaning data.
Hello luke, You've been doing a great job sharing information and values towards as a data analyst. One question as a beginner which tool should i start with as a data analyst student.
And thanks for all the info
I'd recommend starting with SQL!
Great subject will be watching, be safe.
Thanks Rick!!
First! Only because I have a plane to catch....
🤣 Have a safe flight Al!!
Fantastic Luke ! This is exactly what I needed now . Also Ive got one more question Luke . Being a student how do i learn more about a domain since i dont have hands on experience with the field . i dont know how each attribute contribute to the data set as a whole. Can you post a video about how to learn more abt domain before working on a dataset ?
Yeah this.
Let me see what I can do about this Sharan. I think this is a great idea!
Would you suggest any platform to look out for Data for new bie or have guided projects
Amazing as usual 💙
Awe thank you Asem!!!
Hey luke im working on a similar project as yours trying to build a chatbot to whom i can ask about the latest job posting in the field of ML/Data analysis and he would reply me with "these are the latest job posting in the field of Ml/Data analysis" for this im using dialogue flow to train my bot with the intent and entity then trying to connect the webhook to the backend of my flask framework the problem is i thought i could just use an api of LinkedIn or glass door or any such platform but now i get to know that's not possible and im stuck now after researching i found i should use a crawler that would get me all the data from these playform but i don't know how to proceed further it feel like im stuck with my project kindly help!
Hi luke what do you think i have to focus if i want to become an it security and compliance analyst. Please help me because i don’t know where to start.
I'm not to sure on security and compliance analyst, as I haven't ever worked in this field. I hope some one here in the comments can help answer this
Dont u have any other shirt?
Love your video's Luke.. Your video's have a charm that makes me watch them with a smile :)
Glad I can bring some positivity with my videos!!
Start with the problem: how to get Luke to keep the bathroom door shut? 😂 gonna need the data set
😂🤣 no data set needed on that one!!
*Luke mentions german three*
I facepalm and cringe each time I see Michael Fassbender blowing his cover in "Inglorious Basterds"
🤣😂 I lived in Germany last year and always did the American 3. 🤦🏼♂️ but now that I’m back in the US I DO GERMAN 3 🤦🏼♂️🤦🏼♂️. Love that movie BTW
It's always hard to start data analytics projects! I loved this. Can't wait for the rest of the series
Thanks Ben!!! Dude so hard to get started... but once started it's like ya can't stop!
'What problem are you trying to solve' , is it same as 'Frame the business question you want to answer ', example, What factors are associated with low sales?
Hey Pooja! Yes it is very similar. Questions I feel help answer the core problem!
I've been a DA for 18 years in finance/banking. I've lost my passion recently.
It can be a taxing job. Hope the passion comes back!
LOL - I love the little placeholder for the next video at the end. Hope to see its rightful owner moving in soon. Great video as always Luke!
🤣😂 I hope the placeholder isn’t there long. Thanks for watching to the end!!
What are good data sets to use for a project. Like i want to organize my music (which is over 800 different mp3 files) is lack of organization a problem or do i need to answer a specific question?
What a great channel for us rare few that enjoy data. I’m working to leave my current job and go get my masters in data science. Wish me luck Luke :)
Wishing you luck Kristian, you got this!!
@@LukeBarousse thanks for being an inspiration!
@@ThisAintIt435 🤗
Great video Luke, but i would like to also say that you have great communication and presentation skills..I think you can absolutely make some videos about that giving us data nerds some tips and tricks
This is so motivating to hear Thelma! I appreciate this, you made my day!
"Finding the problems and keep it in mind during the whole project is the key components all the Data Analyst should maintained " this is the key things I learned from coursera and now got the detailed overview of this from this vedio
Thanks luke💖💖 for this kind of great vedio.
Heck yeah, thanks so much for thsi Saidur!!
Love this channel. I'm really excited to get back to Data Analytics. I've been taking care of my dad (dementia) he is no longer with us. So now back to focusing on the Analytics. I've got a background in management, real estate, and government contracting.
Awe thanks for following along LaTonya. So sorry to hear about your father. My Dad actually passed away recently (so I feel your pain 😢). I like that you are using analytics to get back into it, I'm motivated by this!
@@LukeBarousse lol...I could look at my life as a tragedy as I am the only 1st generation person left living in my immediate family (Dad-Died in 10/2020, Mom-Died Cancer, Brother-Heartattack@48). But striving for this Google certification gives me a new focus and all I see is the opportunity, guess I am a glass-half-full kinda personality.😃
@@LaTonyaHiggins Well i'm motivated by your passion and desire to succeed. I hope this cert gives you some new-found motivation as I think you'll excel in data analytics with your positive attitude!
@@LaTonyaHiggins youre awesome, keep going!!
Hi Luke, can you give me some advice, I am curiently working on a project in which I have to extract the data from a local SQL database, which comes from biometric attendance device, and integrate it into a program called Zoho People which is also time and attendance program, i have been folowing advice from Zoho team of building a plugin caled Tomcat Apache which uses java but someting isnt right it does not get the data. Do you thing there is another better way, maybe using Python or other tools ?
I"m not as familiar with Zoho, so I'm not sure on this one on how to integrate with Zoho more easily. So sorry.
love from india💖
Aww Love from America!
Thanks for this amazing video. I'm a beginner to data analyst very very usefull and starting point explained very clear.🤩🤩🤩
Heck yeah, hope this will point you in the right problem for your next project!
This helps me to keep motivated. Thank you Luke from Philippines.
Thanks Luke for yet another video with a great content!
Thanks for watching as always CK
How do you look up credible data to import?
That's a great question. It really depends. If you don't know the data source then you may have to perform an indepth EDA to see if it credible. But I don't think there is a one-size fits all approach for this
i depend on you with the m1 pro/max review since are the only one i know who test programming apps
You know I'll be doing this! M1 Max is in the mail.. unfortunately I have to wait a month!
Just dropped this video today on the new M1 chips:
th-cam.com/video/1sQDJSQBUe4/w-d-xo.html
Tableau/Power BI, Python, SQL, Excel
I like this stack!!
it's been 3 weeks since you uploaded this video. hope you are well.
Hey Bouseux, thank you so much for checking in! I've been missing making content. Unfortunately, I had a death in my family and had to take a break for a bit. Hope to have a new video in the next week or two!! I hope you are well too my friend!
@@LukeBarousse Sorry to hear that Luke. May He/She rest in Peace. Looking forward for your videos as always. Take care!
@@bouseuxlatache4140 Aww thanks so much for this Bouseux. I very much appreciate it! Just got back into making the next video so stay tuned and take care as well!
Hey Luke, cover the macbook m1 max, pleaseeeee
On it! Just Ordered this bad boy, should have it in in a month!
Just dropped this video today on the new M1 Max chips:
th-cam.com/video/1sQDJSQBUe4/w-d-xo.html
Hi there! my old laptop is dead and I need an urgent one. I thought about buying a Mac book air m1 with 16 gb RAM and 256 gb SSD for university use (taking advantage of the discount) and I am thinking about the possibility of doing a master in "big data and business analytics". It is not sure but I wanted to know if it would be ok for that and excel, sql, power BI, access. Or if I should buy a windows pc. I saw that in a previous video of yours you had compared it to a Dell but this one is more expensive. Thanks in advance. 🙏
If you're going to be using Power BI a lot , I'd go with a Windows machine
Due to overzeal, I embarked on a project only to find out that the problem has already been solved by someone else. I found this half-way and since then I was demotivated to complete the project.
Piece of advice: research thoroughly your problem first. Chances are a solution already exists. Maybe it only needs customization to your context.
Just because a project already exists to solve a problem doesn't mean you can't continue with it and potentially design a better solution. Better yet, you may find that the other project has faults!
I recently made a mistake and got a dataset before I hopped on a plane ride and started to clean the data once the plane took off. I thought it would be a quick and easy Tableau project but I had more questions and needed to look up how to somethings in Tableau. Lesson learned.....
Ha! Thanks for sharing this lesson Abe! I always feel i'm going to accomplish large tasks on plane trips and inevitably result to napping the entire trip.
HAHA, what a fun and informative video as usual.
Can't wait to utilise your advice.
Thank you!! Can't wait for you to apply it as well!
probably my most viewed channel. im very much interested in this and mainly the tools used. so can there be a detailed step-by-step guide on how the tasks are carried out?
I'll see what I can do in this series to try and capture that!
this.
🙌🏼
@2:39 💯 😂
🙌🏼
Thank you for the recommendations.
:)
You're so welcome!
Thanks for your real-world suggestions.
My pleasure, Lallie!
This video came in time for me. I have a project that I thought was just fine for getting data from a website that updates its stats on players and teams in the EPL (English Premier League). I scraped the site using python with the aid of Selenium, Beautiful Soup and Requests libraries, then I used pandas to load the data and clean it up, the n matplotlib to visualize that data. All of that was done in Jupyter Labs IDE, and for me it was fine. But now I'm thinking of exactly what you're trying to do, because I need to look at historical trends for even better analysis, which a database would be useful for, and I need even better and more seamless visualization which I'm thinking Tableau would be useful for. Long story short, my roadblocks are first getting a database to load it into every game week, and also to find a way to get the code to run that automatically (preferably on the cloud, I was thinking AWS Lsmbda but I'm still learning about that).
Any help on this is greatly appreciated.
I think you're off to a great start and this is all part of the learning journey. From what you've shared I think you are looking into the right solutions, so just keep up the hard work!
@@LukeBarousse Thanks for the reply!. I see that this video is quite old, do you have one where you show how you used the database?. Or should I just use excel as a database for now?
I am a bit more than halfway done with my project. This is what I did/am doing:
1. Imagined I was a consultant who received a problem from a client: They want to know where they should place new shops
2. I created a few questions of my own: a. if I combine all of the zip codes in a greater area, are there fewer existing shops in certain zip codes? b. is there a correlation between income or population and the number of shops in the zip code (ie. does the average income mean there will be more shops).
3. Collected my data from two sources: State license to find out where the shops are located and census income/zip data.
4. Cleaned the data.
5. Today I will do my calculations and predictions from above then decide if I can come up with more questions.
6. Make my predictions presentable for the general public. Then I will package it for opinions online (Kaggle? )
This is awesome! Loved how you stepped through your thought process for creating a project and how you are tackling. THIS is exactly the thought process that employers want to see when hiring. Keep up the awesome work, looking forward to the results!
@@LukeBarousse I will post them when I am complete. Thank you so much.
Finally got the video. thank you so much now I know where to start
No problem ritwik!
Thank you Luke. Will be following this series. Currently learning python for analytics after following your channel for some months.
Heck yeah, so glad you're following along!
Thanks for sharing Luke! I’m definitely in the 2/3rds that has problems getting started.
Well hope this helped! More content on this to come
Waiting for the next one. And thank you for the heads up.
Heck yeah! Stay tuned!
Awesome video Luke! Looking forward to seeing the next videos of the series!
Thanks so much for this Carl! Looking forward as well putting together this series!
Great video! Looking forward to the series... then the book! Hey, like the TH-cam founders Gutenberg solved the 'I would like to self-publish some books' problem 600 years ago! Your fingers are already on the keyboard anyway ;-) Cheers!
Thanks Robert! Love the confidence you have in me, ha, maybe one day can be confident enough to produce a book!!
@@LukeBarousse Seriously, I think you could look at doing a book in the 'Teach Yourself Visually ...' book series, perfect format for this type of thing. Send them an email and see what they think.
@@dataArtists Heck yeah, let me look into this! I appreciate you thinking of me for this, Robert!
Sweet as*! You're less than 10k subs away from that 6 digit subs! Congrats in advance Luke!
We are so close, Rem!!!!!
I can feel that excitement from way down here (land down unda)!!! Any content idea once you reach that milestone? A data party would be rad! 🍻🍻🍻
@@rem9486 Heck yeah!! I was thinking a video about sharing all my learnings along this journey on TH-cam, so others could learn and apply my faults. But a data party sounds quite awesome as well!! Maybe both!
Hi Luke!
Hope you find this comment.
Thank you so much for putting out these videos.
They really help me a lot on my journey to becoming a data analyst!
I've been trying to comment here but my comment is too long. It keeps disappearing after i comment...
Hope you don't mind if i send you an email. In need of advice. :(
My email ended up like an essay because i had so many questions and did want to keep asking here and there to annoy you haha.So please ignore the email. Haha
I just wanna ask what skills and tools i need to learn to create dashboards on my blog (word press).
Like what programming language and data visualization tools i need to learn to make dashboards on my blog.
I want this to be my first project as i learn more skills to become a data scientist
After completing my current online course, i will take the Google course and more data science related courses on Coursera!!
Thank you! You advice will be much appreciated!
I’ll see what I can do with the email my friend!!!
@@LukeBarousse just realized i sent to a wrong email. Will send it soon.
Thank you so much for your help Luke.
I’m so excited for this. Been studying online for 3 hrs a day.
I just cant wait until i’ve enough skills to create some project!!
I like where you're going with this!
Thanks Bufford!
What a conderful breeze for a would be data analyst. Well done Luke, as always
AW thanks for this!! 🙌🏼
@@LukeBarousse Welcome! All the best bro
So helpful Luke! Thanks!
😘Thank you Alex. Miss ya'll!
Always inspiring
Awww thank you 💙💙💙
Great video. I will watch this project progress for sure.
Heck yeah, stay tuned!!