How to become a Data Analyst FASTER ?

hey everyone welcome back now a lot of you guys reach out to me asking me for some guidance and help on your job search and most of you guys who reach out to me I can categorize you into one of the three categories number one you are a fresher and you're looking for your very first job number two you are already working for a few years but you are working in a non-technical role and now you want to get into the technical side of things uh so you think maybe becoming a data analyst or a business analyst in the field of data science or data analytics would be a good starting point and number three you are having a career Gap that is you worked for a few years previously and then you had to take a break from your career due to some personal reasons and now you want to start working again and you think getting into a technical role would be a good maybe as a data analyst or some sort of analyst now generally when anyone reaches out to me I would recommend them to watch my previous video where I have explained in detail all the steps that you need to do in order to get your very first job as a data analyst and that video itself is actually very good it's one of the most successful videos on my channel and I know it has helped a lot of you guys to understand what you need to do in order to become a data analyst but there is a problem the problem is if you are someone who belongs to one of the three categories that I mentioned previously then for those people if someone tells you that you need to learn all the different skills like python SQL Tableau power bi statistics you need to build a portfolio project you need to have portfolio website you need to have a resume you need to have LinkedIn you need to have good connections and so much more if you are told all of these things to do and if you are someone who's coming from a non-technical background or a fresher or with a career Gap then you would be very scared and even before you could start your journey of learning and becoming a data analyst just by looking at the different things that you need to do in order to become a data analyst would kind of might scare you off and it might reduce your confidence and you might question yourself if this is something that is fit for you and if you can actually achieve this because there is so much to learn and there is so much to do right and that is why I wanted to come up with this video where I wanted to explain in the most easiest way that is the most easiest step or the most fastest steps that you can take to become a data analyst so in this video I'm going to tell you only two skills okay only two skills that you need to learn to become a data analyst and I'm going to tell you how you can learn these two skills that is I'm going to tell you the platforms that I would recommend for you to learn these two skills and I'm also going to tell you how much time you should be spending to learn these two skills and once you have learned these two skills I'm also going to tell you at the end of the video what are the additional things that you can do in order to give yourself the best chance to become a data analyst or to get your first data analyst job so if you are a fresher or you are coming from a non-technical background or you are having a career Gap and you want to become data analyst the fastest way and the easiest way then the two skills that you need to learn are SQL and power bi so these are the only two skills that I would highly recommend that you get started with and these two skills should actually be pretty good enough for you to give you a job as a data analyst now I know a lot of you guys might be thinking what only SQL and power bi what about Tableau okay what about Excel what about python what about statistics right now I'm going to explain all of that in a short while but first of all let me tell you why do you need to learn SQL and power bi okay so before I can tell you that you first need to understand what exactly does a data analyst do a data analyst is expected to extract the data analyze the data Maybe clean the data and then draw some meaningful insights from that data right now in order to do all of this the two skills that you need are SQL and power bi so you need SQL so you can connect to the database extract the data query the data so that you can have a look at the data maybe you need to clean the data you need to analyze the data and maybe you will be able to build a small report using that data right now once you have done all of that next thing is you need to Showcase whatever insights that you have whatever you have found or whatever problem that you have solved using this data you need to Showcase this into a stakeholder to a stakeholder right now when you showcase your data to a stakeholder you cannot just showcase it in an Excel file or in your database right you need to present it in a more beautiful manner Maybe by building dashboards or by doing visualization so even a non-technical person with no technical skills will be able to look at the dashboard and able to understand what you're trying to convey using that data right and in order to build this dashboard and in order to build this visualization you will need to learn power bi because using power bi you can basically visualize your data and showcase it in a more beautiful way so even if you have a very simple report you can showcase it like something extraordinary and the stakeholder might actually get pressed and might be able to clearly understand what you're trying to convey now to all of those people who are thinking why power bi why not Tableau now the thing is power bi is much simpler to learn than Tableau and if you had learned power bi and in future if you want to learn Tableau it's going to be much simpler for you to learn a tableau or for that matter any other visualization tool that is the reason I would recommend power bi first and the second point is power bi is owned by Microsoft and most of the companies today are using some sort of Microsoft products and the thing is when a company purchases a Microsoft product Microsoft would generally maybe not force but would generally give you pretty good offer to purchase all the other products that Microsoft offers so there is a very high chance that your company would already be having access to power bi so if you already know power bi you kind of give yourself the best chance to get hired okay so that is the reason why I recommend SQL and power bi and maybe not Tableau if you are learning Tableau well and good but my recommendation is start with SQL first and then move on to power bi only these two skills okay now some of you might be thinking what about Python and what about a statistics right and the thing is if you know Python and statistics it is fantastic you give yourself a very good chance of getting shortlisted in much more companies but it is not mandatory okay the most mandatory skill to become a data analyst I would say is SQL and power bi and after that if you want to Learn Python statistics and Tableau and anything else that is all up to you but get started with SQL and power bi now I'm sure a lot of people will be thinking what about Excel Excel is used everywhere right but the thing is I'm not including Excel as part of this skill set because Excel is actually very simple okay even if you start a learning Excel now within the next 24 hours I can guarantee you that you will be comfortable with basic Excel and I'm not talking about all the complex things that you can do in Excel I'm talking about can you read the data in an Excel file you should just know how to fill filter the data how to apply some simple formulas right and all of this in Excel you can learn within 24 hours you don't need to I I do not want to include that as part of a separate skill set okay and that is why SQL and power bi are the only two skills that you need to learn to get started of course once you know this you can learn more and you can learn more tools and more skills with time now I have told you the two skills that you need to learn that is fine but how do you learn these two skills okay now I'm going to give you my recommendations on the platforms that you can use to learn these skills let's start with SQL now for SQL the platform that I would recommend is learnsql.com now this is a platform that is dedicated for SQL courses so if you go into the courses section I think you can find over 50 different SQL courses so you have courses for the absolute beginners so there is a course like SQL from A to Z and if you're getting started with SQL this is the course that I would recommend that you take so if I just open this course and if I just go here you can see that this course kind of starts from the absolute Basics it goes into all the SQL functions and then all the DML operations that you need and then it also tells you about reporting and then some advanced concepts like window functions recursions Group by extensions Etc okay so if you are starting from absolute scratch then SQL from A to Z is a course that I would recommend but of course there are so many different courses that are available on this platform okay so you can find all the different courses depending on what you want to learn all available in learn sql.com and this is a platform that I would recommend and let's say you are someone who wants to learn SQL based on specific rdbms so you have the options of learning from MySQL post to SQL or SQL server in this platform but my recommendation is let's say you want to learn SQL from scratch and you're confused about which rdbms you should choose I would say that don't worry about which rdbms you need to choose because once you learn SQL in any rdbms you will be able to apply your non knowledge of that SQL into any other rdbms okay because 80 to 90 percent of the SQL used in all the rdbms are the same there will be hardly 10 or 20 percent difference in some of the functions and very few syntactical differences that you can easily grasp if you have knowledge of any SQL okay so don't worry about rdbms my recommendation is if you are learning SQL in MySQL or Microsoft SQL server or in Oracle or in post way SQL then you should be pretty good any one of these rdbms is actually pretty good my personal favorite is postgresql and how I would recommend you to use this platform is once you come to the courses section and if you are planning to learn SQL from scratch I would recommend this course as I already told you and other than that what you can do is you can just filter some commands here so if I just uncheck the practice SQL you will get all the different sections of basically learning the SQL Concepts you can choose any of this courses and once you have learned the concepts then what you can do is you can just click on this practice SQL these are all the different courses where you can practice writing SQL queries so each of these courses would have a lot of different SQL queries that you can solve and this can actually improve your SQL skills okay so learn SQL Concepts first and then try to practice SQL using any of these courses once you have done all of this then what I would recommend is go into the stata scratch website now the status scratch is a fantastic platform for practicing SQL queries here you can find some free SQL queries to practice as well just go on coding questions and you can choose either possibly SQL or MySQL even if you have learned using some other rdbms don't worry you can just practice using any of this SQL mentioned here and you can choose the free SQL questions and try to practice it and once you have practice all the free questions you can then maybe purchase a subscription and practice more interview questions it's a very fantastic platform for solving a real SQL interview queries and I would highly recommend this okay so this is how you can learn SQL go to learn sql.com and learn all the SQL Concepts and then try to practice SQL by taking up any of this practice SQL courses okay once you are done with this then you can go to strata scratch and you can solve a real SQL interview queries on a status scratch okay so once you have learned SQL the next thing that you need to learn is power bi now for learning power bi the only course that I would recommend is the course that is present in codebasics dot IO it's a fantastic coach and I can guarantee you that if you can complete this course on power bi you would be very confident in power bi and by the time you complete this course you would have already solved a project basically done a project which you can actually post it in your resume okay now the best thing about this course is that it's not just a course which teaches you about power bi it kind of teaches you on how to work as a data analyst okay because there is a lot of additional things that is present in this course so they take you step by step on how you would be getting a work as a data analyst how you would receive an email how you should be responding to the email email and how you should start thinking about how to solve that particular problem how to Showcase your problem to the stakeholders etc etc so this is a fantastic course for anyone who wants to become a data analyst you will learn power bi and also you will learn a lot of useful skills and tips that you need to become a good data analyst so now let's say you have learned SQL and you have learned power bi now how much time do you need to spend to learn these two skills now from my own experience and my recommendation is that start with learning SQL and keep one month for learning SQL so every day try to spend two hours for learning SQL for up to a month and I think in one month you will not only learn all the SQL Concepts you'll also be able to practice SQL in learn sql.com platform as well as in stata scratch platform so two hours per day for one month I think it's more than enough time to learn SQL now once you have done that next thing that you need to do is you need to spend again two hours per day for the next one month in doing this power bi quotes in code Basics Dot i o okay so if you can spend just two hours per day for one month I think it's more than enough time to complete this course and also to complete the project that is involved in this course okay and you can straight away put this project in your resume as well so in total one plus one that is two months to learn the skills that you need to become a data analyst okay now once you have done this what next okay so you cannot just learn these skills and then keep quiet and expect the recruiters to reach out to you and give you a job right it's never going to happen you still need to take the next step to build a resume and to reach out to the recruiters on LinkedIn especially to get your job right but additionally what you can do is you can go to codebasics dot IO okay the same platform where you will find a power bi code and here recently I have seen that they have started adding this resume projects okay so if you click on this resume project and and as far as I know that every month they will be adding new projects in this particular section they have already added one of the projects as you can see here it's a provide insights to revenue team in Hospitality domain okay and I know one of my contacts and Linkedin Ashish actually completed this project he had recently learned SQL and power bi and then he was able to complete this project and he has actually done a very good job he shared it with me in LinkedIn and he has also shared it with everyone in LinkedIn and he has got a very good feedback so what I would recommend is once you learn SQL and power bi go to code Basics choose this resume project and I believe every month you will have new projects added here currently I can see one project try to complete this project okay anyone who understands basics of SQL and basics of power bi who has learned power bi from code Basics I am sure will be able to do this project so complete this project and once you have completed this project you can showcase this project in your resume okay so you will have one this project and the other project that you have already done using the power bi course okay so once you have these two projects you can put it in your resume and I think you'll also get certification from a code basics for your power bi quotes and also you'll get certifications for your SQL codes done in learn sql.com so once you have these two certifications and once you have done these two projects you can put it in your resume and if you want to resume a format I have already made a previous video about resume format you can probably follow that format and once you have done that just try to be active in LinkedIn try to post your projects in LinkedIn try to build connections and try to apply for jobs okay hopefully with this you will give yourself the best chance to get your first data analyst job okay so I hope this video was helpful you got some insights so if you are from non-technical background if you are a fresher or if you are having a career Gap just learn SQL from learn sql.com and practice SQL also in learnsql.com and also you can practice it in stata scratch and then try to learn power bi using the power bi course in codebasics dot IO once you have learned these two skills go to codebasics dot IO complete the resume project and put that project in your resume become active in LinkedIn showcase the projects that you have done apply for jobs and hopefully very soon you will be able to get your first data analyst job okay so I hope this video was helpful and if it was I would love to hear your success stories on my LinkedIn as well as in the comments below thank you so much for watching and see you soon in the next one bye

Channel: techTFQ

Views: 98,224

Keywords: How to become a Data Analyst FASTER, data analyst, data analyst job, how to get first data analayst job, skills required to become a data analyst, data analyst skills, data analytics, data science, data analyst career path, data analyst roadmap, how to learn data analytics, data scientist, data analyst career, data analyst projects, data science career path, how to become data analyst, data analytics career, data analysis, power bi, how to learn data analyst skills, sql

Id: hsaPfEvForM

Length: 16min 19sec (979 seconds)

Published: Fri Sep 30 2022