How to become a Data Analyst FASTER ?

Do you want to know how to easily become a Data Analyst? The only 2 skills you actually need to get a Data Analyst Job. Even if you are a Fresher OR you are a Non Technical person OR you have a Career Gap, this is the video which will give you all the details you need to become a Data Analyst faster.
In this video, I only talk about the most essential skills a Data Analyst must have and the skill which is good enough for anyone to get your first Data Analyst job.
I will also mention my recommended courses and platforms to learn these essential Data Analyst skills which will give you a very good chance of getting hired as a Data Analyst.
🔴 Links to my recommended platforms (Affiliate link) as mentioned in the video 👇
✅ For Learning SQL:
learnsql.com/?ref=thoufiqmoha...
✅ For Learning PowerBI:
codebasics.io/courses/power-b...
✅ For Practicing SQL:
www.stratascratch.com/?via=te...
🔴 Timestamp 👇
00:00 Intro
00:13 Who is this video aimed at?
01:13 Problem with most DA recommendations
02:55 The 2 Skills required to become a Data Analyst
03:40 What does a Data Analyst do?
03:54 Why do you need these 2 skills?
05:03 Why not Tableau?
06:03 Why not Python & Statistics?
06:34 Why not Excel?
07:22 How to learn the 2 recommended skills?
07:33 How to learn Skill 1?
11:15 How to learn Skill 2?
12:17 How much time you need to learn these 2 skills?
13:34 Additional things to do to get job
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
✅ Git and GitHub Tutorial:
• Git and GitHub
✅ Data Analytics Projects:
• Data Analytics Projects
THANK YOU,
Thoufiq

