Could you please do a project from scratch to production where you apply the best data analyst practices for beginners, intermediates or even advance learners. Thank you.
Project 1: Data cleaning & transformation Project 2: Data Analysis Project 3: Data Visualization Project 4: Data Engineering/Data Science *DataSets From* - Kaggle and Awesome public datasets (in github) or Own Custom Data *Top Tips* - Make the projects Visually appealping, aestheticaly pleasing visuals [ex. Code with clear comments, with readme files], Make eye catching works
I was watching this vid on my laptop without signing in... It was soo helpful i decided to search it on my mobile fone and hit Like❤ I was so confused on how to create projects after doing data analytics bootcamp this is a superb video. Very helpful👍🏻
Awesome video man! I'm finishing my career in Software Engineer here in Chile, and i really want to get into data. I´m definitely going to use these ideas to start creating my portfolio. Keep with the good work!
Love your content man! I am actually a data analyst in an insurance, thinking about educating towards data enginnering - i would love to see a video of you building an etl pipeline as suggested in project 4. It is very easy to follow explanations - Best regards Mike
Hey Mike 👋 So great to see other experienced data analysts here on the channel 😃 An ETL pipeline video would be a great one, I’ll add it to my potential videos list. Thanks so much for watching!
I would like to express my gratitude for the guidance you have provided so far. I was wondering if you could kindly offer a comprehensive tutorial on creating end-to-end Power BI dashboard projects specifically tailored for beginners. Such a tutorial would greatly enhance our understanding of how to develop visually captivating dashboards.
Love your video, your way of explaining stuff, is exactly what I need ( I am at the beginner phase, who wants to makes his career in data analysis field ). I hope your channel helps me in my journey, and best wishes for your journey too!!
i was finding such type of data anlyst video finally i got this i will start working with this instructions thank you somuch after so many video i saw i could not get started
Wow, excellent tips! I'm going to start building my portfolio; I am in the process of changing careers, or combining my expertise in customer experience management with data. Thank you for sharing this knowledge; Hugs Edu straight from São Paulo | Brazil
Thank you so much for making this video. I've been thinking about creating projects, analyzing my YT view history and bank statements, but not sure what to focus on. After watching your video, I'm excited to get started. Thanking for sharing ideas!
Thank you so much I learn a lot from your video and give me an idea about Data Analyst portfolios. Coming from a developer background I am clueless when it comes to portfolios built around data.
*Data analysis project & data collection* *Project* 1. Data cleaning & transformation 2. Data analysis 3. Data visualization 4. Data engineering/ Data science 5. Communication
I'm a big fan of the NBA and I'm considering building my portfolio by web scraping data from the NBA's website. However, I want to make sure that there are no legal issues with doing so. Thank you for sharing great content as always.
Hi Igor, there shouldn’t be any legal issues, I doubt NBA will come after you for scraping data off their website 😅 It’s more about how companies don’t like it when you scrape personal data. Just google something along the lines of ‘is web scraping legal?’ and you can easily read about it yourself. Thanks a lot for watching 😃
As I've understood after doing a little bit of research about this topic, as long as you are scrapping public available data, you shouldn't face any legal consequences. I believe web scrapping public data is not regulated under CCPA in the US, neither under GDPR in Europe.
I did a NBA project for 1 of my projects in a data science boot camp. The NBA allows you to download their data. I think to get clean copies you have to pay, but the data sets aren’t so big you couldn’t just copy and paste it
@@ameenabdulbarr8342 have a look at some python web scraping libraries. It's pretty straughtforward. Has been a while since i did something with that but i used selenium. Also heard a lot good about scrapy.
Hello Mo. Thank you for this. I downloaded the fifa 21 dataset, and after looking at it, i know I am going to be challenged. Looking forward to using Excel to clean it up. Thank you for freely doing this.
Thanks for the content Mo! I am currently doing a slight career change right now and your channel has been super helpful in being able understand where I need to be. Thank you so much!
This is very informative and a path to learn skills and applying them. I would like to know the job of a data analyst in the form of a project utilizing skills like SQL, Python, Tableau..etc. please provide A roadmap utilizing the skills as a data analyst on a project.
Hi there 👋 Unfortunately I don't have the time right now for any mentorships. Please check out my website for useful learning information here datawithmo.com/. Hope this helps 😁
Great Video. I been in retail management, restaurant management and account management. Worked in Retail, restaurants and the financial sector. Would it benefit me to purse Business Analyst vs Data Analyst? I like to incorporate my previous skill sets to a Analyst position.
Hi Exceptional 👋 You could use SQL for project 1 & 2 😁 I recommended Python (or Excel) because you could quickly create visuals using these tools - in case you wanted to as part of your projects.
Please keep up these interesting insights into the day to day life of data analyst, I am currently studying to be a data analyst and will also be working remotely, so these videos help a lot.
Can you provide a bit of detail on how you apply your skillset in Data Analytics within the financial field? I just graduated with my Bachelor in Accounting but I also possess a certificate from a different school in Computer Science. I'm hoping to combine both and dive into the Data Analyst field.
This could be a very long answer so I’ll try my best to keep it as short as possible. Say for example, I know exactly what CDSs, bullet loans or balloon payments are, so when it comes to data around these metrics, no one has to explain to me what they mean. Or if the data is completely out of line, I can just tell by looking at the numbers. That’s one super simple example. Hope this helps!
Hi, I like your video series. This is my first ever comment on TH-cam. Can you make an end to end Data Engineering/ ETL pipeline project, that you have listed in your github?
In project #2 (data analysis, stack overflow annual developer survey) how to do first task : "At what companies do developers get the paid the most?", when we do not have developers companies column
Great video! I noticed you and many other data youtubers recommend creating a distinct project for each skill. What’s your opinion about creating one comprehensive and large project instead of several small projects? (For example, instead of creating one data cleaning and transformation project and one visualization project - creating one project and using the data I cleaned in order to make the visualization). Do you think one approach is better than the other?
Probably easier to tackle smaller projects rather than one big large one. That said, there's absolutely nothing wrong with creating one big project that contains everything.
I really appreciate your detailed explanation. I'm currently doing the IBM professional data analysis course and will do this after my cap stone project.
It's a lot more comprehensive and detailed than Google's own, plus it's a combination of Google's normal and advanced Data analysis course and only lacks R @@rudolphalmeida256
I'm a Pharmacist by profession and I just completed my Data analysis training, what areas would you advise me to focus on while trying to build my portfolio and also what would be your advice on how I can maximise my dual role as a data analyst and Pharmacist in order to land a good job?
I didn't really understand your first question in terms of what areas you should focus on with your portfolio. To answer your 2nd question, there are lots of data analyst roles available for Pharmacutical companies, have a look on LinkedIn 😃
Hey Aman 👋 It’s not a must do a DE or DS project. Just a good idea if you want to stand out or if the job role requires it. All the best with your journey mate 😄
Very Insightful video, I lost all hope as my resume was not even shortlisted for one company but now with your video I have new hope. However I have one question, all the projects that you mentioned to go ahead with Python , which cloud platform or website to go with as I like doing everything on the cloud. Thanks again.
Great videos. You define 1 "project" as one part of the entire data analyst process? e.g. 7:13 Data Cleaning the FIFA dataset is considered 1 project, and if I were to carry that data to 8:30 (Data Analysis) and conduct analysis, that would be considered a second project? Wouldn't a singular project be defined as carrying data from step 1 (Cleaning) up-to Step 5 (Sharing)? Asking for clarification before I start applying for jobs; I have 3 "projects" in github rn, and I want 5-10 projects as you mentioned in another video, as I don't have related work experience. Thanks
Hi Nikjojo 👋You can pick and choose and combine whatever project ideas in this video. I just provided 10 ideas that you can use as 10 projects or 1 project, completely up to you 😄Thanks a lot for watching!
My question is what is ultimately the end product of each of these projects? I understand project three can be put into a tableau dashboard, and the fourth one is a wildcard, but I'm not sure what can be produced from projects 1 and 2. Do I present them as walls of code?
Can you talk about data analysis topic in finance than being general? I mean if that is possible...what finance data analysis tasks do you do everyday on your job?
Hi Mohamed 👋 Please use the guiding questions to come up with your own personalised ways of solving the projects. I didn't provide tasks as there are so many ways you could tackle each project. Thanks a lot for watching!
Great video. I've wanted to start career in Data analytics and I've been wondering where to get dataset with specific guided questions like these and I wish I could get a mentor whom I can show my works to and consult in case of anything.
Thank you for this ,i am getting started on data analytics by self study.what do you recommend to a starter with no experience as i hold a bachelor's degree in commerce finance option and excel knowledge?Thank you once again
Hi Deborah 👋 I made a video on how to become a data analyst here th-cam.com/video/d_2fGS6QVDo/w-d-xo.html&ab_channel=DataWithMo. I also put together a roadmap here datawithmo.com/. Hope this helps 😃
Hi thank you so much for the video. I have a question. I retreived my youtube history search and watch lists. But the format is not excel or csv. It is html and I should open it up in the brower. So how can I use this data since it is not tabular? did I do something wrong for requesting the data ?
Thank you for the content. I'm aiming to undertake a project focused on extracting valuable insights from Spain's remote job market. I realize that this is still a rather broad problem and should be narrowed down. As a novice, I would appreciate your advice: Where do you think it would be viable to focus? Could you provide me with some guidance on how to approach the search for available data sources for this case? Thank you!
If you want really specific data with regards to Spain's job market, I'm afraid you'd have to scrape that yourself. You could focus on top paying companies, fields, industries, etc. Thanks a lot for watching!
I must be dumb, because I downloaded the YT stuff and there's no data about days/times that I watch YT videos. Am I just blind or can someone help me out?
Thank you for your video ❤😊. I have a question, in Data Cleaning & Transformation, in option 2, what do you mean by extract information? Should I use regex, or may be there is example of the 'Job Desc' column that already cleaned? Thank you in advance. Hope you answer me 😊🙏
Weldone. Is there a community to discuss about the progress? Also, I tried the FIFA fataset and had issues in the joined column. I tried to use the =TeXT function to change the date to month, years, and day but not working. Please help
I have a question. I am thinking to mock a survey via google form and then download in excel so can I do the analysis, etc. My question is how I can get responders to answer the survey. So with no responders, is that possible I be myself the responders. I would send the questionnaire to myself, respond and send back to me just to get the forms responded. When you doing your data analyst role, does it involve researching. I ask this because interviews and job applications ask about the research thing.
You could just use SQL for projects 1 and 2 as long as you load the dataset into a database. I'd say use whatever tool that's available and you feel comfortable with. I'm a big believer in fit for purpose coding 😁
See NordPass Business in action now with a 3-month free trial here nordpass.com/datawithmonord with code datawithmonord
Could you please do a project from scratch to production where you apply the best data analyst practices for beginners, intermediates or even advance learners. Thank you.
Project 1: Data cleaning & transformation
Project 2: Data Analysis
Project 3: Data Visualization
Project 4: Data Engineering/Data Science
*DataSets From* - Kaggle and Awesome public datasets (in github) or Own Custom Data
*Top Tips* - Make the projects Visually appealping, aestheticaly pleasing visuals [ex. Code with clear comments, with readme files], Make eye catching works
From the bottom of my heart.. Thank you @MO..you have just save a soul from stress.
I’m so glad you liked the video Obatuyi! Thanks for watching 😃
Big thank you Mo. I am trying to build portfolio and searching how to do it and your video is a gem...
I was watching this vid on my laptop without signing in... It was soo helpful i decided to search it on my mobile fone and hit Like❤
I was so confused on how to create projects after doing data analytics bootcamp this is a superb video. Very helpful👍🏻
Hi Afreen 👋 I'm glad you liked the video! Thanks a lot for watching 😁
Awesome video man! I'm finishing my career in Software Engineer here in Chile, and i really want to get into data. I´m definitely going to use these ideas to start creating my portfolio. Keep with the good work!
Thanks so much for watching Pablo 😁I'm glad you liked the video!
como te fue con los proyectos? estoy recién empezando
what an incredible job you did on this video. very insightful. thanks, Mo!
Thanks a lot for watching Artur
‼️Mo!! Please do a Video about how AI is going to impact Data Analyst‼️
Many people talking about it!
Thanks for your great content
Hi Glen 👋 What a great idea! I took a note of it and will hopefully make a video on this topic soon. Thanks so much for watching 😃
Love your content man! I am actually a data analyst in an insurance, thinking about educating towards data enginnering - i would love to see a video of you building an etl pipeline as suggested in project 4. It is very easy to follow explanations - Best regards Mike
Hey Mike 👋 So great to see other experienced data analysts here on the channel 😃 An ETL pipeline video would be a great one, I’ll add it to my potential videos list. Thanks so much for watching!
@@mo-chen high do you have a project on this now ETL
@@mo-chen please make the etl pipeline video soon, i am waiting too! thanks 😃
I would like to express my gratitude for the guidance you have provided so far. I was wondering if you could kindly offer a comprehensive tutorial on creating end-to-end Power BI dashboard projects specifically tailored for beginners. Such a tutorial would greatly enhance our understanding of how to develop visually captivating dashboards.
I don’t want to make any promises but I will try my best to make something along these lines sooner or later! Thank you so much for watching 😄
This is such a breeze to watch. Clear, succinct, insightful, relaxed.
Luv your vids. U just got a new sub. Keep it comin! Kudos to u! 🙂
Thanks so much Antolin 😃
Love your video, your way of explaining stuff, is exactly what I need ( I am at the beginner phase, who wants to makes his career in data analysis field ). I hope your channel helps me in my journey, and best wishes for your journey too!!
Hi Samarth 👋 thanks for watching and I wish you all the best too 😃
how is it going man?
omg!!! I just finished my master courses, and want to search for a data analyst job, your video is soooo valuable for me!!!
That’s wonderful to hear! Wish you all the best Tracy 😃
i was finding such type of data anlyst video finally i got this i will start working with this instructions thank you somuch after so many video i saw i could not get started
I'm so glad to hear you liked the video! Thank you so much for watching 😄
Wow, excellent tips! I'm going to start building my portfolio;
I am in the process of changing careers, or combining my expertise in customer experience management with data.
Thank you for sharing this knowledge;
Hugs
Edu straight from São Paulo | Brazil
Thank you so much for making this video. I've been thinking about creating projects, analyzing my YT view history and bank statements, but not sure what to focus on. After watching your video, I'm excited to get started. Thanking for sharing ideas!
I'm glad to hear this, thanks a lot for watching 😁
Thank you so much I learn a lot from your video and give me an idea about Data Analyst portfolios. Coming from a developer background I am clueless when it comes to portfolios built around data.
That's great to hear! Thanks so much for watching John 😁
This is really insightful and super helpful for someone who is stuck on where to start to build a portfolio. Thank you so much Mo😀
Hi Mufaromumba 👋 I’m glad you liked it, thanks for watching!
Another great video Mo! - Keep up the good work 😁
Thanks so much for watching Mahi 😃
Grabe ang galing❤❤❤
Thanks Richards YTC!
Yeah this is iitt 🔥 thankss Mo! Duly appreciated Mo!
I’m glad you liked it! Thanks so much for watching 😃
*Data analysis project & data collection*
*Project*
1. Data cleaning & transformation
2. Data analysis
3. Data visualization
4. Data engineering/ Data science
5. Communication
nice comment
Insightful and very informative, thank you sir!
Thank you for watching Jhopay 😃
Another dope video 🤛🏾. Thanks Mo
Thanks a lot 😃
This video needs one million views
Haha I wish 😃 Thanks so much for watching!
Very insightful, thanks you! Where can you post your Power BI works?
I'm a big fan of the NBA and I'm considering building my portfolio by web scraping data from the NBA's website. However, I want to make sure that there are no legal issues with doing so. Thank you for sharing great content as always.
Hi Igor, there shouldn’t be any legal issues, I doubt NBA will come after you for scraping data off their website 😅 It’s more about how companies don’t like it when you scrape personal data. Just google something along the lines of ‘is web scraping legal?’ and you can easily read about it yourself. Thanks a lot for watching 😃
I want to learn data scraping, please do you have any tutorial or references for me to learn from
As I've understood after doing a little bit of research about this topic, as long as you are scrapping public available data, you shouldn't face any legal consequences. I believe web scrapping public data is not regulated under CCPA in the US, neither under GDPR in Europe.
I did a NBA project for 1 of my projects in a data science boot camp. The NBA allows you to download their data. I think to get clean copies you have to pay, but the data sets aren’t so big you couldn’t just copy and paste it
@@ameenabdulbarr8342 have a look at some python web scraping libraries. It's pretty straughtforward. Has been a while since i did something with that but i used selenium. Also heard a lot good about scrapy.
You are so good. Very intelligent. More grease to your elbow. You are really sharing your industry knowledge with us. God bless you
That's very kind of you to say, thank you!
Great video Mo👍
Glad you enjoyed it
Hello Mo.
Thank you for this.
I downloaded the fifa 21 dataset, and after looking at it, i know I am going to be challenged. Looking forward to using Excel to clean it up.
Thank you for freely doing this.
Thanks for the content Mo! I am currently doing a slight career change right now and your channel has been super helpful in being able understand where I need to be. Thank you so much!
I'm glad you found the content useful 😄
Sooo useful, thanks!
Thank you so much! You gave great ideas!
Thanks a lot for watching Akshay!
Great video, man! I'm glad I ran into your channel. You just gained a sub!
Thanks for watching and for the sub 😁
Clearly explained dude. Earn you like! I'll follow you.
Thanks a lot 😃
THANK YOU! Very helpful to get me started!
Great video showing steps to success in Data Analyst
Thanks so much for watching Elijah 😃
Just pick any dataset...if you get a job, you will not be working only on topics you are passionate about. It is a job.
But working on something you are passionate about demonstrates your ability to lock tf in
Discovered your channel today! I'm really glad I did!
It's great to have you here on the channel! Thanks so much for watching 😄
Thank You Mo, this is a Great Video and Just What I needed at this time☺ in my LIFE.
So glad you liked it 😁
This is very informative and a path to learn skills and applying them. I would like to know the job of a data analyst in the form of a project utilizing skills like SQL, Python, Tableau..etc. please provide A roadmap utilizing the skills as a data analyst on a project.
great video Mo starting my first sql project today
Hi Tawanda 👋 Thanks so much for watching and good luck with your SQL project!
A very helpfull video, thank you so much !!!!!!!
Thanks a lot for watching Spanishead 😃
How do you get people to look at your portfolio? When all they want to see is you resume?
By placing the link to your portfolio at the about me section on your CV
I really like your videos ! Great work 👏🏻👏🏻
Thanks so much for watching Leonardo 😃
i am so glad i found this channel. Do you do mentorship?, i am new to data analytics, and i will really love to have a mentor like you
Hi there 👋 Unfortunately I don't have the time right now for any mentorships. Please check out my website for useful learning information here datawithmo.com/. Hope this helps 😁
Great Video. I been in retail management, restaurant management and account management. Worked in Retail, restaurants and the financial sector. Would it benefit me to purse Business Analyst vs Data Analyst? I like to incorporate my previous skill sets to a Analyst position.
Great video , I'm just wondering when do we use SQL in all of this ?
Hi Exceptional 👋 You could use SQL for project 1 & 2 😁 I recommended Python (or Excel) because you could quickly create visuals using these tools - in case you wanted to as part of your projects.
Please keep up these interesting insights into the day to day life of data analyst, I am currently studying to be a data analyst and will also be working remotely, so these videos help a lot.
Will do for sure!
Thanks Mo, great video
Thanks a lot for watching Fatih 😃
This is nice. Keep up 👏
Excellent advice, thanks!
Glad you liked it, thanks a lot for watching 😃
Thank you so much Mo. Great video
Thanks a lot Yura 😄
Can you provide a bit of detail on how you apply your skillset in Data Analytics within the financial field? I just graduated with my Bachelor in Accounting but I also possess a certificate from a different school in Computer Science. I'm hoping to combine both and dive into the Data Analyst field.
This could be a very long answer so I’ll try my best to keep it as short as possible. Say for example, I know exactly what CDSs, bullet loans or balloon payments are, so when it comes to data around these metrics, no one has to explain to me what they mean. Or if the data is completely out of line, I can just tell by looking at the numbers. That’s one super simple example. Hope this helps!
Your videos are always super helpful. Thank you 🙏🏻
Thanks a lot for watching 😁
Great work!! Thanks
Thanks a lot for watching 😃
I really appreciate and like your videos, It is amazing
Thanks so much for your kind words, great to have you here on the channel 😁
Hi, I like your video series. This is my first ever comment on TH-cam. Can you make an end to end Data Engineering/ ETL pipeline project, that you have listed in your github?
Very helpful! Thanks!
Thanks so much for watching 😃
All of your videos are excellent and the Tableau portfolio example you did is the best walkthrough of a Tableau project I have seen. Thanks again!
thanks a lot for your insipiring video!!
Thanks a lot for watching 😁
In project #2 (data analysis, stack overflow annual developer survey) how to do first task : "At what companies do developers get the paid the most?", when we do not have developers companies column
Great video! I noticed you and many other data youtubers recommend creating a distinct project for each skill. What’s your opinion about creating one comprehensive and large project instead of several small projects? (For example, instead of creating one data cleaning and transformation project and one visualization project - creating one project and using the data I cleaned in order to make the visualization).
Do you think one approach is better than the other?
Probably easier to tackle smaller projects rather than one big large one. That said, there's absolutely nothing wrong with creating one big project that contains everything.
I really appreciate your detailed explanation. I'm currently doing the IBM professional data analysis course and will do this after my cap stone project.
How is is, I’m stuck between the Google Data Analytics cert and the one you had just mentioned. What made you choose IBM ?
It's a lot more comprehensive and detailed than Google's own, plus it's a combination of Google's normal and advanced Data analysis course and only lacks R @@rudolphalmeida256
Thanks for the Advice
Thanks for watching man!
I'm a Pharmacist by profession and I just completed my Data analysis training, what areas would you advise me to focus on while trying to build my portfolio and also what would be your advice on how I can maximise my dual role as a data analyst and Pharmacist in order to land a good job?
I didn't really understand your first question in terms of what areas you should focus on with your portfolio. To answer your 2nd question, there are lots of data analyst roles available for Pharmacutical companies, have a look on LinkedIn 😃
i built a project for one of my finals using premier leauge data sets to create a stats directory for the premier leauge season
Cool data to work with 😃 Thanks a lot for watching Maximilian!
you earned my sub dude
great video!. can you make another video about how to make your portfolio visually appealing? thank you
Not sure when I'll get to make to a video like that, but great idea 😁 Thanks a lot for watching!
I am new to data science and want to know how much time is realistically needed to accomplish each project type. Thanks for any tip
This was really helpful. Thank you 😊
Glad it was helpful! Thanks a lot for watching 😃
THIS IS PERFECT!
I'm glad you liked it, thanks a lot for watching 😁
Project 4 wil be very tough for me. I don't known about DE or data science. But i'm planning to learning DE. Good video though. Thankss 👍
Hey Aman 👋 It’s not a must do a DE or DS project. Just a good idea if you want to stand out or if the job role requires it. All the best with your journey mate 😄
Thanks, great videos. Do you have portfolio project ideas for a financial and business analyst.
Very Insightful video, I lost all hope as my resume was not even shortlisted for one company but now with your video I have new hope. However I have one question, all the projects that you mentioned to go ahead with Python , which cloud platform or website to go with as I like doing everything on the cloud. Thanks again.
I'm glad you liked the video 😁AWS is great in my opinion.
Merci (Thanks you) im french and you help me a lot🙂
Happy to help!
Great videos.
You define 1 "project" as one part of the entire data analyst process? e.g. 7:13 Data Cleaning the FIFA dataset is considered 1 project, and if I were to carry that data to 8:30 (Data Analysis) and conduct analysis, that would be considered a second project?
Wouldn't a singular project be defined as carrying data from step 1 (Cleaning) up-to Step 5 (Sharing)?
Asking for clarification before I start applying for jobs; I have 3 "projects" in github rn, and I want 5-10 projects as you mentioned in another video, as I don't have related work experience.
Thanks
Hi Nikjojo 👋You can pick and choose and combine whatever project ideas in this video. I just provided 10 ideas that you can use as 10 projects or 1 project, completely up to you 😄Thanks a lot for watching!
You deserve a million subscribers
I wish haha, thanks!
My question is what is ultimately the end product of each of these projects? I understand project three can be put into a tableau dashboard, and the fourth one is a wildcard, but I'm not sure what can be produced from projects 1 and 2. Do I present them as walls of code?
Can you talk about data analysis topic in finance than being general? I mean if that is possible...what finance data analysis tasks do you do everyday on your job?
I do a lot of work around Data Management which is making sure that we consume good quality ideally from central, golden source repositories.
Hi Mo. Thanks for the video. Please can you list the tasks expected for each project in the file you provided with the links to the datasets?
Hi Mohamed 👋 Please use the guiding questions to come up with your own personalised ways of solving the projects. I didn't provide tasks as there are so many ways you could tackle each project. Thanks a lot for watching!
Great video.
I've wanted to start career in Data analytics and I've been wondering where to get dataset with specific guided questions like these and I wish I could get a mentor whom I can show my works to and consult in case of anything.
Hi Samuel 👋 Great to have you here on the channel, hopefully you can connect with some like-minded people here! Thanks so much for watching 😃
Thank you for this ,i am getting started on data analytics by self study.what do you recommend to a starter with no experience as i hold a bachelor's degree in commerce finance option and excel knowledge?Thank you once again
Hi Deborah 👋 I made a video on how to become a data analyst here th-cam.com/video/d_2fGS6QVDo/w-d-xo.html&ab_channel=DataWithMo. I also put together a roadmap here datawithmo.com/. Hope this helps 😃
What software do you use for that presentation?
It’s just PowerPoint 😄
thanks, great tips.
Hi thank you so much for the video. I have a question. I retreived my youtube history search and watch lists. But the format is not excel or csv. It is html and I should open it up in the brower. So how can I use this data since it is not tabular? did I do something wrong for requesting the data ?
Thank you for the content.
I'm aiming to undertake a project focused on extracting valuable insights from Spain's remote job market. I realize that this is still a rather broad problem and should be narrowed down. As a novice, I would appreciate your advice: Where do you think it would be viable to focus? Could you provide me with some guidance on how to approach the search for available data sources for this case?
Thank you!
If you want really specific data with regards to Spain's job market, I'm afraid you'd have to scrape that yourself. You could focus on top paying companies, fields, industries, etc. Thanks a lot for watching!
Excellent Job there. My question. How does SQL fit in especially in 1,2 and 4
You could do project 1 and 2 in SQL as long as you load in the right datasets, but not 4. Thanks for watching 😁
Thank you for your video
Thanks for watching 😁
Hey buddy , i don't what you,trying to mention , but your thumbnail photo is very funny
Thank you
Thanks for watching 😁
I must be dumb, because I downloaded the YT stuff and there's no data about days/times that I watch YT videos. Am I just blind or can someone help me out?
Thank you for your video ❤😊. I have a question, in Data Cleaning & Transformation, in option 2, what do you mean by extract information? Should I use regex, or may be there is example of the 'Job Desc' column that already cleaned? Thank you in advance. Hope you answer me 😊🙏
Yes, I did mean regex or any other text wrangling method to extract useful information 😃 Thanks a lot for watching!
very interesting video, really appreciate it. Im just curious, why we dont use all dataset for all goal (data cleaning until communication)?
Hi Rizka 👋 You could of course do that as well! Just wanted to switch it up with different datasets to show you guys what you could do 😁
Weldone. Is there a community to discuss about the progress? Also, I tried the FIFA fataset and had issues in the joined column. I tried to use the =TeXT function to change the date to month, years, and day but not working. Please help
awesome. ty
Thanks for watching Azizul 😃
7:33 can anyone help me with this? I tried find&replace and substitute, but it didn't work. How can i remove the newlines?
I have a question. I am thinking to mock a survey via google form and then download in excel so can I do the analysis, etc. My question is how I can get responders to answer the survey. So with no responders, is that possible I be myself the responders. I would send the questionnaire to myself, respond and send back to me just to get the forms responded. When you doing your data analyst role, does it involve researching. I ask this because interviews and job applications ask about the research thing.
Good idea! Probably best just to ask your friends and family to fill out the survey for you 😁
Awesome video
Thanks a lot for watching, I'm glad you liked it 😁
Hello Mo. In the data analysis segment, you suggested using python. When is it advisable to use SQL for analysis?
You could just use SQL for projects 1 and 2 as long as you load the dataset into a database. I'd say use whatever tool that's available and you feel comfortable with. I'm a big believer in fit for purpose coding 😁