you probably click this video because you're looking for projects that can get you interview call and eventually a job if you're looking for projects that you can finish in 30 minutes or your focus is to build a fancy dashboard then please leave this video because the project that I'm going to talk about will require some work these are serious projects which have helped many people get a job we will discuss three guided and three unguided projects for each of these projects I will tell you what kind of Technical and core skills you will acquire how
you can mention these projects in your resume and how to explain these projects during the interview all of this information will be given to you as a downloadable PDF file all right let's get started the first one is sales insites it's a popular playlist on YouTube which have helped many Lander job in terms of technical skills you will learn how to use SQL and powerbi together in terms of core skills you will build business understanding in retail domain you will also develop analytical mindset the same project is available in tblo as well now this project
is prepared by Haman who is the co-creator of this YouTube channel he worked in Europe as a data analytics manager for many years and the project is based on his real life experience after you learn this project the way you can mention this on your resume is by using star method star means situation task action and result situation here here was that a computer hardware business was facing a lot of challenges in competitive market and they LED actionable Insight the task was to build an automated dashboard that can help you make data informed decision the
action was to do ad hoc analysis using SQL first and then you build a powerbi dashboard that can help you track Revenue growth year-over-year Trends and also regionwise sales performance the result was that due to this dashboard you were able to take actionable insights due to which the sales increased by 7% in next quarter now say you have learned this project then you have included this project in your resume and you get an interview call during the interview the interviewer will ask you questions related to this project at that time you need to be confident
answering those questions they may ask you how did this dashboard help you increase sales by 7% at that time you can say that that the insights that were generated via this dashboard help you perform customer prioritization and product optimization which eventually increase the sales you'll be able to answer those questions only if you have paid close attention to the entire project and you have done that project with full sincerity the second project is revenue insights here we invited industry expert Abhishek Anand who is a revenue manager in oo oo is a big hospitality company in
Asia and he gave his requirements to Haman who was a senior data analyst and they buil the dashboard in real time in terms of technical skills you will learn powerbi in terms of core skills you will gain business understanding of hospitality industry you will also learn how to have discussions with business stakeholders how to manage their expectations and also build analytical mindset this is how you'll mention this project on your resume in terms of situation atle Grand was a Hospitality chain which were facing a drop in their market share the task was to build a
dashboard which can provide actionable insights the action was that you build a dashboard that can track Revenue by category Trends by key metrics property performance realization percentage Etc as a result at lck regained their market share by 20% next month aan who is a data analyst at Ford right now used this exact same project during his interview I'm going to attach the presentation dag that Ragan used during the interview to explain this to the interview panel I would recommend downloading this deck and studying it do not copy and use this as it is because this
is just given to you as a reference or a guidance you should create your own deck the third project is T20 world World Cup Cricket analytics in this project we used a variety of tools we used python for doing web scraping we went to ESPN cric info website downloaded the data then we used pandas and powerbi for doing data cleaning data transformation and eventually used powerbi to build a dashboard so you will learn a variety of technical skills in terms of core skills you will build analytical mindset now this is not exactly a business project
although if there is company doing analytics in sports domain this can definitely help but in terms of interview especially if you are appearing for an interview in any of the South Asian countries where there is lot of interest and curiosity about Cricket it will ignite an interesting conversation and you will have an opportunity to showcase your work and discuss the skills that you learned out of this project and here is how you use star method to mention this project on your resume once again all of this is available as a PDF file in video description
below we have a learner shiv who landed an internship in Zoho using this project he mentioned that all the questions that were asked during the interview were based on this project doing guided projects is good it helps you get up and running but when you do unguided projects it will help you solidify your understanding of tools and you will also get a chance to practice the data analytics mindset while working on any project we will talk about three unguided projects that will span across various domains and business functions the first one is to provide insights
to executive team in Telecom domain you can scan this QR code and go to Cod Basics resume project challenge page where you will see many unguided projects we conduct this project challenges to help learner practice the skills and improve their online credibility so what people do is they participate in this projects participation is at free of cost you can practice your skills and then you submit a LinkedIn post uh where you are preparing a presentation and also a video recording to share your insights to business stakeholders this way you are not only practicing your technical
skills but you are practicing your core skills as well posting on LinkedIn will also help you improve your online credibility in terms of this specific project you will learn powerbi which is the technical skills that you will get out of this project and in terms of four skills you will build understanding in Telecom domain you will also learn how to build dashboards using the mockups and how to present insights to top level management here is a star method of how you can mention this project on your resume when you explain this project during the interview
focused on a conceptual use case there is a kpi that you are measuring before and after the event so by showing that on your dashboard you are able to measure the impact of that event on that specific kpi this is a very common use case in businesses now let's look at the project which covers multiple business use cases using SQL it is common in the industry for data analyst to run ad hoc SQL queries to give answers to the questions which are asked by business users in this specific project you will get to practice your
SQL skills by running various queries to generate answers for business questions so that will be the technical skills that you will practice in terms of core skills you will gain a domain understanding in consumer goods business you will also get an opportunity to practice analytical mindset communication sharing your insights with business stakeholders and here is how you'll mention this project on your resume while explaining this project focus on explaining various SQL queries and functions that you use to uh generate the insights during the interview the interviewer will be interested in two things how well you
know SQL and how well you can translate the business requirements into SQL queries the next project is in banking industry in terms of your technical skills you will use powerbi to generate some compelling visualization and you will also use some effective measures in terms of your core skills you will obviously get domain understanding in banking domain you will also learn how to generate insights from complex data and present it to top level management and here is how you mention the project on your resume the scenario mentioned in this project is common across various Industries so
while explaining this project to an interviewer focus on customer segmentation and how businesses can derive value out of it here is the final resume with all the projects at the end let me tell you one honest thing just by watching this video you're not going to get any help you have to go right now and start practicing these projects if you have any question there is a comment box below [Music]