How & What to Prepare for Data Analyst roles ?

[@westrahman]

Wow quite an expansive details of T&T for being a Data Analyst

[@akshaykilaru9301]

Very vivid explanation I have taken note of all the points. Just started with the course last week. Hopefully I complete it ASAP.

[@AppliedAICourse]

All the best. Please try to be consistent in your learning and you would be able to complete the course very easily in a short period time. Please reach out to us if you need any help.

[@devanshverma5395]

Really nice explanation. I saw quite a few of your videos and also the website but one thing that isn't clear about the job guarantee program is the minimum wage.please,shed some light on it.Thanks!

[@AppliedAICourse]

Our students have a wide spectrum of compensations that they have gotten. The compensation depends a lot on how well our students have learnt from the course. Most of our students get a compensation in the range of 5 lakhs to 50 lakhs per annum.

[@tarunreddy64]

Can you also do a video for Data Engineer?

[@ramanan56]

In the video, you have mentioned about FEATURE IMPORTANCE. Can we take it as Feature Engineering or simply the feature extraction/selection techniques? Pl. Cite some references. Thanks..

[@AppliedAICourse]

Feature importance is related to feature selection than other concpets listed above. Its helps you explain which features are more relevant and important to the task at hand.

[@datascientistoflife8550]

Excellent shrikant sir..

[@cyclerider929]

Thanks for clarification

[@subhodhks1879]

What is the average salary a fresher can get for a data analyst role? And do freshers have a DS&ALGO round in interviews or are interviews focused on SQL and other topics mentioned in the video?

[@AppliedAICourse]

Data analyst roles have compensations ranging from 3L to 10LPA for freshers. Not much focus would be on DS and Algo. There will be special focus on SQL and basic programming with simple data structures inbuilt in Python.

[@thetensordude]

Is it necessary for a machine learning engineering to be able to code any simple supervised machine learning model( suppose , logistic regression) from scratch?

[@AppliedAICourse]

Yes, many companies ask this to test your depth and clarity of understanding the core of the algorithms.

[@krconsultancyandsolutions153]

Informative 👍

[@himankaghosh7307]

Is there a data analyst course in Applied AI? I know there is a very exhaustive data scientist course.

[@AppliedAICourse]

We don’t have a separate Data Analyst course. But, students who pursued our ML course have landed in Data Analyst roles as a hat is often needed for a Data Analyst roles is a subset of what is covered in our course.

[@PreethiVarmaVlogs]

This is quite helpful. Thank you so much.

[@dipk.mishra]

Sir for DATA Analyst Role can we just use sklearn for understanding purpose or it is mandatory to write custom implementation the library from scratch.

[@AppliedAICourse]

Implementation from scratch will help you understand the algorithms better and improve your programming skills. So, it is better to implement them when you learn

[@ompatel84]

Great video. I have 8+ yrs exp in accounting and Auditing, with good experience in excel & access. Working towards to get Tableau certification. Know basic SQL & R Question What do you suggest me to show my SQL expertise as Microsoft is retiring certification exams? Should I focus on advanced R or start with python? Does SAS is helpful to learn? As of now, I am unemployed, so What job profile you suggest me to search & start for Data Analytics path?

[@AppliedAICourse]

It is best to build a portfolio of projects where you write SQL-based pipelines for data preprocessing and SQL query optimisation. You can also post some interesting analysis done using SQL, R or Tableau. Given your background in accounting and auditing, it’s best to build a portfolio of analysis projects in these domains on publicly a available datasets.

[@HackingWithCoffee]

What is the difference between Data analyst,. Data science, BI analyst ?

[@AppliedAICourse]

These titles are often used by companies interchangeably. It is good to look at the job-description(JD) to understand the role better than just looking at the job title.

[@prasadbvishnu]

I have 2 yrs of exp as an application developer and 2 yrs as a Research developer in the areas of ML, DL. To which roles I am eligible as I am confused between these. Either I am not a complete developer or complete researcher. Could you please suggest me on this

