ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2200 Interview Questions to Become Full Stack Analytics Professional
From Fresher to 8 Years of experience (Bestseller)		10 E-books to crack Analytics Interview
Crack Data Analyst and Business Analyst Interview		23 e-books bundle to make a career in Analytics
Focuses on Data Science and Machine Learning
2
3
4
DayPrimary TaskSecondary TaskThe Data Monk Way
5
Day 1SQL - Basics syntax, MIN,MAX,IN,BETWEEN,wild cardsMS Excel 50 questions (mostly around shortcuts)
6
Day 2SQL Basics - 2 (Joins - Inner, left, right,outer)MS Excel 50 Questions (Moderate level, vlook up, hlookup, match and index, functions)SQL 250 Most Asked Interview Questions
7
Day 3SQL Basics - 2 (Cross Join and Self Join)4 Case Studies - KPIs for Zomato, Ola, OYO, Myntraa
8
Day 4SQL Intermediate - Window functions (Rank,Row_number,Dense_rank)4 Case Studies - KPIs Dunzo, Licious, Nykaa, Apple
9
Day 5SQL Intermediate - Unnesting a columnAmazon's 14 Leadership PrinciplesPython 200 Most Asked Interview Questions
10
Day 6SQL Intermediate - Union, Exists,Any,All,Case when,NULL treatment4-5 Case Studies on different department like Data Platform team, HR team,Digital Analytics
11
Day 7SQL Advance - JSON functionsMock Interview and Build your resume
12
Day 8SQL Advance - Date time conversionRevisionPandas 100 Most Asked Interview Questions
13
Day 9SQL Server Basics - Create,Alter table50 Basic Questions on Power BI
14
Day 10SQL Theory - Normalisation, ACID, DDL,DML50 Moderate Questions on Power BINumpy 100 Most Asked Interview Questions
15
Day 11Python - Basic data types50 Basic Questions on Data Preprocessing
16
Day 12Python - loop and function50 Moderate Questions on Data PreprocessingCase Study and Guesstimate 100 Questions
17
Day 13Python Special Number problems - Armstron, Prime,Factorial, etc.30-40 Basic Regular Expression questions (you won't get a lot of solved questions on Internet, bu do search)
18
Day 14Python - Pattern Printing, star patterns, word pattern, etc50 Basic Questions on Shell ScriptingMS Excel 100 Most Asked Interview Questions
19
Day 15Python - Questions on String manipulationBasics of Customer Life Time ValueStatistics and Data Preprocessing 125 Questions
20
Day 16Pandas - Basics 50 Basic questions on Statistics
21
Day 17Pandas - Importing and cleaning data50 Basic Questions on AWS Big Data Technologies 100 Most Asked Interview Questions
22
Day 18Pandas - 30 Interview questions50 Moderate questions on AWS
23
Day 19Pandas Moderate interview questions - 30Apply on portals like Naukri, Hirist, Linkedin, Monsterjobs, Indeed, etcAWS 100 Most Asked Interview Questions
24
Day 20Numpy - BasicsApply on Company websites (We will provide you the link to top 100 company's Career Page)Hadoop 100 Most Asked Interview Questions
25
Day 21Numpy 30 Interview QuestionsMock Interview and revision
26
Day 22MS Excel revisionMachine Learning Basics - 50 QuestionsData Pipeline 50 Most Asked Interview Questions
27
Day 23Case Study RevisionLinear Regresssion Basics - 50 QuestionsLinear Regresssion 50 Interview Questions Questions
28
Day 24Data Pipeline 50 questionsLogistic Regression Basics - 50 QuestionsLogistic Regresssion 50 Interview Questions Questions
29
Day 25Hadoop 50 Basic QuestionsNLPNatural Language Processing Interview Questions Questions
30
Day 2650 Terminal CommandsDecision Tree and Random ForestDecision Tree and Random Forest Interview Questions Questions
31
Day 27Power BI RevisionK-NN and K meanK-NN and K mean Interview Questions Questions
32
Day 28Data Preprocessing RevisionForecastingForecasting Interview Questions Questions
33
Day 29AWS RevisionRevisionRevision
34
Day 30Machine Learning Questions RevisionMock Interview and revisionMock Interview and revision
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100