Add office photos
i
Porter
Compare
Filter interviews by
Porter Business Analyst Interview Questions and Answers
Porter Business Analyst Interview Experiences
3 interviews found
Anonymous
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Case study questions based on Logistics & Porter business.
- Q2. More Case study & porter business questions
(2 Questions)
- Q1. Some medium SQL Queries
- Q2. Some medium python codes
Sql, python, stats, dashboarding
Guesstimates, Optimisation, RCA
Interview Preparation Tips
I applied via Instahyre and was interviewed before Dec 2020. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Write SQL queries
- Ans.
SQL queries for Business Analyst role
SELECT * FROM table_name;
SELECT column_name FROM table_name WHERE condition;
SELECT COUNT(*) FROM table_name;
SELECT AVG(column_name) FROM table_name;
SELECT MAX(column_name) FROM table_name;
SELECT MIN(column_name) FROM table_name;
SELECT column_name1, column_name2 FROM table_name1 JOIN table_name2 ON table_name1.column_name = table_name2.column_name;
SELECT column_name1, COUNT(column_na
- Q2. Data manipulation
- Q3. Coding round
- Q4. Problem solving round
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
(1 Question)
- Q1. They give you some questions and you have to write sql queries for them
(1 Question)
- Q1. You are given case study and come sql questions based on that
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.
(2 Questions)
- Q1. Introduction and explain any one of the projects plus what was the analytics you used
- Ans.
Implemented a project to optimize marketing campaigns using predictive analytics
Developed a predictive model to identify the most effective marketing channels
Utilized data from past campaigns to train the model
Used techniques such as regression analysis and decision trees to analyze the data
Generated insights on customer behavior and preferences to improve campaign targeting
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Interview Preparation Tips
(1 Question)
- Q1. SQL based questions were asked on Group by, Window functions
The interview was good mostly on SQL, and Python
(1 Question)
- Q1. Sql questions on advanced concepts
(1 Question)
- Q1. Previous experience and business questions
Selected
(3 Questions)
- Q1. Business use cases on logistics & last mile delivery??
- Ans.
Business use cases on logistics & last mile delivery
Optimizing delivery routes to reduce time and cost
Implementing real-time tracking systems for better visibility
Using predictive analytics to forecast demand and optimize inventory
Implementing automated sorting and packaging systems to improve efficiency
Integrating with third-party delivery services to expand reach
Implementing customer feedback systems to improve servi
- Q2. Basic excel functions
- Q3. Sumifs, pivot tables, Vlookup etc.
vivek duggal
(2 Questions)
- Q1. Salary discussion
- Q2. Expected salary vs what they can offer
govind goel
I applied via Internshala and was interviewed in Sep 2023. There were 3 interview rounds.
Medium difficultty on pandas SQL
(1 Question)
- Q1. Coding interview python pandas medium difficulty
- Ans. Solved it and had to discuss with manager
Interview Preparation Tips
- Python
Porter Interview FAQs
Tell us how to improve this page.
Porter Interviews By Designations
- Porter Business Associate Interview Questions
- Porter Software Development Engineer II Interview Questions
- Porter Business Analyst Interview Questions
- Porter Business Executive Interview Questions
- Porter Software Developer Interview Questions
- Porter Associate Interview Questions
- Porter Customer Care Executive Interview Questions
- Porter Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Manager Interview Questions
- Business Executive Interview Questions
- Show more
People are getting interviews through
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Porter Business Analyst Reviews and Ratings
based on 5 reviews
Rating in categories
|
Business Associate
268
salaries
|  ₹2.2 L/yr - ₹4.3 L/yr |
|
Business Executive
201
salaries
| ₹1.9 L/yr - ₹3.5 L/yr |
|
Assistant Manager
90
salaries
| ₹3.8 L/yr - ₹13.2 L/yr |
|
Senior Business Associate
78
salaries
| ₹3.4 L/yr - ₹6.3 L/yr |
|
Senior Manager
71
salaries
| ₹14 L/yr - ₹24 L/yr |
Dunzo
Flipkart
Amazon
Snapdeal
Calculate your in-hand salary
- Home >
- Interviews >
- Porter Interview Questions >
- Porter Business Analyst Interview Questions
