10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO
See NordPass Business in action now with a 3-month free trial here nordpass.com/datawithmonord with code datawithmonord
Exclusive Data Analysis Content ➡ mochen.info/ ⬅ Join My Mailing List
/ mo_chen ⬅ Support me on Patreon
/ discord ⬅ Join our Discord Data Community
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
• Data Analysis Portfoli... ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python
┋Professional Certificates┋
DataCamp Certifications ➡ datacamp.pxf.io/c/4216860/205...
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!
Пікірлер: 294
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! 🙂
@mo-chen
Жыл бұрын
Thanks so much Antolin 😃
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
what an incredible job you did on this video. very insightful. thanks, Mo!
@mo-chen
Жыл бұрын
Thanks a lot for watching Artur
From the bottom of my heart.. Thank you @MO..you have just save a soul from stress.
@mo-chen
Жыл бұрын
I’m so glad you liked the video Obatuyi! Thanks for watching 😃
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.
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!
@mo-chen
Жыл бұрын
I'm glad to hear this, thanks a lot for watching 😁
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!!
@mo-chen
Жыл бұрын
Hi Samarth 👋 thanks for watching and I wish you all the best too 😃
@Applefanboy2012
10 ай бұрын
how is it going man?
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!
@mo-chen
Жыл бұрын
Thanks so much for watching Pablo 😁I'm glad you liked the video!
@Ginkgoxvi
4 ай бұрын
como te fue con los proyectos? estoy recién empezando
Sooo useful, thanks!
Another dope video 🤛🏾. Thanks Mo
@mo-chen
Жыл бұрын
Thanks a lot 😃
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😀
@mo-chen
Жыл бұрын
Hi Mufaromumba 👋 I’m glad you liked it, thanks for watching!
Another great video Mo! - Keep up the good work 😁
@mo-chen
Жыл бұрын
Thanks so much for watching Mahi 😃
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.
@mo-chen
Жыл бұрын
That's great to hear! Thanks so much for watching John 😁
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
@mo-chen
Жыл бұрын
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!
@nhlanhlahlengwa2631
Жыл бұрын
@@mo-chen high do you have a project on this now ETL
@Vlavily
6 ай бұрын
@@mo-chen please make the etl pipeline video soon, i am waiting too! thanks 😃
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!
@mo-chen
10 ай бұрын
I'm glad you found the content useful 😄
Thank you so much! You gave great ideas!
@mo-chen
Жыл бұрын
Thanks a lot for watching Akshay!
Great video, man! I'm glad I ran into your channel. You just gained a sub!
@mo-chen
Жыл бұрын
Thanks for watching and for the sub 😁
Discovered your channel today! I'm really glad I did!
@mo-chen
Жыл бұрын
It's great to have you here on the channel! 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
@mo-chen
Жыл бұрын
That's very kind of you to say, thank you!
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
thanks, great tips.
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.
@mo-chen
Жыл бұрын
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 😄
Yeah this is iitt 🔥 thankss Mo! Duly appreciated Mo!
@mo-chen
Жыл бұрын
I’m glad you liked it! Thanks so much for watching 😃
Thank You Mo, this is a Great Video and Just What I needed at this time☺ in my LIFE.
@mo-chen
11 ай бұрын
So glad you liked it 😁
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
@mo-chen
Жыл бұрын
I'm so glad to hear you liked the video! Thank you so much 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
@mo-chen
Жыл бұрын
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 😃
Insightful and very informative, thank you sir!
@mo-chen
Жыл бұрын
Thank you for watching Jhopay 😃
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.
I really like your videos ! Great work 👏🏻👏🏻
@mo-chen
Жыл бұрын
Thanks so much for watching Leonardo 😃
Thank you so much Mo. Great video
@mo-chen
Жыл бұрын
Thanks a lot Yura 😄
Your videos are always super helpful. Thank you 🙏🏻
@mo-chen
Жыл бұрын
Thanks a lot for watching 😁
Very insightful, thanks you! Where can you post your Power BI works?
you earned my sub dude
Thanks, great videos. Do you have portfolio project ideas for a financial and business analyst.
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 work!! Thanks
@mo-chen
Жыл бұрын
Thanks a lot for watching 😃
Grabe ang galing❤❤❤
@mo-chen
Жыл бұрын
Thanks Richards YTC!
thanks a lot for your insipiring video!!
@mo-chen
11 ай бұрын
Thanks a lot for watching 😁
This was really helpful. Thank you 😊
@mo-chen
10 ай бұрын
Glad it was helpful! Thanks a lot for watching 😃
A very helpfull video, thank you so much !!!!!!!
@mo-chen
Жыл бұрын
Thanks a lot for watching Spanishead 😃
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👍🏻
@mo-chen
Жыл бұрын
Hi Afreen 👋 I'm glad you liked the video! Thanks a lot for watching 😁
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.
@mo-chen
9 ай бұрын
Will do for sure!
Thanks Mo, great video
@mo-chen
Жыл бұрын
Thanks a lot for watching Fatih 😃
Hi, I like your video series. This is my first ever comment on KZread. Can you make an end to end Data Engineering/ ETL pipeline project, that you have listed in your github?
omg!!! I just finished my master courses, and want to search for a data analyst job, your video is soooo valuable for me!!!
@mo-chen
Жыл бұрын
That’s wonderful to hear! Wish you all the best Tracy 😃
Great video showing steps to success in Data Analyst
@mo-chen
Жыл бұрын
Thanks so much for watching Elijah 😃
great video Mo starting my first sql project today
@mo-chen
Жыл бұрын
Hi Tawanda 👋 Thanks so much for watching and good luck with your SQL project!
Clearly explained dude. Earn you like! I'll follow you.
@mo-chen
Жыл бұрын
Thanks a lot 😃
Excellent advice, thanks!
@mo-chen
11 ай бұрын
Glad you liked it, thanks a lot for watching 😃
THIS IS PERFECT!
@mo-chen
Жыл бұрын
I'm glad you liked it, thanks a lot for watching 😁
I really appreciate and like your videos, It is amazing
@mo-chen
Жыл бұрын
Thanks so much for your kind words, great to have you here on the channel 😁
Very helpful! Thanks!
@mo-chen
Жыл бұрын
Thanks so much for watching 😃
@econhelp583
Жыл бұрын
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 for the Advice
@mo-chen
Жыл бұрын
Thanks for watching man!
awesome. ty
@mo-chen
Жыл бұрын
Thanks for watching Azizul 😃
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.
@mo-chen
Жыл бұрын
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!
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.
@rudolphalmeida256
6 ай бұрын
How is is, I’m stuck between the Google Data Analytics cert and the one you had just mentioned. What made you choose IBM ?
@dillkhalifa
6 ай бұрын
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
Merci (Thanks you) im french and you help me a lot🙂
@mo-chen
9 ай бұрын
Happy to help!
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?
@mo-chen
9 ай бұрын
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 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
@mo-chen
Жыл бұрын
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 am new to data science and want to know how much time is realistically needed to accomplish each project type. Thanks for any tip
So cool!
great video!. can you make another video about how to make your portfolio visually appealing? thank you
@mo-chen
Жыл бұрын
Not sure when I'll get to make to a video like that, but great idea 😁 Thanks a lot for watching!
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.
@mo-chen
Жыл бұрын
I'm glad you liked the video 😁AWS is great in my opinion.
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?
@mo-chen
Жыл бұрын
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!
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 ?
Great video , I'm just wondering when do we use SQL in all of this ?
@mo-chen
Жыл бұрын
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.
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.
@mo-chen
Жыл бұрын
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 😃
@ameenabdulbarr8342
Жыл бұрын
I want to learn data scraping, please do you have any tutorial or references for me to learn from
@ss_roldan
Жыл бұрын
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.
@panblacksolutions
Жыл бұрын
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
@random-oe9jy
Жыл бұрын
@@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. 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.
@mo-chen
Жыл бұрын
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
@mo-chen
Жыл бұрын
Thanks for watching 😁
Thank you
@mo-chen
Жыл бұрын
Thanks 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?
@mo-chen
11 ай бұрын
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 😃
Awesome video
@mo-chen
Жыл бұрын
Thanks a lot for watching, I'm glad you liked it 😁
You deserve a million subscribers
@mo-chen
2 ай бұрын
I wish haha, thanks!
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
nice tips!
@mo-chen
9 ай бұрын
Glad you like them!
This video needs one million views
@mo-chen
Жыл бұрын
Haha I wish 😃 Thanks so much for watching!
How do you generate questions is forom stakeholders or from your own expertise
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
@mo-chen
Жыл бұрын
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!
Hey buddy , i don't what you,trying to mention , but your thumbnail photo is very funny
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!
@mo-chen
11 ай бұрын
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!
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 👍
@mo-chen
Жыл бұрын
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 😄
Good info
@mo-chen
Жыл бұрын
I'm glad you liked it, thanks a lot for watching 😃
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 😊🙏
@mo-chen
Жыл бұрын
Yes, I did mean regex or any other text wrangling method to extract useful information 😃 Thanks a lot for watching!
i built a project for one of my finals using premier leauge data sets to create a stats directory for the premier leauge season
@mo-chen
Жыл бұрын
Cool data to work with 😃 Thanks a lot for watching Maximilian!
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
@mo-chen
Жыл бұрын
Hi Deborah 👋 I made a video on how to become a data analyst here kzread.info/dash/bejne/lpNmyKmMZrS8dNI.html&ab_channel=DataWithMo. I also put together a roadmap here datawithmo.com/. Hope this helps 😃
How do you get people to look at your portfolio? When all they want to see is you resume?
@fabskoolstuff8673
5 ай бұрын
By placing the link to your portfolio at the about me section on your CV
Really enjoyed this one ! Can u jjust tell me if its possible to do data visualization withy pyscript ? Keep up the good work !
@mo-chen
Жыл бұрын
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 😁
Excellent Job there. My question. How does SQL fit in especially in 1,2 and 4
@mo-chen
Жыл бұрын
You could do project 1 and 2 in SQL as long as you load in the right datasets, but not 4. Thanks for watching 😁
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?
@mo-chen
Жыл бұрын
I do a lot of work around Data Management which is making sure that we consume good quality ideally from central, golden source repositories.
very interesting video, really appreciate it. Im just curious, why we dont use all dataset for all goal (data cleaning until communication)?
@mo-chen
Жыл бұрын
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 😁
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?
Hello Mo. In the data analysis segment, you suggested using python. When is it advisable to use SQL for analysis?
@mo-chen
Жыл бұрын
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 😁
is it necessary to learn both python and mysql?
Could you please make end to end videos on these projects from? That helps a lot
@mo-chen
Жыл бұрын
I'll certainly try my best, thanks a lot for watching 😃
Hi Thanks for this wonderful video. The best video you've made for python. Keep posting such content.
@mo-chen
Жыл бұрын
That's very kind of you to say! Thanks a lot for watching Balakrishna 😁
Do you recommend having a website if I'm just starting? Or is that for when I'm a senior-level or higher?
@mo-chen
Жыл бұрын
Having a website is always a nice plus! If you have the time and know how to do it, you could just do it now 😃
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.
@mo-chen
Жыл бұрын
Good idea! Probably best just to ask your friends and family to fill out the survey for you 😁