[@AppliedAICourse]

It may be better for you to become a Software engineer in ML teams as it helps you leverage and grow both in ML and Software engineering

[@KoliHarshad007]

Please make a similar video for data Engineering role or is it just same as this?

[@AppliedAICourse]

Data Engineering roles are very different with more focus on building data processing pipelines and big data systems.

[@KoliHarshad007]

@@AppliedAICourse oh thanks alot for your kind response

[@mohammadriyaz4u]

Hello sir, Whether AAIC course content covers all the skills for data analyst roles.!? If yes,how to proceed stepwise..!!

[@AppliedAICourse]

The topics listed in the video are a subset of topics we cover in our AI course. Our course is designed to crack a wide spectrum of roles including Data Analyst roles. Just cover the topics in the order provided in the course and complete the assignments.

[@vatsaldin]

can there be remote roles or remote working opportunities?

[@AppliedAICourse]

Yes, many companies are looking to hire for remote/WFH roles now.

[@cutyoopsmoments2800]

Course fees of Data analyst ??

[@AppliedAICourse]

We have only one course: AppliedAICourse.com. The topics listed in the video are a subset of topics we cover in our AI course. Our course is designed to crack a wide spectrum of roles including Data Analyst roles. Just cover the topics in the order provided in the course and complete the assignments.

[@tatinbhowmick2878]

Sir, I am from a civil engineering background only I know c language. Can I get a data analyst job after your applied ai course? I want to switch my career. Can a civil background student eligible for Data analyst, data scientist or ML engineer job? sir, please help,.

[@AppliedAICourse]

Yes, you can. As long as you are willing to pick up Python and learn the underlying Math and Algorithms of ML, you can comfortably transition to these roles. Please check the free videos and sessions on our website AppliedAICourse.com to see if you are able to follow the code and Math.

[@syedkamranpasha812]

What bout for someone with 4+ years of experience ?.. I've that Experience in data analysis from IBM, but we use MS Excel and power BI for work

[@AppliedAICourse]

You need to build rigorous understanding of the underlying math with applicative details. Tools are helpful, but ability to program and perform complex analysis are must have skills that most product based companies look for, in experienced candidates.

[@syedkamranpasha812]

Can you be more specific and elaborative when you say 'complex analysis' ?. What qualifies for being a complex analysis ?

[@AppliedAICourse]

Complex analysis involves using more advanced modelling, analysis and visualisation techniques appropriately in the context of the problem at hand . It also involves coming up with better hypothesis and testing them to make more interesting conclusions from data. It would also involve being able to think from the business needs and priorities and place your analysis in the business context to drive actual business value.

[@gouravtaurus2928]

Sir, Data preprocessing(Data standardisation or normalisation) is done before EDA or after EDA?

[@AppliedAICourse]

It is typically done before EDA. But the exact order sometimes depends on the problem context. You may have to clean the data after performing some EDA and observing anomalies in data.

[@gouravtaurus2928]

Applied AI Course Thank you so much sir.

[@bunnyarya2]

Hi sir, I am 2017 pass out.I have 1 year of experience in etl testing using sql and plsql. I lost my job due to covid19.i am from poor family. Is it worth taking this course to get job? Does my previous experience will be helpful? Please reply

[@AppliedAICourse]

Given your financial situation, we recommend you apply for jobs that need SQL/PLSQL and land in an another job ASAP. This will lower the financial stress. It takes few months of time and effort to complete the course. You can always join the course at a later time when you have a job and the financial stress is lower.

[@nobelkar7851]

Just want to add that - 1. Effective communication plays a very large role in the responsibility of a Data analyst. 2. Critical thinking is must too. 3. Good to gather some domain knowledge as well.

[@AppliedAICourse]

Good points. Thank you for sharing. The blogs we mentioned are a good way to showcase effective communication. Critical thinking is a must that can be built by understanding concepts intuitively and rigorously from first principles. Domain knowledge, while great to have, is hard to acquire across many domains. It needs lots of real world experience to gain which may be harder for folks with fewer years of experience.

