How to become a Data Analyst FASTER ?

Рет қаралды 98,283

Күн бұрын

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 Жыл бұрын

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

@techTFQ Жыл бұрын

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

@aloneluvr5469 Жыл бұрын

It's amazing to see the comment here

@mrvariskhan101 Жыл бұрын

@@techTFQ Thankyou so much Sir.

@balamuruganp3865 Жыл бұрын

Superb!!

@YG-jb2in Жыл бұрын

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

@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.

@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.

@sheronjoseph3110 Жыл бұрын

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

@whiteflameforjesus Жыл бұрын

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

@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

@trlavi85 Жыл бұрын

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

@anthonettemaemagalso8777 Жыл бұрын

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

@shaiksalma7849 5 ай бұрын

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

@arkaganguly938 Жыл бұрын

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

@rohanjain2738 Жыл бұрын

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

@andre968 Жыл бұрын

OMG you are amazing! thank you so much!!

@kalpanasharma5000 Жыл бұрын

Thanks for sharing these videos. They are really helpful one

@syedmohsinraza9055 Жыл бұрын

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

@Akanke766 Жыл бұрын

Many thanks 🙏. The video was very helpful

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

Thanks alot u provide great roadmap very helpful 👍

@venkatb323 Жыл бұрын

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

@rajkumarpalle8217 Жыл бұрын

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

@yogitasable4336 Жыл бұрын

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

@pritammishra9850 Жыл бұрын

Wow.. So perfect guidance

@prabhatshinde3404 Жыл бұрын

Very helpful video , thank you

@bunnystartech6330 Жыл бұрын

you build us confidence

@travelwithdk006 Жыл бұрын

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

@gayalaknatha Жыл бұрын

Thanks for the information

@vasanthavipparla4278 Жыл бұрын

Excellent guidance

@anjalismohan8203 Жыл бұрын

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

@techTFQ Жыл бұрын

Glad you liked it 🙏🏼

@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 Жыл бұрын

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

@brobye7660 Жыл бұрын

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

@SANDATA764 Жыл бұрын

Great video bhai, kudos to you

@techTFQ Жыл бұрын

Thank you Ahmed ☺️🙏🏼

@NEG0POS Жыл бұрын

Good Info ! Thank You

@techTFQ Жыл бұрын

Your welcome 🙏🏼

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

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

@sam502521 Жыл бұрын

Thank you , great information

@techTFQ Жыл бұрын

Glad you liked it

@manishrawat2895 Жыл бұрын

This is very help full thank u sir

@welcometomathy6944 Жыл бұрын

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

@ihsansaleheen6672 Жыл бұрын

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

@meella332 Жыл бұрын

Wow thank you so much

@kancharalaparameshwarreddy3837 Жыл бұрын

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

@sheronjoseph3110 Жыл бұрын

Xcellent content

@kavyagupta2674 Жыл бұрын

This video is lit!

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

Very good information.👍

@techTFQ Жыл бұрын

Thank you 🙏🏼

@Engineers451 Жыл бұрын

Informative 👌

@techTFQ Жыл бұрын

Thank you 🙏🏼

@fathimafarahna2633 Жыл бұрын

Simplyyy superb

@techTFQ Жыл бұрын

Thank you 🙏🏼

@sadashivkage3133 Жыл бұрын

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

@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 .:)

@mahmoudgamal8758 Жыл бұрын

thank u helped me a lot

@rebecca8693 Жыл бұрын

Thanks so much!

@techTFQ Жыл бұрын

Your welcome 🙏🏼

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

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

@sandhyagajaraj4826 Жыл бұрын

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

@nikitasinha8181 Жыл бұрын

Thank you so much sir

@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

@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.

@carzetonao Жыл бұрын

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

@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

@bunnystartech6330 Жыл бұрын

great bro thank you

@techTFQ Жыл бұрын

Your welcome 🙏🏼

@ritvikchauhan6106 Жыл бұрын

u are too good sir

@darlingtons.kolleh3400 10 ай бұрын

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)😅😅 .

@longliveindia1637 Жыл бұрын

Thank u ashraf bhai

@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 Жыл бұрын

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.

@aliciaessien1443 Жыл бұрын

Thanks so much

@suryatkurma7466 Жыл бұрын

Thanks brother

@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 Жыл бұрын

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 Жыл бұрын

Thank you so much for sharing

@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 Жыл бұрын

@@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 Жыл бұрын

@@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.

@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 Жыл бұрын

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.

@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?

@manis2831 Жыл бұрын

It's very useful video

@techTFQ Жыл бұрын

Thank you 🙏🏼

@clavermuwanguzi2233 Жыл бұрын

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

@monalisatpute8946 Жыл бұрын

Nice...👍

@techTFQ Жыл бұрын

Thank you 🙏🏼

@srishtijain642 Жыл бұрын

please make video on USER DEFINED FUNCTIONS in sql

@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?

@missintelligent772 Жыл бұрын

Can you pls do similar video to become data engineer?

@Tech_Enthusiasts_Shubham 11 ай бұрын

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

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

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

@InfoSarkari Жыл бұрын

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

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

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

@shivsharma9153 Жыл бұрын

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

@techTFQ Жыл бұрын

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

@sumantabiswas7662 Жыл бұрын

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

@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 Жыл бұрын

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 Жыл бұрын

No there is a lot of data too

@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 Жыл бұрын

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

@fhana1201 Жыл бұрын

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

@sundarsaikumar7548 Жыл бұрын

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

@jyotidixit1121 Жыл бұрын

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

@Dikshu_Bhavi_Bros Жыл бұрын

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

@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

@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

@thirunavukkarasunr3859 Жыл бұрын

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

@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.

@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?

@kanishaknarang8312 Жыл бұрын

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

@luwammhreteab2606 Жыл бұрын

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

@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 Жыл бұрын

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

@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

@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

@cartoonmoralstories2712 Жыл бұрын

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

@yunoasta2679 Жыл бұрын

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

@techTFQ Жыл бұрын

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

@daily_walk_with_God Жыл бұрын

Please make a video about LinkedIn

@Joel-pg4yi Жыл бұрын

I looked at data analyst exercise test and no clue what to do I grab myself by the head

@prateekagrawal1142 Жыл бұрын

Please share the plateform to learn whole excel

@sreenivas351 Жыл бұрын

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

@mayurjoshi1452 Жыл бұрын

Sir, what about statistics which will best?

@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??

@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..