Box8 Business Analyst Interview Questions
Box8 Business Analyst Interview Questions
Company Name – Box8
Position – Business Analyst
Salary – 12 – 16 LPA depending on experience and last compensation
Difficulty Level – Hard
How to apply – Mostly Referrals and uploading resumes on their website
Number of rounds – It ranges from 4 (depending on the team you are interviewing for)
Job Location – Bangalore
Box8 Business Analyst Interview Questions
There are a few companies where the work is good and also you get a good amount of business exposure to understand the way astart-up works, in most of the business analytics jobs the questions are asked around simple SQL and Python, but at Box8 our mentor experienced some difficult and not so normally asked questions. Let’s start with the complete interview experience
In total there were 4 rounds, the first two rounds were purely technical, the third was based on a case study, and the fourth one was mostly around managerial questions
Round 1 – SQL Questions
Round 1 started with a brief about me and about the interviewer. One of my projects which was based out on data engineering was discussed in brief. Then the questions on SQL were asked, it started with basic join questions and later shifted to Regular Expression. The questions asked on Regular Expression were quite good, we have put similar question links where these are mostly solved, Try to go through all the questions and attempt the questions in the comment section.
Split Paragraph – https://thedatamonk.com/question/box8-write-a-regular-expression-to-split-a-paragraph-every-time-it-finds-an-exclamation-mark/
Regular Expression Output – https://thedatamonk.com/question/box8-find-the-output-of-the-following-code/
Tokenization – https://thedatamonk.com/question/box8-what-is-tokenization-and-what-are-the-important-nltk-tokenizer/
RegEx to match commas and spaces – https://thedatamonk.com/question/box8-how-to-write-a-regex-to-match-spaces-or-commas/
Ranking in SQL – https://thedatamonk.com/question/box8-ranking-in-sql/
Processing time in SQL – https://thedatamonk.com/question/box8-sql-query/
Topic Modeling in NLP – https://thedatamonk.com/question/box8-what-is-topic-modeling/
Bag of Words – https://thedatamonk.com/question/box8-what-is-bag-of-words/
RegEx in SQL – https://thedatamonk.com/question/box8-regular-expression-in-sql/
RegEx in SQL – https://thedatamonk.com/question/box8-sql-query-on-regular-expression/
Round 2 – Python and SQL
My feedback was decent and was called for the second round of interviews. It was with a Lead Business Analyst. It started with an introduction and later shifted on to the type of projects which were mentioned in my resume.
My understanding of the Data Pipeline was tested where I was asked to draw the complete data pipeline for my current organization. We already have a good detailed blog on the data pipeline, do go through it if you have worked closely with the data engineering team.
On the Python front, I was asked about mutable, immutable concepts, about the OS module (it’s very important to understand the OS module in Python, do explore it either on Google or Here) and some very basic questions on Machine Learning like, what is the p-value, correlation, cross-validation. Only the concepts were asked and not the detailed syntax.
In SQL again some regex questions were asked which I have provided the link above, do go through these.
Round 3 – Case Study
There was only one question which was discussed for 1 hour. The case study was “If you have a restaurant which sells only Biryani and somedays you get sold out, somedays you are left with 50 kgs of Biryani, then how do you optimize this process so that the loss is minimized”
Think and comment your approach below. There are multiple things that we discussed like getting the busiest hour, taking a rolling average of 7 days, and seasonality of the month. Keep a check on the sold plates in the interim period, etc. Do comment your approach below for evaluation
Round 4 – Managerial Round
I guess all three rounds of mine were good, I was asked questions on my family background, education, whether I am a customer of Box8 or not, etc.
Everything was wrapped up in 4-5 days, Offer letter was released within 7 days with a good 70% hike 🙂
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 which might be very useful for your preparation
The Data Monk Youtube channel – Here you will get only those videos that are asked in interviews for Data Analysts, Data Scientists, Machine Learning Engineers, Business Intelligence Engineers, Analytics Manager, 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
