10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO
Вставка
- Опубліковано 19 лип 2024
- See NordPass Business in action now with a 3-month free trial here nordpass.com/datawithmonord with code datawithmonord
Get access to my exclusive content by joining my mailing list ➡ mochen.info/
Support me on Patreon ➡ / mo_chen
Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python ➡ • Portfolio Projects
┋Community & Socials┋
/ discord ⬅ Join our Discord Data Community
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
┋Professional Certificates┋
CourseCareers ➡ coursecareers.com/a/mochen
DataCamp Courses & Certifications ➡ datacamp.pxf.io/c/4216860/111...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Why create a portfolio?
01:13 Projects
03:24 Datasets
05:43 Project 1
08:26 Project 2
09:41 Project 3
10:51 Project 4
12:12 Project 5
12:33 Sharing your portfolio
13:21 Top tip
14:12 Outro
┋Datasets┋
docs.google.com/document/d/1f...
Thanks so much for taking a little time out of your day to watch this!
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.
Big thank you Mo. I am trying to build portfolio and searching how to do it and your video is a gem...
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 😃
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 😃
what an incredible job you did on this video. very insightful. thanks, Mo!
Thanks a lot for watching Artur
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.
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?
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 😁
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
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 😃
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
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!
Sooo useful, thanks!
Another dope video 🤛🏾. Thanks Mo
Thanks a lot 😃
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 😁
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 😄
Another great video Mo! - Keep up the good work 😁
Thanks so much for watching Mahi 😃
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 😄
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 😄
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 😁
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 😄
Yeah this is iitt 🔥 thankss Mo! Duly appreciated Mo!
I’m glad you liked it! Thanks so much for watching 😃
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!
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 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 😁
‼️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 😃
Your videos are always super helpful. Thank you 🙏🏻
Thanks a lot for watching 😁
I really like your videos ! Great work 👏🏻👏🏻
Thanks so much for watching Leonardo 😃
Thank You Mo, this is a Great Video and Just What I needed at this time☺ in my LIFE.
So glad you liked it 😁
thanks, great tips.
Insightful and very informative, thank you sir!
Thank you for watching Jhopay 😃
Thank you so much Mo. Great video
Thanks a lot Yura 😄
you earned my sub dude
Grabe ang galing❤❤❤
Thanks Richards YTC!
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!
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.
great video Mo starting my first sql project today
Hi Tawanda 👋 Thanks so much for watching and good luck with your SQL project!
This was really helpful. Thank you 😊
Glad it was helpful! Thanks a lot for watching 😃
Great work!! Thanks
Thanks a lot for watching 😃
Thanks Mo, great video
Thanks a lot for watching Fatih 😃
Great video showing steps to success in Data Analyst
Thanks so much for watching Elijah 😃
Thanks, great videos. Do you have portfolio project ideas for a financial and business analyst.
A very helpfull video, thank you so much !!!!!!!
Thanks a lot for watching Spanishead 😃
THIS IS PERFECT!
I'm glad you liked it, thanks a lot for watching 😁
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
Clearly explained dude. Earn you like! I'll follow you.
Thanks a lot 😃
thanks a lot for your insipiring video!!
Thanks a lot for watching 😁
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!
Excellent advice, thanks!
Glad you liked it, thanks a lot for watching 😃
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 😁
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 😁
Thanks for the Advice
Thanks for watching man!
Very insightful, thanks you! Where can you post your Power BI works?
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!
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.
awesome. ty
Thanks for watching Azizul 😃
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.
Thank you
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.
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.
Merci (Thanks you) im french and you help me a lot🙂
Happy to help!
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, I like your video series. This is my first ever comment on UA-cam. Can you make an end to end Data Engineering/ ETL pipeline project, that you have listed in your github?
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!
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 😄
You deserve a million subscribers
I wish haha, thanks!
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!
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 😃
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.
This video needs one million views
Haha I wish 😃 Thanks so much for watching!
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!
So cool!
Thank you
Thanks 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 your video
Thanks 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
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 ?
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!
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.
Really enjoyed this one ! Can u jjust tell me if its possible to do data visualization withy pyscript ? Keep up the good work !
I myself have never used pyscript before so I can't comment on that, but I have used streamlit which is similar and it's pretty good for building dashboards 😁
Awesome video
Thanks a lot for watching, I'm glad you liked it 😁
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!
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 😁
Hey buddy , i don't what you,trying to mention , but your thumbnail photo is very funny
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!
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
nice tips!
Glad you like them!
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 ua-cam.com/video/d_2fGS6QVDo/v-deo.html&ab_channel=DataWithMo. I also put together a roadmap here datawithmo.com/. Hope this helps 😃
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 😁
Could you please make end to end videos on these projects from? That helps a lot
I'll certainly try my best, thanks a lot for watching 😃
Good info
I'm glad you liked it, thanks a lot for watching 😃
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 😁
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
Hey, can you make a video about the resume. i still have a problem to get the job even i do projects. i mean, what will u write on ur cv based on the projects you do and the company requirement
Hey Muhammad 👋 Please check out this video ua-cam.com/video/Syn7TTk4tR8/v-deo.html. Hope this helps!
How do you generate questions is forom stakeholders or from your own expertise
Hi Thanks for this wonderful video. The best video you've made for python. Keep posting such content.
That's very kind of you to say! Thanks a lot for watching Balakrishna 😁
*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
Can you make a tutorial on each of the listed projects?
I can't promise anything but I will definitely make more project videos for sure 😁 Thanks a lot for watching!
Hey Mo, I want to do a SQL project about a Rapper’s career do you think it’s a good idea? Doing analysis on a single person where I will have to create the dataset from research ?
As long as you have enough good quality data, I don't see why not! Very unique idea 😁
@@mo-chen thank you I will surely share after I’m done thank you 🙏