[@Akashavani7]

Hii sir I completed my BTech in 2017 ....I have a knowledge in SQL and python ....I didn't do work in any organisation till now ....but now i want to start my career as data analyst....sir plz tell me how can I go in this area pls guide me step by step Thanks in advance 👍

[@AppliedAICourse]

Given your career gap, you should try and learn everything mentioned in the above video and then look for internships. That way you can build some experience that will help you transition to full time roles.

[@arun_sain]

Very informative as always

[@chaitanyaboyalla7487]

Will experience in Informatica cloud services: Data Warehousing help adding weight to the portfolio?

[@AppliedAICourse]

Yes, it will be helpful. But these are additional good to have and not must have skills. It is important to be good at the underlying math and coding related to ML algorithms

[@shubhamsinhha]

Can EDA on Haberman dataset can also be used to build portfolio or similar kind of analysis?

[@AppliedAICourse]

No. Its too simple for a case-study. Note that it is an assignment in our course which is used to help you learn and practice.

[@humanthings.2478]

Is that imp to have certification in all these programs or skills are just sufficiant ?

[@AppliedAICourse]

Certifications from top universities will give you stronger academic credentials and credibility which helps you communicate your expertise to recruiters better. At the end of the day, to crack the interviews skills are what matter the most. Certificates fundamentally add academic credentials to your resume.

[@roynation3567]

Does Applied Ai course covers sci- kit learn library and tensorflow?

[@AppliedAICourse]

Yes, in lots of detail. We also cover other major libraries relaxant to Data science and machine learning.

[@aravindraamasamy9453]

Does AAIC course provide necessary skills needed for a data analyst.

[@AppliedAICourse]

The topics listed in the video are a subset of topics we cover in our AI course. Our course is designed to crack a wide spectrum of roles including Data Analyst roles.

[@Ramesh-rp6jq]

Is applied ai provide data analyst training?

[@AppliedAICourse]

Yes. The topics listed in the video are a subset of topics we cover in our AI course. Our course is designed to crack a wide spectrum of roles including Data Analyst roles.

[@sprasanth7116]

I am a sales professional can i make a transition to the data analyst role

[@AppliedAICourse]

Yes, it is possible if you can pick up the skills and showcase them via a portfolio. You could look for roles in Sales and Financial Data Analysis as it would fit your prior experience well.

[@surajpatil3247]

Sir make video for data scientist also

[@AppliedAICourse]

Sure, will do

[@kashifshariff2569]

Importance of data structures and algorithms for any machine learning roles?I believe those are the most important could you please clarify?

[@AppliedAICourse]

We will post a video on this in the near future.Stay tuned! It's a good question.

[@futech2199]

Hey aaic team a very good morning to all , Sir what is the minimum package for data analyst role after completion of applied ml course . Thank you .

[@AppliedAICourse]

The minimum is about 5.5 LPA. Typically, good Data Analysts can easily get a compensation of 8-10 LPA

[@futech2199]

@@AppliedAICourse thank you for quick reply sir Btw is it ctc or gross ?

[@syedkamranpasha812]

What bout for someone with 4+ years of experience ?.. I've that Experience in data analysis from IBM, but we use MS Excel and power BI for work

[@AppliedAICourse]

Gross compensation.

[@AppliedAICourse]

4 years experienced candidates with the right skills can easily get a 10+ LPA compensation. Note that the hiring bar for experienced data analysts is also higher. You need to be good with underlying Math and programming. Knowledge of to tools like PowerBI is a good add-on skill, but not a key skill at most product based companies.

[@aayushgupta2046]

Thanks for providing information. Can you tell if data visualization tools like power BI, tableau and programming tool like R is useful or not .

[@AppliedAICourse]

They are useful especially for non programmers. But, most Data Analyst roles expect decent programming skills.