Box8 Data Analyst Interview Questions

Box8 is an Indian food delivery start-up which is currently functioning in
Mumbai, Pune, Bangalore and Gurugram.

Title –Data Analyst
Experience required – 1-3 years
Number of Rounds – 3

Round 1 – Telephonic SQL and MS Excel Round
The telephonic round was mostly around tricky SQL questions and basic MS Excel questions. The interview lasted for 45 minutes and was focused more on your approach to solving a problem. Following are a few SQL questions asked in this round:-

1. Difference between HAVING and WHERE command.
2. Difference between DENSE_RANK and ROW_NUMBER.
3. Self-join to get the manager name of all the employees.
4. Find the error in the following code or basically optimize the code below to get the full name of all the employees with first name as Amit:

SELECT employee_name
FROM employee
WHERE employee_name LIKE ‘Amit%’

Proposed solution
SELECT employee_name
FROM employee
WHERE lower(employee_name) LIKE ‘amit%’

5. Order of execution of SQL
6. Create a new table ‘Teacher’ with the same as ‘Student’

CREATE table Teacher as SELECT * from STUDENT

7. Show maximum and minimum marks in a student table

SELECT max(marks) from student
UNION
SELECT min(marks) from student

8. Display date in ‘MM-DD-YYYY’ format

SELECT to_date(Date_Column_Name,’MM-DD-YYYY’)
FROM Student

9. Explain VLOOK UP with syntax
10. Explain indexing with example
11. One simple if-else condition problem

Round 2 – Case Study and Guestimate problem

Case Study – How to increase the revenue of

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 nitinkamal132@gmail.com