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
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
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.
This is so helpful, thank you so much for making this video!
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.
Thank you so much for sharing the exact information which I wanted to know .
Thank you so much for this. I'll follow everything here. GOD BLESS YOU 🙌
Seen many videos so far, but none as nice as this one ..this guy is simply awesome
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
Amazing video.. Amazing Content & Briefing.. Helpful to many(including me).. I thank you tfq on everyone behalf..
Thank you bro. I was looking for a path to enter Data Analytics and your channel was my answer ♥
Many thanks 🙏. The video was very helpful
OMG you are amazing! thank you so much!!
I love the way you to encourage people rather than scaring 🙏🏼🙏🏼
Thank you so much for this road map. U can't even imagine how much this video meant to me for my career.
Thank you sir it was indeed worth watching your videos.thank you so much
Thanks alot u provide great roadmap very helpful 👍
This video made feel as if I already have a job as a Data Analyst , Thank you so much
Thanks for sharing these videos. They are really helpful one
Thank you so much brother for your nice content 🙏🙏🙏🙏🙏
Very helpful video , thank you
Thank you .. It was really informative.. Waiting for more such informative videos.. :)
@techTFQ
Жыл бұрын
Glad you liked it 🙏🏼
Wow.. So perfect guidance
you build us confidence
Thanks for the information
Thank you , great information
@techTFQ
Жыл бұрын
Glad you liked it
Excellent guidance
Good Info ! Thank You
@techTFQ
Жыл бұрын
Your welcome 🙏🏼
Nice one. If i will get success through your recommendations then i will definitely meet u personally boss...
Great video bhai, kudos to you
@techTFQ
Жыл бұрын
Thank you Ahmed ☺️🙏🏼
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
Thank you sir for this guidance. Wish you all the best from Bangladesh 🇧🇩.
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 .:)
This is very help full thank u sir
Wow thank you so much
Thanks so much!
@techTFQ
Жыл бұрын
Your welcome 🙏🏼
thank u helped me a lot
Informative 👌
@techTFQ
Жыл бұрын
Thank you 🙏🏼
Very good information.👍
@techTFQ
Жыл бұрын
Thank you 🙏🏼
This video is lit!
Thank you so much sir
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
Thank you sir........❤️
Please start giving training for beginners in this field. So that somehow they get experience how to work. Thanks
To the TECHTFQ family thank for your love nd support ,sir any video in this video
Thanks so much
Thank you so much ,because i am learning it now ,can you please share interview questions...
Simplyyy superb
@techTFQ
Жыл бұрын
Thank you 🙏🏼
great bro thank you
@techTFQ
Жыл бұрын
Your welcome 🙏🏼
Thanks brother
Xcellent content
Hello, The video was very good and more information. Requesting to make complete video on linkedin details please.
Thank u ashraf bhai
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?
@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.
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)😅😅 .
u are too good sir
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.
Thank you so much for this. Which course can one take to learn Tableau?
Nice...👍
@techTFQ
Жыл бұрын
Thank you 🙏🏼
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
It's very useful video
@techTFQ
Жыл бұрын
Thank you 🙏🏼
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.
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.
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
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.
What is easier to get into data analyst or software testing? (With no experience in either field)
please make video on USER DEFINED FUNCTIONS in sql
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?
Hii sir thankyou for making this video is power bi good option for freshers n how to start
Can you pls do similar video to become data engineer?
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 !
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
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
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!
Loved the video, what if you learn tableue instead of Power BI?
@techTFQ
Жыл бұрын
That’s fine too .. either power bi or tableau .. any one
Sir i know tableau and sql but still i couldn’t get as freshers job
Thank you so much for your recommendations sir. May I know when your SQL course starts again?
I am from civil engineering background which is best for me as a non technical person Data analyst or sales force
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.
great share but sir i have a portfolio on my linkedin but still struggling for finding a jobs as a fresher
Hi sir Can show me data scraping amzon product using selenium multiple page
Can we learn Power BI from the course that is provided by Microsoft ??
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
I am 2nd criteria swittch in it sector as a data analyst..
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
even after learning SQL,Power BI(wih project),Basic EXCEL and Python but not able to get a single job . What to do now?
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
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..
Please make a video about LinkedIn
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??
Hi thank u so much I want to register how can I register class pls
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
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
Please share the plateform to learn whole excel
Can i get job of power bi without any certification(pl 300) if I do self study n projects
Sir please which software is required for sql.
Am a non technical girl, looking for it job now.. Wish me a luck
do i need to learn SSIS, is it mandatory for power bi please advice
Do we need to learn data structures for data science bro?
Which is best data analyst or data engineer? If someone is not much comfortable in coding
@techTFQ
Жыл бұрын
Data Analyst