Technopak Advisors Senior Consultant Interview Questions and Answers

Q1. Alerts in power BI dashboards
Add your answer
Q2. What is the difference in 20 distinct and 1 unique value?
Add your answer

Q1. Projects in previous role?
Add your answer
Q2. Challenges in previous role?
Add your answer

Q1. General informations
Add your answer

Q1. Department discussion
Add your answer

Q1. Salary expectations, ok with travelling within city
Add your answer
Q2. Notice period requirement
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. The interviewer asked about my exposure to the retail industry based on my workex.
Add your answer
Q3. What motivates you to work?
Add your answer
Q4. Why do you want to join A&M?
Add your answer

Suppose you are a consultant at A&M and your client is the Mumbai International Airport Authority. The CEO has approached you to suggest ways to increase earnings per passenger.
[Please note that I stands for Interviewer and C stands for Candidate]

C: I would like to start by splitting the revenue into aero and non-aero revenue. Would you like me to focus on any particular revenue stream first?

I: Yes, let us focus on non-aero revenue sources only.

C: I would like to map the customer journey here and identify key factors impacting the non-aero revenue. Passenger Mix, Placement of Retail outlets and Retail Mix are the three critical parameters.

At this point, data for Retail spend per passenger, Retail Area and Passenger Mix (International: Domestic) was provided.

C: Calculated the current numbers and what incremental revenue would the airport be able to generate through changes at various steps.

I: Could you please go ahead and compare these parameters with four major airports - Delhi, Hyderabad, Chennai, and Bangalore?

C: Differentiated the airports based on available data. Provided final recommendations for increasing the revenue.

I: Assume that there is an option to place a Subway or an Apparel shop near the boarding gates. What would you recommend?

C: Calculated the monthly revenue for both options using footfalls and average bill value, splitting into the peak, non-peak, non-operational hours and came up with a final recommendation.

Our client is a PE firm, looking to invest in a mid-market player in the Cement industry. How would you form a view on its pricing growth?
[Please note that I stands for Interviewer and C stands for Candidate]

C: Before I move on to pricing, I would like to understand a bit more about the cement company, its customers and current competition in the market.

I: Interviewer provides details of the company.

C: I now have a fair understanding of the company and would now like to move on to the macroeconomic factors impacting the industry and then would like to understand the cement industry scenario in terms of buyer, suppliers, and competition.

I: Interviewer provides details on the questions asked. How do you now approach the pricing growth?

C: Discussed the three main ways of pricing - Cost, Competition and Value based.

I: Talked about relevant concepts including asset turnover and RoI.

Q1. Estimate the number of pressure cookers sold in a year in India.
Ans. 
Estimating the number of pressure cookers sold in a year in India.
• Research the population of India and estimate the average household size.

• Determine the percentage of households that own a pressure cooker.

• Find the average lifespan of a pressure cooker and estimate the replacement rate.

• Consider factors like urbanization, income levels, and cultural preferences.

• Consult industry reports and market research data for more a
Answered by AI
View 1 more answer
Q2. List down the factors to be considered while setting up a hospital on a highway.
Add your answer
Q3. How many cricket balls are used in an IPL series?
Ans. 
The number of cricket balls used in an IPL series varies depending on factors such as match duration, weather conditions, and ball condition.
• The number of cricket balls used in an IPL series can range from a few hundred to over a thousand.

• Each match in an IPL series typically uses multiple balls due to wear and tear during the game.

• The number of balls used can also be affected by factors such as rain interruptions or b...read more
Answered by AI
View 1 more answer

Q1. About past projects in the sector
Add your answer
Q2. Scenario analysis without giving proper context
Add your answer

Q1. Previous experience Market research meaning Primary and Secondary Research difference Distributor search key parameters Estimation
Add your answer

Market research estimation ppt

Q1. Why you want to change job? What was your previous job experience was?
Add your answer
Q2. Job switch reasons Traveling
Add your answer

Q1. Basic Power BI related questions
Add your answer
Q2. Why Power BI is better
Ans. 
Power BI offers powerful data visualization, easy integration with other Microsoft products, and robust sharing capabilities.
• Power BI provides interactive and customizable data visualizations for better insights.

• It seamlessly integrates with other Microsoft products like Excel, SharePoint, and Teams.

• Power BI allows for easy sharing and collaboration on reports and dashboards.

• It offers advanced analytics capabilities th...read more
Answered by AI
Add your answer

Q1. Why do you want to join us?
Add your answer