AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
KPMG India Analytics Consultant Interview Questions and Answers
KPMG India Analytics Consultant Interview Experiences
1 interview found
Anonymous
Selected
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Projects completed in past company
- Ans.
I have completed various projects in my past company, ranging from data analysis to predictive modeling.
Developed predictive models to forecast sales trends
Conducted data analysis to identify key insights for business strategy
Implemented data visualization tools to communicate findings to stakeholders
- Q2. Sap CDS views annotations
(2 Questions)
- Q1. Projects discussion
- Q2. End to End development process
- Ans.
End to end development process involves planning, designing, implementing, testing, and deploying a solution.
Planning: Define project scope, objectives, and requirements.
Designing: Create a detailed design based on the requirements.
Implementing: Develop the solution using appropriate technologies.
Testing: Conduct thorough testing to ensure the solution meets requirements.
Deploying: Roll out the solution to users and pr
Interview Preparation Tips
- SAP BW
- Sap sac
- CDS views
Skills evaluated in this interview
Interview questions from similar companies
(1 Question)
- Q1. What is regression anlysis
- Ans.
Regression analysis is a statistical method used to establish a relationship between a dependent variable and one or more independent variables.
It helps in predicting the value of the dependent variable based on the values of the independent variables.
It is used to identify the strength and direction of the relationship between variables.
It can be used for both linear and non-linear relationships.
Examples include predi...
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
Technical round asking position related questions
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Nov 2019. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What kind of projects you have completed?
- Q2. How handy you are on the tool?
- Ans.
I am quite handy with tools and have experience using various types of equipment.
I have experience using power tools such as drills, saws, and sanders
I am skilled in using hand tools such as hammers, screwdrivers, and wrenches
I have experience with measuring and cutting materials accurately
I am able to troubleshoot and fix common household problems such as leaky faucets or broken appliances
- Q3. How would you rate yourself in that particular tool out of 5?
- Ans.
I would rate myself 4 out of 5 in that particular tool.
I have extensive experience using the tool in various projects.
I have received positive feedback from colleagues and clients on my proficiency in the tool.
I am confident in my ability to troubleshoot and solve problems using the tool.
However, there may be some advanced features of the tool that I am not yet familiar with.
Overall, I believe I am highly skilled in us
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Be prepared with coding for every concept you have learnt. Be ready to answer regarding exceptions and errors we face generally as a developer.
I applied via Recruitment Consultant and was interviewed before Jan 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Accounting entries Questions around your previous job.
Interview Preparation Tips
Gautam Bansal
Interview Questionnaire
5 Questions
- Q1. Your client is a fruits and vegetables retailer who is facing inventory management issues
- Ans.
Suggest inventory management solutions for a fruits and vegetables retailer.
Analyze sales data to determine popular items and adjust inventory levels accordingly
Implement a first-in, first-out (FIFO) system to ensure freshness of produce
Use technology such as barcode scanning and automated ordering to streamline inventory management
Consider partnering with local farmers to reduce transportation costs and ensure fresh p...
- Q2. Brief Introduction
- Q3. Why consulting?
- Ans.
Consulting offers a dynamic and challenging work environment that allows me to apply my problem-solving skills and work with a variety of clients.
Consulting provides exposure to diverse industries and business models
It offers the opportunity to work with a variety of clients and teams
Consulting requires critical thinking and problem-solving skills
It offers a dynamic and challenging work environment
Consulting provides o...
- Q4. You must be having a busy day. How many interviews are you through with?
- Ans.
I have completed X number of interviews so far today.
I have completed 5 interviews today.
I have been through 7 interviews today.
I have completed 3 interviews and have 2 more scheduled for later today.
- Q5. A 20-25 slide PPT. The client is a Dairy farming corp. based out of Western Europe. Its current market is almost saturated. The client wants to expand its existing operations. It has several markets wit...
- Ans.
Evaluate prospects for expansion of a saturated Dairy farming corp. based in Western Europe with several markets under consideration.
Analyze the potential demand for dairy products in the new markets
Assess the competition in the new markets
Evaluate the feasibility of production and distribution in the new markets
Consider the regulatory environment in the new markets
Develop a comprehensive marketing strategy for the new
Interview Preparation Tips
Experience: Identified that the problem could either be surplus or wastage. Understood the inventory procurement and management system. Took a sample fruit for a given week and proceeded with inventory optimization. Developed alternative inventory plans and selected the best one. Then asked to synthesize.
Round: Case Study Interview
Experience: The interviewer didn’t have my CV. He preferred a brief introduction. Probed about other shortlists and interviews I had.
Then opened an elaborate PPT and walked me through the slides. It was a Dairy Farming Corp. based out of western Europe and we looked at acquisition targets across 4 markets. After 10 minutes of running me through a number of tables and graphs, I was given a minute to think and recommend the best option for the client. I Didn’t lose sight of the bigger picture. Concluded with a recommendation and case synthesis.
General Tips: 1. Respond to the tone of the interviewer.
2. Being composed matters.
Skills:
College Name: IIM Lucknow
Interview Questionnaire
5 Questions
- Q1. Tell me about yourself
- Q2. Tell me a situation where you created an impact and brought about a change
- Q3. A pharma company is in phase-1 trials of a first of it’s kind drug in the world that can cure baldness permanently. Should it go ahead and sell this formula and rights to a potential buyer and if yes,...
- Q4. The client is a motorcycle manufacturer from India, wanting to sell motorcycles in Nigeria. For simplicity we will talk in INR terms. The motorcycle market of Nigeria is dominated by 3-4 Chinese manuf...
- Q5. The case was a no quantitative one. It was about a private bank which has recently got 50 branch opening licences from RBI. How to decide where to set up these branches?
Interview Preparation Tips
Experience: Two things in the problem statement set the path for me.
a. “Phase -1 trials”, so phase -2, so phase-3 etc had to be looked into – basically the whole development stage from a drug in a lab to a drug in the marketplace.
b. “for what amount” – clearly this case demanded working with numbers, because it was not just a yes/no question, but also asked an approximate deal price.
Solving the case.
a) I laid out the value chain in development of a drug.
b) The interviewer on prodding gave me costs involved in the phased clinical trials and their probabilities of success.
c) CATCH: Phase 3 trials success of failures probability does not affect the overall outcome in expenditure, as even if it is a failure, you have spent the money
d) So I have an approximate numbers on cost in different scenarios.
e) Now, I tried to estimate the potential revenue that can be earned from this drug. The interviewer gave the selling price of the drug has been fixed at USD1000. So now its more of a question of market sizing.
f) Since the company is a global pharma giant, it would be selling all over the world.
g) The problem was now reduced to finding the number of potential male bald customers worldwide ready to shell out USD1000 for a cure.
h) The math worked out that there was no way to make money from this drug (It took a little bit of guts to state this conclusion to the interviewer), and the company abandon this project. Or better still, if somebody is ready to buy the right, just sell it for any amount above the costs you have incurred so far.
Round: Case Study Interview
Experience: First I tried to understand the Nigerian motorcycle market. Also, I tried to understand if there was any possibility of the Indian maker to sell cheap – that possibility was ruled out. So, if cost leadership does not work, product differentiation will. How could we then differentiate our product?
a) CATCH: As it turned out in the course of our discussion, the motorcycles were used as taxis
b) The drivers owned the motorcycles and plied pillions around the city for a fee.
c) I worked out the math for these chinese motorcycles -buying cost, maintenance, life, mileage, etc.
d) If the Indian client could beat that number, we could have a winner - the buying cost was high, but we were better on mileage, on life (3 years vs 2 years for the chinese product) and on maintenance. Still the number was not favourable.
e) Next came the idea, that if we could not reduce the cost for the drivers, can we improve the revenue. An idea that I blurted out, but which turned out to be the one the interviewer was looking for – was to have a longer seat so that a total of three people could ride the motorcycle comfortably.
f) Now the numbers started making sense. Also note that the previous numbers would have changed, because the mileage with 3 people on board will be less than 2 ppl onboard. Also, the amount individual customers are ready to shell out for a shared taxi will be lesser than for a private taxi. All these changes accounted for, the numbers still looked positive.
g) So a go ahead was declared.
h) Now came the second part, given that we decide to enter Nigeria – how do we position ourselves as a brand and convince the locals to tru out our new expensive product –the benefits of which can only be ascertained after a period of one or two years i) The answer came in renting out these bikes to the drivers on a trial basis, and let them appreciate our better bikes and let word of mouth do the rest.
General Tips: a). Be calm, but be enthusiastic in the interview. Enthusiasm shows.
b). Make the interview a two way process. Let the interviewer help you solve the problem. He will drop hints. LISTEN to them.
Skills:
College Name: IIM Lucknow
Interview Questionnaire
6 Questions
- Q1. Introduction
- Q2. General HR
- Q3. Case
- Q4. Extensive HR
- Q5. Small case
- Q6. A tractor manufacturing company’s share is declining. Company Description, Manufacturing Operations, and Revenue Split – by product and geography. The company had 4 tractor models (different hp powers)
- Ans.
The tractor manufacturing company's declining share is due to lack of product diversification and limited market reach.
The company needs to expand its product line to cater to different customer needs.
The company should explore new markets and increase its presence in existing ones.
The company can consider partnerships or collaborations to enhance its manufacturing capabilities.
The company should focus on improving its...
Interview Preparation Tips
Experience: Discussed about the various possibilities of the revenues decline –any particular geography, product or channel. There was a particular region where the sales were declining. The sales in the region primarily consisted of 2 tractor models – 35 and 45 hp.
Tried to approach the problem by dividing the issue areas between Internal and External.
Internal – Company related issues related to 4Ps. External – Competition, Consumer Behaving Pattern or External Environment overall (PESTLE).
The prices of the product w.r.t to competitors was at par. However, the maintenance costs was higher as compared to competitors and hence the sales were going down.
Solution:
Proposed a solution of providing extended warranty. Also the excess costs incurred by the company could be recovered by increasing costs of the other 2 tractors (as its market price was slightly lower than its competitors) compromise on the profits.
General Tips: Just be comprehensive. It does no matter if reach the solution or not. Just be exhaustive and have a structured approach.
Skills:
College Name: IIM Lucknow
Interview Questionnaire
4 Questions
- Q1. Why consulting?
- Ans.
Consulting offers diverse challenges and opportunities to work with different clients and industries.
Consulting provides exposure to various industries and clients
Offers diverse challenges and opportunities for growth
Allows for continuous learning and development
Provides a chance to make a significant impact on clients' businesses
- Q2. Why BCG?
- Ans.
BCG is a top-tier consulting firm with a reputation for excellence and a commitment to making a positive impact.
BCG's focus on innovation and problem-solving aligns with my own values and interests.
I am impressed by BCG's track record of delivering impactful solutions to clients across industries.
BCG's collaborative and supportive culture is a great fit for my working style and career goals.
- Q3. Case on market entry for a Mobile Repairing centre (the authorized repair centre for a company)
- Ans.
Market entry for authorized mobile repairing centre
Conduct market research to identify potential customers and competitors
Develop a strong brand image and marketing strategy
Establish partnerships with mobile phone manufacturers for authorized repairs
Offer competitive pricing and quality services
Train and hire skilled technicians
Provide excellent customer service to build a loyal customer base
- Q4. Case on Profitability – Tractor manufacturing company. My profits are declining. On further questioning, I found out that the company dealt in 3 types of tractors. Followed the standard approach and f...
Interview Preparation Tips
Experience: If I am an authorized service centre for a mobile company and I want to set up my own mobile service centre to service handsets of products whose warranties have expired, how should I enter the market.
He wasn’t convinced with my why consult answer and coz of that I screwed up my case too. Also, it was the 1st interview for the day and screwed up coz of nervousness. Didn’t ask qualifying questions. Structure was all over the place.
Round: Case Study Interview
Experience: Qualifying questions were perfect. Applied the correct approach. Detected the problem in the after sales service. Perfect recommendations.
Skills:
College Name: IIM Lucknow
KPMG India Interview FAQs
Tell us how to improve this page.
KPMG India Interviews By Designations
- KPMG India Consultant Interview Questions
- KPMG India Analyst Interview Questions
- KPMG India Associate Consultant Interview Questions
- KPMG India Assistant Manager Interview Questions
- KPMG India Associate Interview Questions
- KPMG India Senior Consultant Interview Questions
- KPMG India Audit Associate Interview Questions
- KPMG India Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Analytics Manager Interview Questions
- Decision Analytics Associate Interview Questions
- Senior Analytics Consultant Interview Questions
- Data Scientist Interview Questions
- Analytics Specialist Interview Questions
- Analytics Executive Interview Questions
- Senior Manager Analytics Interview Questions
- Senior Data Analyst Interview Questions
- Show more
KPMG India Analytics Consultant Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
KPMG India Analytics Consultant Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
7.9k
salaries
|  ₹6.6 L/yr - ₹26.5 L/yr |
|
Assistant Manager
7.2k
salaries
| ₹10.5 L/yr - ₹32.5 L/yr |
|
Associate Consultant
4.7k
salaries
| ₹4.5 L/yr - ₹16 L/yr |
|
Analyst
3.6k
salaries
| ₹1 L/yr - ₹9 L/yr |
|
Manager
2.9k
salaries
| ₹15.5 L/yr - ₹46 L/yr |
Cognizant
PwC
Capgemini
- Home >
- Interviews >
- KPMG India Interview Questions >
- KPMG India Analytics Consultant Interview Questions