Пікірлер: 192

  • @mrvariskhan101
    @mrvariskhan101 Жыл бұрын

    Thanks to your sql videos. I got 4 offers for business analyst and data analyst position. having skills SQL+ Power BI

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Amazing .. I am so glad to hear that 🥳👏 And congratulations 💐

  • @aloneluvr5469

    @aloneluvr5469

    Жыл бұрын

    It's amazing to see the comment here

  • @mrvariskhan101

    @mrvariskhan101

    Жыл бұрын

    @@techTFQ Thankyou so much Sir.

  • @balamuruganp3865

    @balamuruganp3865

    Жыл бұрын

    Superb!!

  • @YG-jb2in

    @YG-jb2in

    Жыл бұрын

    @@mrvariskhan101 from where did u learned powerbi? Please reply

  • @BharatRathod-je5wx
    @BharatRathod-je5wx Жыл бұрын

    Thank you, brother!! This video is very helpful like all other videos. I am learning SQL from your videos and I am very thankful to you.

  • @whiteflameforjesus
    @whiteflameforjesus Жыл бұрын

    This is so helpful, thank you so much for making this video!

  • @shreyastudies4693
    @shreyastudies4693 Жыл бұрын

    Hey, I am very new to Data and am migrating as a non-technical person. I have seen many of your SQL videos. And this one especially was very reassuring - so thank you so much! Not many people know how to answer these questions, and it makes the learning process very daunting for people like me.

  • @trlavi85
    @trlavi85 Жыл бұрын

    Thank you so much for sharing the exact information which I wanted to know .

  • @anthonettemaemagalso8777
    @anthonettemaemagalso8777 Жыл бұрын

    Thank you so much for this. I'll follow everything here. GOD BLESS YOU 🙌

  • @sheronjoseph3110
    @sheronjoseph3110 Жыл бұрын

    Seen many videos so far, but none as nice as this one ..this guy is simply awesome

  • @marilyn3696
    @marilyn3696 Жыл бұрын

    Thank you so much, a new subscriber here, career shifter, data analyst on training. I will follow all your youtube videos so that I can have confidence in finding a job afterwards

  • @venkatb323
    @venkatb323 Жыл бұрын

    Amazing video.. Amazing Content & Briefing.. Helpful to many(including me).. I thank you tfq on everyone behalf..

  • @rohanjain2738
    @rohanjain2738 Жыл бұрын

    Thank you bro. I was looking for a path to enter Data Analytics and your channel was my answer ♥

  • @Akanke766
    @Akanke766 Жыл бұрын

    Many thanks 🙏. The video was very helpful

  • @andre968
    @andre968 Жыл бұрын

    OMG you are amazing! thank you so much!!

  • @arkaganguly938
    @arkaganguly938 Жыл бұрын

    I love the way you to encourage people rather than scaring 🙏🏼🙏🏼

  • @shaiksalma7849
    @shaiksalma78495 ай бұрын

    Thank you so much for this road map. U can't even imagine how much this video meant to me for my career.

  • @yogitasable4336
    @yogitasable4336 Жыл бұрын

    Thank you sir it was indeed worth watching your videos.thank you so much

  • @Khan-mc3gi
    @Khan-mc3gi Жыл бұрын

    Thanks alot u provide great roadmap very helpful 👍

  • @syedmohsinraza9055
    @syedmohsinraza9055 Жыл бұрын

    This video made feel as if I already have a job as a Data Analyst , Thank you so much

  • @kalpanasharma5000
    @kalpanasharma5000 Жыл бұрын

    Thanks for sharing these videos. They are really helpful one

  • @rajkumarpalle8217
    @rajkumarpalle8217 Жыл бұрын

    Thank you so much brother for your nice content 🙏🙏🙏🙏🙏

  • @prabhatshinde3404
    @prabhatshinde3404 Жыл бұрын

    Very helpful video , thank you

  • @anjalismohan8203
    @anjalismohan8203 Жыл бұрын

    Thank you .. It was really informative.. Waiting for more such informative videos.. :)

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Glad you liked it 🙏🏼

  • @pritammishra9850
    @pritammishra9850 Жыл бұрын

    Wow.. So perfect guidance

  • @bunnystartech6330
    @bunnystartech6330 Жыл бұрын

    you build us confidence

  • @gayalaknatha
    @gayalaknatha Жыл бұрын

    Thanks for the information

  • @sam502521
    @sam502521 Жыл бұрын

    Thank you , great information

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Glad you liked it

  • @vasanthavipparla4278
    @vasanthavipparla4278 Жыл бұрын

    Excellent guidance

  • @NEG0POS
    @NEG0POS Жыл бұрын

    Good Info ! Thank You

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Your welcome 🙏🏼

  • @travelwithdk006
    @travelwithdk006 Жыл бұрын

    Nice one. If i will get success through your recommendations then i will definitely meet u personally boss...

  • @SANDATA764
    @SANDATA764 Жыл бұрын

    Great video bhai, kudos to you

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you Ahmed ☺️🙏🏼

  • @sandiplondhe666
    @sandiplondhe666 Жыл бұрын

    Hey , Thank you so much for being there, You played defining role in transition myself into data Analyst. Your way of explaining SQL is just awesome Thanks man ❤

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thanks a lot .. I am glad to hear that 🙏🏼

  • @brobye7660

    @brobye7660

    Жыл бұрын

    Hey bro what all skills did u learned and how much time it took you to complete

  • @ihsansaleheen6672
    @ihsansaleheen6672 Жыл бұрын

    Thank you sir for this guidance. Wish you all the best from Bangladesh 🇧🇩.

  • @vandanatiwari332
    @vandanatiwari332 Жыл бұрын

    Hi Thoufiq.. Thank you for your wonderful videos.. I always follow and watch your videos and like the way you explain each and every thing!! Just need one suggestion.. Any idea from where we can learn Azure data engineer ( as you recommended codebasics.. like wise do you know any best site/course/any recommendation.) Thanks In Advance .:)

  • @manishrawat2895
    @manishrawat2895 Жыл бұрын

    This is very help full thank u sir

  • @meella332
    @meella332 Жыл бұрын

    Wow thank you so much

  • @rebecca8693
    @rebecca8693 Жыл бұрын

    Thanks so much!

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Your welcome 🙏🏼

  • @mahmoudgamal8758
    @mahmoudgamal8758 Жыл бұрын

    thank u helped me a lot

  • @Engineers451
    @Engineers451 Жыл бұрын

    Informative 👌

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @Sreekanth.Polasa
    @Sreekanth.Polasa Жыл бұрын

    Very good information.👍

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @kavyagupta2674
    @kavyagupta2674 Жыл бұрын

    This video is lit!

  • @nikitasinha8181
    @nikitasinha8181 Жыл бұрын

    Thank you so much sir

  • @welcometomathy
    @welcometomathy Жыл бұрын

    Very good video I would say that only power BI its the way, excel for basicts of working with tables and fomulae building with some basics of power query to get data on the own excel file table and external for fun. like using dax to join multiple identical tables into one table and do pivot from it. like every year accounting keep a file with 52 sheets cuntining the weekly sales of x company u need to join all those 53 sheet into one table and do a excel report, for that u need to know power query. Any big enough company that has a data team will have data eng and SQL devs and someone responsible to put the data together into power bi data sets that u just link to and work from no need to know SQL at alll

  • @sadashivkage3133
    @sadashivkage3133 Жыл бұрын

    Thank you sir........❤️

  • @PRIYANKASharma-uv8lx
    @PRIYANKASharma-uv8lx Жыл бұрын

    Please start giving training for beginners in this field. So that somehow they get experience how to work. Thanks

  • @kancharalaparameshwarreddy3837
    @kancharalaparameshwarreddy3837 Жыл бұрын

    To the TECHTFQ family thank for your love nd support ,sir any video in this video

  • @aliciaessien1443
    @aliciaessien1443 Жыл бұрын

    Thanks so much

  • @sandhyagajaraj4826
    @sandhyagajaraj4826 Жыл бұрын

    Thank you so much ,because i am learning it now ,can you please share interview questions...

  • @fathimafarahna2633
    @fathimafarahna2633 Жыл бұрын

    Simplyyy superb

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @bunnystartech6330
    @bunnystartech6330 Жыл бұрын

    great bro thank you

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Your welcome 🙏🏼

  • @suryatkurma7466
    @suryatkurma7466 Жыл бұрын

    Thanks brother

  • @sheronjoseph3110
    @sheronjoseph3110 Жыл бұрын

    Xcellent content

  • @PradeepKumar-hg1tl
    @PradeepKumar-hg1tl Жыл бұрын

    Hello, The video was very good and more information. Requesting to make complete video on linkedin details please.

  • @longliveindia1637
    @longliveindia1637 Жыл бұрын

    Thank u ashraf bhai

  • @nalinitamilmani
    @nalinitamilmani Жыл бұрын

    Hi sir..I'm new to your channel and this video was very informative.. I want to become a data analyst after a long break in my career.. but whatever you mentioned in the comments link all are paid sites... could you plz suggest some free online courses and free certification site which is offering SQL or Oracle certification?

  • @ritudahiya6223
    @ritudahiya6223 Жыл бұрын

    @techtfq thank u for sharing valuable information. Your sql video are next level. I wanted to take up code basic course that you recommend for powerbi.. I took a course on powerbi from somewhere else but that is a complete waste of money.. I hope code basic one will help like your sql videos.

  • @preethamailapuram3955

    @preethamailapuram3955

    Жыл бұрын

    Hi... How is the Code basics course ? is it worth taking?? And please lemme know where did you tk the sql course for real time knowledge Thank you.

  • @darlingtons.kolleh3400
    @darlingtons.kolleh340011 ай бұрын

    Hello brother, Thank you for your presentation, you are an Educator. Your video was very helpful to me. I have been really going the wrong direction, but your video have redirected my path to the right lane. I have SQL and Power BI Basics already; but didn't truly understand that I had something to improve on. I can now start practicing 2 hours a day. I also got Advance skill in Excel at the Power query level. I have been really giving myself headache on wanting to learning all the Skills ( Python, Tableau, R et al)😅😅 .

  • @ritvikchauhan6106
    @ritvikchauhan6106 Жыл бұрын

    u are too good sir

  • @Mhziko
    @Mhziko Жыл бұрын

    I attended the first DA interview. They required two skills - SQL & PBI. I thought they would be impressed with my overall preparation in all the other skills that you mentioned as optional. To master all jacks, I forgot some basic PBI questions answers, and the interviewer said he agrees I am good in SQL but not in PBI. He was somewhat correct because I didn't have any portfolio and importantly, I didn't revise the PBI topics for an interview at all. Therefore, I failed to prove my 1-year preparation although I haven't heard back yet. I believe the importance of your advice everyone will realize after attending a couple of interviews. If I knew this I would have landed an entry-level analyst position already. Thank you so much brother for your valuable advice.

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you very much for sharing your experience.. This is another proof on how to just get started .. just these 2 skills can take you a long way

  • @nikitasinha8181

    @nikitasinha8181

    Жыл бұрын

    Thank you so much for sharing

  • @Mhziko

    @Mhziko

    Жыл бұрын

    @@techTFQ just to let you know I finally got the job, alhamdulillah. Your SQL interview blog was really helpful. Thank you brother for your valuable resources. May almighty bless you.

  • @jacksparrow3595

    @jacksparrow3595

    Жыл бұрын

    @@Mhziko congratulations 🎉 Sir, can you please explain how much to learn in power bi and what are preferred the sources. I am pursuing code basics powerbi course

  • @Mhziko

    @Mhziko

    Жыл бұрын

    @@jacksparrow3595 I did some fundamental udemy courses. They are not good enough for the interview. Take some Dax courses once you are comfortable with the fundamentals.

  • @clavermuwanguzi2233
    @clavermuwanguzi2233 Жыл бұрын

    Thank you so much for this. Which course can one take to learn Tableau?

  • @monalisatpute8946
    @monalisatpute8946 Жыл бұрын

    Nice...👍

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @khushboo_313
    @khushboo_313 Жыл бұрын

    Bro the point you said in starting that everyone says excel, python etc etc.... It depressed me....... Thank you GOD ji for recommending this channel this video have just cleared my mind

  • @manis2831
    @manis2831 Жыл бұрын

    It's very useful video

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you 🙏🏼

  • @ayushpandita5463
    @ayushpandita5463 Жыл бұрын

    For a fresher who wants to enter in data analyst field is it important to showcase live projects in resume or we can go with any datasets projects which is available on various youtube platforms.

  • @mattmatt245
    @mattmatt245 Жыл бұрын

    For me power query editor replaces sql. You can create any type of query that you want using gui instead of typing code. Also, with power bi you can connect to any data source and pull tables that you need.

  • @carzetonao
    @carzetonao Жыл бұрын

    You are 100% correct. 80% company data problem can be solved with Excel powerquery, powerbi and sql

  • @sajithjames4692

    @sajithjames4692

    11 ай бұрын

    Consider Knime as well, it's an amazing open source tool for analytics! It's a visual workflow tool, with different connectors for DBs, as well as options to write Python / Java code in it as well

  • @humanandlifefacts9217
    @humanandlifefacts9217 Жыл бұрын

    Hi, Taufiq. I have few questions? 1. How to show my tableau, powerbi, excel project? I meant How do I show recruiter my powerbi and tableau projects. 2. Do my project need to be an end-to-end project where I should be using a single dataset showing data manipulation using SQL and then exporting it to tableau or power bi for creating the dashboard. Is it okay to have SQL project, tableau, and power bi project different from one another? 3. I have difficulties solving complex SQL queries. I need a lot of time to solve complex queries. In beginner-level role, how much complex queries I need to prepare for interview. Do interviewers ask complex queries to solve in the live interviews or give complex queries as tasks or assignments to solve? 4. how do I know I am ready to sit for power bi and tableau interviews? I meant how much I need to know about power bi and tableau to sit for an interview.

  • @jaysingh-kq9eb
    @jaysingh-kq9eb Жыл бұрын

    What is easier to get into data analyst or software testing? (With no experience in either field)

  • @srishtijain642
    @srishtijain642 Жыл бұрын

    please make video on USER DEFINED FUNCTIONS in sql

  • @humanandlifefacts9217
    @humanandlifefacts9217 Жыл бұрын

    Hi, Taufiq. Can you tell me how to make this kind of explanation alongside the dashboard shown in 14:30 th minutes of the video?

  • @InfoSarkari
    @InfoSarkari Жыл бұрын

    Hii sir thankyou for making this video is power bi good option for freshers n how to start

  • @missintelligent772
    @missintelligent772 Жыл бұрын

    Can you pls do similar video to become data engineer?

  • @soumyarath950
    @soumyarath950 Жыл бұрын

    Hi. Excellent Video ! I have 11 years of experience in the thermal power and infrastructure sector in Financial planning & MIS profile. I have skills like financial modelling, advanced Excel and PPT. Now I wanted to change my career into Data analytics. Please suggest whether it is a good decision and if I choose a data analytics career would i start from the scratch or my current experience also consider it terms of salary, designation etc. Your suggestion please !

  • @AzureDataFactoryInterview
    @AzureDataFactoryInterview Жыл бұрын

    Don't you think more and more people are entering into data analytics ( people from statistics background, IT freshers, non IT people) .Hence it will create a lot of competition and at the end there will be shortage of job in this field ?

  • @ziyanshaikh318

    @ziyanshaikh318

    Жыл бұрын

    No there is a lot of data too

  • @ajedits8093
    @ajedits8093 Жыл бұрын

    Hi toufiq sir . I am one of your subscriber and I have a career gap recently I critified with POWER BI + SQL please advice me how to start a career with this skill as a data analyst. How can I apply for job . Please

  • @gauravtricks8267
    @gauravtricks8267 Жыл бұрын

    I have started watching you few months ago and trust me i have learn lot from you. I have got job of data analyst. Thank you for making life changing videos.🔥🔥🔥

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Thank you Gaurav.. so happy to receive such feedback 🙏🏼🙏🏼

  • @fhana1201

    @fhana1201

    Жыл бұрын

    did u do any sql certification course. from where did u learn it?

  • @sundarsaikumar7548

    @sundarsaikumar7548

    Жыл бұрын

    Can you share your linked in profile so that we can connect!

  • @shivsharma9153
    @shivsharma9153 Жыл бұрын

    Loved the video, what if you learn tableue instead of Power BI?

  • @techTFQ

    @techTFQ

    Жыл бұрын

    That’s fine too .. either power bi or tableau .. any one

  • @jyotidixit1121
    @jyotidixit1121 Жыл бұрын

    Sir i know tableau and sql but still i couldn’t get as freshers job

  • @Joy-jp3pm
    @Joy-jp3pm Жыл бұрын

    Thank you so much for your recommendations sir. May I know when your SQL course starts again?

  • @thirunavukkarasunr3859
    @thirunavukkarasunr3859 Жыл бұрын

    I am from civil engineering background which is best for me as a non technical person Data analyst or sales force

  • @dipbaw6874
    @dipbaw6874 Жыл бұрын

    Can we do SQL from your lighthall course. Is it sufficient.. Please give a reply . Can I access your recording class after purchasing. Also provide the validity information of the course.

  • @Tech_Enthusiasts_Shubham
    @Tech_Enthusiasts_Shubham11 ай бұрын

    great share but sir i have a portfolio on my linkedin but still struggling for finding a jobs as a fresher

  • @Dikshu_Bhavi_Bros
    @Dikshu_Bhavi_Bros Жыл бұрын

    Hi sir Can show me data scraping amzon product using selenium multiple page

  • @kanishaknarang8312
    @kanishaknarang8312 Жыл бұрын

    Can we learn Power BI from the course that is provided by Microsoft ??

  • @deekshamallikarjun8561
    @deekshamallikarjun8561 Жыл бұрын

    Hi, I am a developer. Now I want to switch the role to data analyst. Since I m not experienced in data analytics it's difficult to switch company. Apart from courses and certifications what needs to be done? Is it possible to switch to data analyst role without experience?

  • @techTFQ

    @techTFQ

    Жыл бұрын

    If you already have experience as developer then it’s much easier to become a data analyst.. I would say you follow the steps I mentioned in this video and you should be in pretty good position to become a DA

  • @sumantabiswas7662
    @sumantabiswas7662 Жыл бұрын

    I am 2nd criteria swittch in it sector as a data analyst..

  • @sontisampathkumar7148
    @sontisampathkumar7148 Жыл бұрын

    sir i got placement in a company which works on data analytics could i have good future and opportunities after with this work experience in data analytics field

  • @Ydesigning
    @Ydesigning Жыл бұрын

    even after learning SQL,Power BI(wih project),Basic EXCEL and Python but not able to get a single job . What to do now?

  • @prachidhaka1189
    @prachidhaka1189 Жыл бұрын

    Sir i have a question in data analysts career can a degree matter or marks matter . And matter then a bcom or any other graduate is faced a problem in future if they want to get into this feild but their background is not good

  • @sanufrancis4061
    @sanufrancis4061 Жыл бұрын

    Sir, I am new to DA. I had a big career gap of 12 years. I wish to restart my career . I just wanted to know which sql I shud use Ms sql or PostgreSQL in data analyst job. Pls answer. TIA..

  • @daily_walk_with_God
    @daily_walk_with_God Жыл бұрын

    Please make a video about LinkedIn

  • @debabrotapal2089
    @debabrotapal2089 Жыл бұрын

    Sir i just start SQL .one small question..my company provided a laptop.i am not able to install SQL server just because my laptop is in company's domain.is there any alternative way to install sql server??

  • @luwammhreteab2606
    @luwammhreteab2606 Жыл бұрын

    Hi thank u so much I want to register how can I register class pls

  • @yunoasta2679
    @yunoasta2679 Жыл бұрын

    Hi sir. I have a question , your SQL course is enough to learn all the concepts for data analyst position????

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Yea it’s enough but I don’t plan to make the next batch for next 4 months

  • @mostafaatique5272
    @mostafaatique5272 Жыл бұрын

    Hello Sir, I have some questions to you that 1. Is it possible to work remotely as Data Analyst ? 2. What are the skills required to work as Remote Data Analyst 3. SQL and Python are Mandatory for Remote Analyst ? SIR if you could please tell in details. Thanks

  • @prateekagrawal1142
    @prateekagrawal1142 Жыл бұрын

    Please share the plateform to learn whole excel

  • @InfoSarkari
    @InfoSarkari Жыл бұрын

    Can i get job of power bi without any certification(pl 300) if I do self study n projects

  • @user-wl1bs9pl5c
    @user-wl1bs9pl5c11 ай бұрын

    Sir please which software is required for sql.

  • @cartoonmoralstories2712
    @cartoonmoralstories2712 Жыл бұрын

    Am a non technical girl, looking for it job now.. Wish me a luck

  • @AA-bv2ej
    @AA-bv2ej Жыл бұрын

    do i need to learn SSIS, is it mandatory for power bi please advice

  • @sreenivas351
    @sreenivas351 Жыл бұрын

    Do we need to learn data structures for data science bro?

  • @saketsourav_hjp
    @saketsourav_hjp Жыл бұрын

    Which is best data analyst or data engineer? If someone is not much comfortable in coding

  • @techTFQ

    @techTFQ

    Жыл бұрын

    Data Analyst