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.
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 ❤
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 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.
@@G3nM 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
@@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, 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
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.
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.🔥🔥🔥
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
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
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 ?
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 .:)
@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.
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
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)😅😅 .
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?
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
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.
Hi Toufiq, I attended sql interview and the interviewer asked me below sql query. Kindly explain and help me to crack next interview. Thanks SQL: Table A with column C1 has 7 records I. E 1,1,1,1,1,Null, Null and Table B with column C2 has 5 records I. E 1,1,1,2,Null. How records we will fetch by using inner join, left join, right join and full join.
@@rameshthanikonda7027 you can easily try to simulate this in your SQL environment. This is a very good use case to understand how joins operate when you have duplicated matching terms.
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.
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 !
Bro, I am planning to enroll to your SQL session. I know I will only get the recordings , but if I have some doubts in the middle, Still You can help me right?
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?
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
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.
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
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..
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??
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
Thanks to your sql videos. I got 4 offers for business analyst and data analyst position. having skills SQL+ Power BI
Amazing .. I am so glad to hear that 🥳👏
And congratulations 💐
It's amazing to see the comment here
@@techTFQ Thankyou so much Sir.
Superb!!
@@mrvariskhan101 from where did u learned powerbi? Please reply
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, brother!! This video is very helpful like all other videos. I am learning SQL from your videos and I am very thankful to you.
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 ❤
Thanks a lot .. I am glad to hear that 🙏🏼
Hey bro what all skills did u learned and how much time it took you to complete
Seen many videos so far, but none as nice as this one ..this guy is simply awesome
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.
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
Thank you so much for sharing
@@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.
@@G3nM 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
@@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 road map. U can't even imagine how much this video meant to me for my career.
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
Thank you .. It was really informative.. Waiting for more such informative videos.. :)
Glad you liked it 🙏🏼
Thank you bro. I was looking for a path to enter Data Analytics and your channel was my answer ♥
Thank you so much for this. I'll follow everything here. GOD BLESS YOU 🙌
I love the way you to encourage people rather than scaring 🙏🏼🙏🏼
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.
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.🔥🔥🔥
Thank you Gaurav.. so happy to receive such feedback 🙏🏼🙏🏼
did u do any sql certification course. from where did u learn it?
Can you share your linked in profile so that we can connect!
Thank you so much for sharing the exact information which I wanted to know .
This is so helpful, thank you so much for making this video!
You are 100% correct. 80% company data problem can be solved with Excel powerquery, powerbi and sql
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
This video made feel as if I already have a job as a Data Analyst , Thank you so much
Great video bhai, kudos to you
Thank you Ahmed ☺️🙏🏼
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
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 ?
No there is a lot of data too
Thanks for sharing these videos. They are really helpful one
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 .:)
@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.
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.
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
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)😅😅 .
you build us confidence
Simplyyy superb
Thank you 🙏🏼
OMG you are amazing! thank you so much!!
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?
Nice one. If i will get success through your recommendations then i will definitely meet u personally boss...
Amazing video.. Amazing Content & Briefing.. Helpful to many(including me).. I thank you tfq on everyone behalf..
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
Thanks alot u provide great roadmap very helpful 👍
Good Info ! Thank You
Your welcome 🙏🏼
Many thanks 🙏. The video was very helpful
Thank you sir for this guidance. Wish you all the best from Bangladesh 🇧🇩.
Thank you , great information
Glad you liked it
Thank you sir it was indeed worth watching your videos.thank you so much
Hello, The video was very good and more information. Requesting to make complete video on linkedin details please.
Thank you so much brother for your nice content 🙏🙏🙏🙏🙏
Wow.. So perfect guidance
Very good information.👍
Thank you 🙏🏼
This is very help full thank u sir
To the TECHTFQ family thank for your love nd support ,sir any video in this video
Thanks so much!
Your welcome 🙏🏼
great bro thank you
Your welcome 🙏🏼
Thanks for the information
Excellent guidance
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.
Very helpful video , thank you
Wow thank you so much
Informative 👌
Thank you 🙏🏼
It's very useful video
Thank you 🙏🏼
Hi Toufiq,
I attended sql interview and the interviewer asked me below sql query. Kindly explain and help me to crack next interview. Thanks
SQL:
Table A with column C1 has 7 records I. E
1,1,1,1,1,Null, Null and
Table B with column C2 has 5 records I. E
1,1,1,2,Null. How records we will fetch by using inner join, left join, right join and full join.
I hope I'll get solution in the next video. Thanks in advance..
inner join -15
left join - 17
right join - 17
full join -19
@@rameshthanikonda7027 you can easily try to simulate this in your SQL environment. This is a very good use case to understand how joins operate when you have duplicated matching terms.
@@tammineniashokkumar Hi Kur can you please give explaination for this i'm confused
This video is lit!
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.
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 !
Loved the video, what if you learn tableue instead of Power BI?
That’s fine too .. either power bi or tableau .. any one
Am a non technical girl, looking for it job now..
Wish me a luck
Thank you sir........❤️
great share but sir i have a portfolio on my linkedin but still struggling for finding a jobs as a fresher
Please start giving training for beginners in this field. So that somehow they get experience how to work. Thanks
Thank you so much sir
Hii Sir
SQL from A to Z is it free or need to purchase..
thank u helped me a lot
Sir i know tableau and sql but still i couldn’t get as freshers job
Thank you so much ,because i am learning it now ,can you please share interview questions...
Thank you so much for your recommendations sir. May I know when your SQL course starts again?
Thank u ashraf bhai
Thanks brother
Nice...👍
Thank you 🙏🏼
Thanks so much
Bro, I am planning to enroll to your SQL session. I know I will only get the recordings , but if I have some doubts in the middle, Still You can help me right?
Yes I can .. you can post your questions in telegram group
@@techTFQ how to enroll in your SQL course
Me also
Use the link below:
www.lighthall.co/class/8b7467e4-2756-4fb2-b0a1-4423579e227b
@@techTFQ bro how about the access to recordings and sessions ...any time limit? Or life time?
u are too good sir
Xcellent content
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?
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
Hii sir thankyou for making this video is power bi good option for freshers n how to start
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.
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
Thank you so much for this.
Which course can one take to learn Tableau?
Power BI is not a free course, can you suggest some good website for free to learn power BI
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..
Hi sir. I have a question , your SQL course is enough to learn all the concepts for data analyst position????
Yea it’s enough but I don’t plan to make the next batch for next 4 months
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 sir
Can show me data scraping amzon product using selenium multiple page
please make video on USER DEFINED FUNCTIONS in sql
I am 2nd criteria swittch in it sector as a data analyst..
What is easier to get into data analyst or software testing? (With no experience in either field)
Hi, presently I am using zoho analytics as a bi tool. Did you hear about it
I have heard but never used .. I think many use it
@@techTFQ yes recently it got placed in gartner charts as niche player
Nice.. I’ll check them out soon
even after learning SQL,Power BI(wih project),Basic EXCEL and Python but not able to get a single job . What to do now?
U got a job bro
@@patil8302 yes I got one but not just by learning skills and doing projects, we need good network connections and refferal too.
Hey, nice video. What do you think about people without experience trying to work as freelancers? Is it doable?
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?
Which is best data analyst or data engineer?
If someone is not much comfortable in coding
Data Analyst
Can we learn Power BI from the course that is provided by Microsoft ??
Please make a video about LinkedIn
Sir please which software is required for sql.
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
Can you pls do similar video to become data engineer?
How to prepare data analyst resume applicant