AumS
Brilliant Links:
https://www.mastersindatascience.org/careers/data-analyst-vs-data-scientist/#:~:text=Simply%20put%2C%20a%20data
%20analyst,fit%20for%20your%20career%20goals.
https://www.northeastern.edu/graduate/blog/data-analyst-vs-business-analyst/#:~:text=Business%20analysts%20use
%20data%20to,make%20decisions%20on%20their%20own.
https://www.youtube.com/watch?v=-psusaPKLg0
Data Science and Data Analyst and Business Analyst
Data Scientist-
Mostly their job involves data mining, data cleaning, developing big data infrastructure, creating algorithms that can
be used to analyze big data. Their job involves lot of coding. Hence must know coding.
A data scientist may spend up to 60% of their time scrubbing data.
Data mining using APIs or building ETL pipelines.
Data cleaning using programming languages (e.g. Python or R).
Statistical analysis using machine learning algorithms such as natural language processing, logistic regression, kNN,
Random Forest or gradient boosting.
Creating programming and automation techniques, such as libraries, that simplify day-to-day processes using tools
like Tensorflow to develop and train machine learning models.
Developing big data infrastructures using Hadoop and Spark and tools such as Pig and Hive.
Data Analyst- Will use the data mined by the data scientist and use the models to analyse the data to find out why
something happened. Such as why the sales dropped.
Data Analysts:
Data querying using SQL.
Data analysis and forecasting using Excel.
Creating dashboards using business intelligence software.
Performing various types of analytics including descriptive, diagnostic, predictive or prescriptive analytics.
There is some overlap in analytics between data scientist skills and data analyst skills, but the main differences are that
data scientists typically use programming languages such as Python and R, while data analysts may use SQL or Excel to
query, clean or make sense of data. Another difference is the techniques or tools they use to model data: Data
analysts typically use Excel and data scientists use machine learning.
DATA ANALYST SKILLS DATA SCIENTIST SKILLS
Data Mining Data Mining
Data Warehousing Data Warehousing
DATA ANALYST SKILLS DATA SCIENTIST SKILLS
Math, Statistics Math, Statistics, Computer Science
Tableau and Data Visualization Tableau and Data Visualization/Storytelling
SQL Python, R, JAVA, Scala, SQL, Matlab, Pig
Business Intelligence Economics
SAS Big Data/Hadoop
Advanced Excel skills for data
Machine Learning for data modeling
modeling
Business Analyst
A Business Analyst (BA) is an expert who analyses an organization and its business domains and documents its business
model while integrating it with technology. Business Analyst helps a business by improving its processes, products,
services etc. through data analysis.
He is someone who uses data to get business insights which can help the business run more profitably
As a Business Analyst, you will analyse business problems and then resolve it using technology. You may be working in
different business sectors like Finance, Banking, Telecom, Social Media, Insurance, Marketing, Public Services, etc. As a
Business Analyst, you will be involved in:
Business Development: You will identify the organizations’ need and business opportunities
Business Model Analysis: You will define policies of the organization and market approaches
Process Design: You will standardise the processes of the organization
System Analysis: You will interpret the business rules and the requirements for technical systems to improve the
Business tech.
As a Business analyst, you will be mostly working on one of the above. You will work with the Information Technology
team.
He is the interface between the business management and the data analyst/data scientist. He converts the business
problem into data problem. Also identifies patterns and insights from the output generated by the data scientist and
communicates them to the management for appropriate policy and decision making. Must know how to use the
statistical and data mining tools. Not be an expert at coding.
Business analysts must have at least a working knowledge of the technology involved in analytics, though the need for
hard technical skills is generally lower than for data analysts. For those looking for career advancement opportunities,
however, developing an advanced knowledge of mathematics, computer science, and analytics can act as a significant
differentiator in the job market. Important Programming Languages: Python, R, JavaScript
It is a multidisplinary field that can be approached from various pathways:
1) Bsc Computer Science
2) Btech/BCA
3) Bachelors in Economics
4) Bachelors in Mathematics/Statistics.
5) Certification courses in Data Science
6) Certification courses in Business/Data Analytics
For a business analyst, Having domain knowledge along with technical skills is very important .
You may be hired as Data Scientist / Data Science Consultant / Research Analyst (Data Science) / Management Trainee in
different consulting firms as well as MNCs. You may also get a job in the role of a Data Analyst and then work your way
up into Data Science roles.
Some of the organization that hire Data Scientists are:
Some of the leading consulting firms are Accenture, Bain & Company, Boston Consulting Group (BCG), Deloitte,
Ernst & Young, KPMG, McKinsey, PwC, etc.
Online Retail Organizations like Amazon, Flipkart, etc.
Banks like Axis Bank, HDFC, Citi Bank, etc.
Social Media like Facebook, Twitter, etc.
Technology companies like Apple, Microsoft, etc
IT companies like TCS, Infosys etc.
Competencies Required:
Business Analyst Data Analyst Data Scientist
Investigative Investigative Investigative
Conventional Conventional Conventional
Enterprising Artistic Realistic
Colleges and Courses:
MBA colleges for Data Analytics/Business Analytics:
15 Best Colleges For MBA In Data Analytics And Business Analytics
MBA Colleges Course Name Type of Course Fees (Rs. in lakhs) Test/ Eligibility
Criteria
IIM Bangalore MBA in Business 2 Years Full-time 21.15 CAT
Analytics (MBA-BA)
IIM Calcutta Post Graduate 2 years of Full-time 20 CAT
Diploma in Business
Analytics (PGDBA)
IIM Ahmedabad EPGD in Advanced 16 months diploma
Business Analytics
ISB Hyderabad Advanced 1 Year Full-time 9.4 Merit and at least 2
Management MBA years of work
Programme in experience
Business Analytics
(AMPBA)
Great Lakes Institute MBA in Business Weekend Executive 21.50 (Including Merit and 2 years of
of Management, Analytics MBA Program International Study) full-time work
Chennai experience
SCMHRD Pune MBA in Business 2 Years Full-time 13.3 SNAP
Analytics
Lal Bahadur Shastri PGDM-Research & 2 Years Full time 15 + CAT, GMAT
Institute of Business Analytics
Management (LBSIM)
New Delhi
NMIMS Mumbai and PGD in Data Science 1 Year Part-time 5.11 Merit (Graduation) -
Bengaluru and Analytics MBA for executives 50% above
EMPI New Delhi PGP in Research and 1 Year Part-time 4+ CAT, XAT, MAT,
Business Analytics (Weekend) CMAT, ATMA
Prin. L. N. Welingkar PGDM Research and 2 Years Full-time 11 CAT, XAT, ATMA,
Institute of Business Analytics CMAT, GMAT
Management
Development and
Research
IIM Calcutta, ISI PGD - Business 2 Years Full-time 20 Minimum of 60%
Kolkata & IIT Analytics marks or CGPA 6.5 in
Kharagpur (Tri- B. Tech./ B.E./ M.Sc./
Institute Course) M.Com or equivalent
Symbiosis Centre For MBA Data Analytics 2 Years Full-time 5.6 SNAP
Information
Technology
BITS PILANI MBA IN BUSINESS 2 YEARS FULL TIME BAT EXAM
Candidates holding a
ANALYTICS bachelor’s degree in
any discipline or its
equivalent with at
least 60% aggregate
marks.
The
candidate
should have
studied at
least one
subject in
Mathematic
s or
Statistics at
the high
school
(10+2) or
higher level.
School of MBA Business 2 Year Full-time 1.4 CAT
Management Studies, Analytics
University of
Hyderabad,
Hyderabad
Indian Institute of M Sc Data Analytics 2 Years Full-time N.A Merit (Graduation 6.5
Information CGPA and 60%)
Technology and
Management – Kerala
(IITM-K)
Loyola Institute of Executive Diploma in 1 Year Part-time 2.4 Merit (Academic
Business Business Analytics Records & Work exp.)
Administration,
Chennai (In
collaboration with
TCS)
NL Dalmia, Mumbai Post Graduate 11 Months Part-time N.A. NLD-SAT + Personal
Certificate in Big Interview
Data with SAS
Programs in Data Science:
Online:
IIT Madras 4 year BS Degree after 12th - https://onlinedegree.iitm.ac.in/academics.html#AC1
Bachelors Level Courses:
1) IISER Bhopal - 4-year BS program in Data Science and Engineering
2) IISER Kolkata- Has :
- BS-MS program ( 5 years)
- Integrated MS - Phd Program
3)GITAM institute of Science, Vishakapatnam
- Msc in Data Science
- MSc in Applied Mathematics
- MSc in Statistics
5) Chennai Mathematical Institute (CMI, estb. 1989):
MSc in Mathematics
MSc in Computer Science
MSc in Data Science
6) VIT University, Chennai
- MSc in Data Science
7) Xavier Institute of Computer Applications, Ahmedabad:
- Msc in Big Data Analytics
8) Loyola College Chennai
- Msc in Data Science
9) University of Kerala
- Msc in Data Science
10) IIIT, Bangalore
M.Sc. (Research) Data Sciences
10A) DHIRUBHAI AMBANI INSTITUTE OF INFORMATION AND COMMUNICATION TECHNOLOGY - [DA-IICT],
GANDHINAGAR
- MSc Data Science
11) Amrita Vishwa Vidyapeetham, Coimbatore
M.Sc. Applied Statistics and Data Analytics
12) Madras School of Economics
Post Graduate Diploma Data Science and Financial Engineering
13) Madras Christian College
- PG Diploma in Data Science
14) Fergusson college, Pune
15) Christ University, Bangalore
https://www.mindler.com/blog/data-science-programs/
Links:
https://www.mindler.com/blog/data-science-career/
ONLINE TUTORIALS
Test your interest in data science:
Kaggle.com (recommended by Piyush)
On-line courses/Tutorials: i. Microsoft Virtual Academy:
ii. Edx.Org:
https://www.edx.org/course/data-analytics-for-everyone?
index=product_value_experiment_a&queryID=2068104eb435666be1426ed7ed7e2b9a&position=9&linked_from=autoc
omplete.
iii. Coursera.org:
a. Introduction to Data Analysis Using Excel https://www.coursera.org/learn/excel-data-analysis
b. https://in.coursera.org/learn/wharton-customer-analytics?specialization=business-analytics
1UDEMY
https://www.udemy.com/course/sql-mysql-for-data-analytics-and-business-intelligence/
ONLINE COURSES CAN BE USED TO GET A FLAVOUR OF IT:
- EDX
-COURSERA
- UDEMY
- MICROSOFT ACADEMY
- IBM SKILLS
- SIMPLILEARN
- GREATLEARNING FROM GREAT LAKES
Advanced Program in Data Science by IIM Calcutta
Post Graduate Program in Data Science from Purdue University and Simplilearn
Post Graduate Program in Data Science by Praxis Business School
Post Graduate Program In Data Analytics by Imarticus
Post Graduate Program in Data Science and Business Analytics by Great Learning
Post Graduate Diploma in Data Science by Upgrad
Post Graduate Certification in Data Science by Edureka
Post Graduate Diploma in Data Science by Jigsaw Academy
Post Graduate Diploma in Data Science
PG Diploma in Data Science and AI
PG Diploma in Data Science And Analytics
