DATA SCIENCE & DATA ANALYSIS CHEATSHEET
MENTORS SKILLS JOB ROLES & CAREER PATHS BOOKS
Programming Machine Learning Data Scientist Operations Research Analyst
YASH RAINA (Python/R/SQL) & AI (for Data 1 10 1 Big Data and Analytics by Subhashini
Chellappan and Seema Acharya
Vice President, Diageo Essential for data Scientists)
manipulation, analysis, and Building predictive models 2 Data Analyst 11 Database Administrator (DBA) Data Analytics by Anil Maheshwari
building models. using algorithms like 2
HARI PRAKASH Data Visualization
regression, decision trees,
and neural networks.
3 Machine Learning Engineer 12 Marketing Data Analyst Data Science Odyssey Exploring The Power Of
Data Scientist, Meta (Tableau/Power 3
Big Data & Cloud Analytics by Astitva Prakashan
BI/Matplotlib/ Computing (Spark/
Seaborn) 5 AI Research Scientist 13 Health Data Analyst
SHRIKANT KEJRIWAL Hadoop/AWS/GCP) 4 Data Analytics using Python by Bharti Motwani
Communicating insights Handling large datasets
effectively through charts
SVP 2, Head Analytics - Bharat and graphs.
efficiently.
4 Big Data Engineer 14 Cybersecurity Data Analyst
Banking and Corporate Banking, Critical Thinking & Python for Data Analysis: Data Wrangling with
Axis Bank Statistics & Problem-Solving 5 pandas, NumPy, and Jupyter by Wes
McKinney
Probability Interpreting data,
6 Business Intelligence Analyst 15 Product Data Analyst
Understanding identifying trends, and
DIPTI RANJAN PRADHAN distributions, hypothesis making data-driven 16 Financial Data Analyst 6
Data Science and Data Analytics:
Opportunities and Challenges by Amit Kumar
testing, and statistical decisions. 7 Statistician Tyagi
Head of Engineering - Data significance.
Platform | Gen AI/ML | Data Communication & 17 Cloud Data Engineer
Science, Cisco Business Acumen Storytelling 8 Data Engineer 7 Data Science for Business by Herbert Jones
Understanding industry- Explaining complex 18 Sports Data Analyst
specific challenges and insights in a clear, non-
applying data solutions
SHAMBHU GUPTA effectively.
technical way to
stakeholders.
9 Quantitative Analyst (Quant) 19 E-commerce Data Analyst 8 Mastering the Data Paradox by Nitin Seth
Data Science Expert ( AI/ML &
Generative AI), SAP Labs India
SOURAV KARMAKAR ONLINE COMMUNITIES INTERVIEW QUESTIONS
Senior AI Scientist, Intuit
Big Data, Analytics, Business Intelligence &
How do you differentiate between descriptive, diagnostic, predictive, and prescriptive
SANCHIT AGGARWAL Visualization Experts Community 1 analytics?
Founder, Thynaa Health Big Data and Analytics
Naturally
Analytics / Data Science / AI Career
2 How do you determine whether a dataset is biased?
Power BI, Fabric, Business Intelligence, Tableau, 3 What are the key differences between structured, semi-structured, and unstructured data?
HONEY GUPTA
Senior Business Analyst, Adobe Data Science, SQL, Python, Gen AI, Cloud
Analytics 4 What are the advantages and disadvantages of dimensionality reduction?
KAVYA KILARI Data Analytics, Data Science, Business Analytics,
Startup Strategy, Amazon Web 5 How do you handle imbalanced datasets in classification problems?
Services Business Intelligence, Data Scientist & Analyst
6 Explain Bayes’ Theorem with a real-world application in data analytics.
SUBHODEEP
MUKHERJEE
Data Scientist II, Amazon
CERTIFICATIONS 7 What is the difference between Type I and Type II errors?
What statistical tests would you use to determine whether two groups have significantly
8 different means?
AKSHAY TOPRE Degrees & Certifications Explain the difference between parametric and non-parametric models. When would you
Associate Manager | Product
Strategy & Analytics, Uber
9 use each?
10 How would you handle a dataset with missing values?
RAHUL SINGH 1
Certified Analytics Professional
Data Scientist - Product, Google (CAP)
11 What are the pros and cons of bagging vs. boosting in ensemble learning?
ABHISHEAK SARASWAT
Senior Data Scientist, IBM IBM Data Science Professional 12 You build a classification model and get an accuracy of 98%. Why might this be misleading?
2
Certificate
13 Explain the concept of Feature Engineering and how it impacts model performance.
YOUTUBE 3 Microsoft Certified: Azure Data
Scientist Associate
14 Give a SQL query to find the second-highest salary from an employee table without using
LIMIT.
RESOURCES 15 How would you optimize a SQL query that takes too long to run?
Danial | Tech & Data What are the differences between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER
1 4 Google Professional Data 16 JOIN?
(Channel) Engineer
17 How does MapReduce work in processing large datasets?
2 Ken Jee ( Channel)
5 SAS Certified Data Scientist 18 What are the key differences between batch processing and stream processing?
3 Data Analytics vs Data
Science by IBM Technology 19 How do you handle data pipeline failures in an ETL process?
6 Postgraduate Diploma/Master’s 20 Can you explain a real-world project where you turned data into actionable insights?
4 Data Professor (Channel) in Data Science
Introduction to Data
21 How would you communicate complex data insights to a non-technical stakeholder?
5
Structures and Algorithms You notice a decline in customer retention in an e-commerce company. What steps would
Courses 22 you take to diagnose the issue?
course by CodewithHarry
Data Analytics with Projects
6
by WsCube Tech
1 Harvard’s Data Science
Professional Certificate (edX)
PODCASTS
Data Analysis Tips by Wale
7
Gbads Super Data Science: ML
Data Stories by Enrico & AI Podcast by Jon
Data Analytics | Data Data Science Specialization Bertini and Moritz Stefaner Krohn
2
8
Analytics Full Course For (Coursera )
The Data Science Data Skeptic by Kyle
Beginners by Simplilearn Podcast by Ananyaa Polich
Machine Learning (Stanford - Jha
Learn With Lokesh Lalwani 3
9 Andrew Ng, Coursera) Data Structure and The Data Scientist
(Channel) Show by Daliana Liu
Algorithm by Vasu Soni
Alex The Analyst & The Analytics Power Hour
Deep Learning Specialization Data Science With
10
CareerFoundry by 4
(Andrew Ng, Coursera) Ankit Bansal By Ankit by Michael Helbling, Moe
CareerFoundry Bansal Kiss, Tim Wilson, Val Kroll,
and Julie Hoyer
[Link]