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 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
- 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 - Website – ~2000 completed solved Interview questions in SQL, Python, ML, and Case Study
Link – The Data Monk website - 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 - 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 - 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 [email protected]