Register Now


Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.


Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Data Analytics Interview Questions | Day 2

Welcome to the 2nd Day of Data Analytics Interview Questions Quiz.
You can go through the question and answer for Day 1 Here
The best answer to the quiz was provided by Raahul
Data Analytics Interview Questions

In this series, all you need to do is to go through the questions and try to attempt it with whatever knowledge you have.

Before or after you attempt the questions, do go through the complete road map about what you need to study to crack an analytics role. We have covered from 3rd year college student to 8 years of analytics or non-analytics experience. Make sure you understand where to emphasize more(after all by the end of the day you want to crack an interview)

Complete Roadmap for cracking an Analytics Role in the next 30 days

Now, coming back to our questions. Remember, these are the most asked questions in any interview, if you are shy to answer the questions in the comment section, then do make sure to Google the answer and jot it down in your notebook.

Data Analytics Interview Questions


  1. Write the sequence of the commands in which it is executed in the backend of SQL. (Most asked interview question)
  2. What is the difference between HAVING and WHERE in SQL?
  3. What is the use of Coalesce() function in SQL?


  1. Create a list of a list
  2. Create a dictionary of list
  3. Is string mutable or immutable? Give an example

Case study

  1. KFC wants to open its first branch in India, what data points should be considered before it entering in a new market?

Machine Learning

  1. Define precision and recall using a simple example
  2. Can we use linear regression for a classification problem?

The Data Monk services

We are well known for our interview books and have 70+ e-book across Amazon and The Data Monk e-shop page . Following are best-seller combo packs and services that we are providing as of now

  1. YouTube channel covering all the interview-related important topics in SQL, Python, MS Excel, Machine Learning Algorithm, Statistics, and Direct Interview Questions
    Link – The Data Monk Youtube Channel
  2. Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
    Link – The Data Monk website
  3. E-book shop – We have 70+ e-books available on our website and 3 bundles covering 2000+ solved interview questions. Do check it out
    Link – The Data E-shop Page
  4. Instagram Page – It covers only Most asked Questions and concepts (100+ posts). We have 100+ most asked interview topics explained in simple terms
    Link – The Data Monk Instagram page
  5. Mock Interviews/Career Guidance/Mentorship/Resume Making
    Book a slot on Top Mate

The Data Monk e-books

We know that each domain requires a different type of preparation, so we have divided our books in the same way:

1. 2200 Interview Questions to become Full Stack Analytics Professional – 2200 Most Asked Interview Questions
2.Data Scientist and Machine Learning Engineer -> 23 e-books covering all the ML Algorithms Interview Questions
3. 30 Days Analytics Course – Most Asked Interview Questions from 30 crucial topics

You can check out all the other e-books on our e-shop page – Do not miss it

For any information related to courses or e-books, please send an email to

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me

Comments ( 2 )

  1. SQL
    2. HAVING is used when using a GROUP BY in SQL. It is used to filter based on the aggregated column. For example, if we want to see number of customers occurring more than once, following is the query-
    select cust, count(*)
    from table
    group by cust having count(*)>1
    WHERE is used to filter based simply on conditions (without any aggregation necessary).
    3. COALESCE() function is used to output the first non-null value within it. for eg select coalesce (col,0) will output 0 if col is null.

    1. a = [1,2,3]
    b = [2,4,5]
    c = [a,b]
    print(c) – [[1, 2, 3], [2, 4, 5]]
    2. a = [1,2,3]
    b = [2,4,5]
    c = {1:a,2:b}
    print(c[1]) – [1,2,3]
    3. A string is immutable in Python. We cannot append, extend or pop characters from strings.

    Case Study
    Factors –
    1. External – Existing competition performance and macro-economic conditions of India (inflation, raw items prices, consumer spending sentiment)
    2. Customer – Taste, existing preferences and preferences/openness related to similar food items.
    3. Internal – Small scale or large scale? (one outlet or multiple outlets launched simultaneously?)
    4. Location – Population density, income groups and city development/growth factors.

    Machine Learning
    1. Precision is the ratio between true positives and the all the positives predicted by the model and recall is the ratio between true positives and the true positives and false negatives.
    2. No. linear regression deals with a continuous dependent variable, whereas we deal with discrete values in classification problems.

    • Nice answer Raahul, considering the exit strategy will also get some points as a big company will always have a exit strategy before entering a new market. Overall very good answers