Register Now

Login

Lost Password

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

Login

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

Analytics Interview Questions | Day 1

Analytics Interview Questions
In this series we will try to solve as many questions as possible in 4 areas, SQL, Python, Machine Learning Algorithms, and Miscellaneous. All you need to do is to comment your answers below and the best answer will get an extra e-book for free πŸ˜›

You need to attempt these questions, put everything in one comment, we will evaluate and will announce the winner in the next day’s post

Analytics Interview Questions

Analytics Interview Questions

We will follow the below pattern:
– SQL (3 Questions)
– Python (2 Questions)
– Case Study (1 Question)
– Machine Learning and Statistics (2 Questions)

SQL

  1. There are two tables X and Y, X has a column A that contains 4 rows -1,-1,-1,-1. Y has a column B that contains -1,-1,-1 (Most asked interview question)
    How many rows will be there if we do X left join Y
  2. What is the use of partition in a table?
  3. What is the difference between the Drop and Delete table? (Meesho, OYO rooms)

Python

  1. What is a mutable and immutable data type? (Most Asked Questions)
  2. How do you read a CSV file in Python?
  3. What is the syntax of group by in Python ?

Case Study

  1. For a particular e-commerce company, there has been a decline in the number and value of items stored in the cart. Tell all the possible reasons for this decline?

Machine Learning Concepts

  1. What is the p-value? Explain in a very layman term with simple example
  2. What is correlation? Explain with simple example

The Data Monk Interview Books β€“ Don’t Miss

Now we are also available on our website where you can directly download the PDF of the topic you are interested in. At Amazon, each book costs ~299, on our website we have put it at a 60-80% discount. There are ~4000 solved interview questions prepared for you.

10 e-book bundle with 1400 interview questions spread across SQL, Python, Statistics, Case Studies, and Machine Learning Algorithms β€“ Ideal for 0-3 years experienced candidates

23 E-book with ~2000 interview questions spread across AWS, SQL, Python, 10+ ML algorithms, MS Excel, and Case Studies β€“ Complete Package for someone between 0 to 8 years of experience (The above 10 e-book bundle has a completely different set of e-books)

12 E-books for 12 Machine Learning algorithms with 1000+ interview questions β€“ For those candidates who want to include any Machine Learning Algorithm in their resume and to learn/revise the important concepts. These 12 e-books are a part of the 23 e-book package

Individual 50+ e-books on separate topics

Important Resources to crack interviews (Mostly Free)

There are a few things that might be very useful for your preparation

The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews with Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics managers, etc.
Go through the watchlist which makes you uncomfortable:-

All the list of 200 videos
Complete Python Playlist for Data Science
Company-wise Data Science Interview Questions β€“ Must Watch
All important Machine Learning Algorithm with code in Python
Complete Python Numpy Playlist
Complete Python Pandas Playlist
SQL Complete Playlist
Case Study and Guesstimates Complete Playlist
Complete Playlist of Statistics

Thank you

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
    1. 12 rows
    2. Partition is used in window functions, for doing aggregation or operations in a particular window. For example, rank() over(partition by customer) would organize the data customer wise and the rank operation will work customer window-wise.
    3. delete is used for manipulating data within a table whereas drop is used to delete an entire table from the schema.

    Python
    1. Mutable datatype is one in which the elements can be changed and immutable is one in which the elements or the structure cannot be changed. For example, a list is mutable – you can append, extend or pop elements in it. A tuple is immutable – you cannot make any changes to it.
    2. import pandas as pd
    file = pd.read_csv(‘file_name.csv’)
    3. for example, df is the name of the dataframe and col is the column by which we need to group our data.
    df.groupby(col).sum()

    Case Study
    Some clarification questions-
    1. What category do these items belong to? General or a particular category only?
    2. Were there any changes made (in the UI or otherwise) on the platform?
    3. What is the magnitude and timeline of the decline?
    4. Items stored in the cart – Does this mean that checkout has increased? Or they do not checkout at all?
    Reasons-
    1. External – A competitor has these items in a better price or quality, hence users are switching to them. Another possible reason is that the general demand of those items (if they are of a particular category), is dropping.
    2. Internal – Our delivery time. item price and quality are not upto the customers’ expectations.
    3. Internal – The path to checkout, till adding items to the cart, is not too clear to customers. Some UI related issue.

    Machine Learning Concepts
    2. Correlation, simply explained, shows the strength and direction of the relation between two numerical variables. For example, if the correlation between number of hours studied and marks scored is 0.8, it means that the more hours studied. more will be the marks scored (positive correlation).

Leave a reply