Zinnov Management Consulting Analyst Interview Questions and Answers

It was a 1 hour test. It consists of two sections (i) 8 ques were of Business case studies (ii) 12 ques were of quantitative aptitude.

Q1. What is the difference between where and having clause ?
Ans. 
Where clause is used to filter rows before grouping, while having clause is used to filter groups after grouping.
• Where clause is used with SELECT, UPDATE, DELETE statements to filter rows based on a condition.

• Having clause is used with GROUP BY statement to filter groups based on a condition.

• Where clause is applied before grouping, while having clause is applied after grouping.

• Example: SELECT * FROM table_name WHERE co...read more
Answered by AI
Add your answer
Q2. One ques was a guesstimate problem.
Add your answer

Q1. Self Introduction.
Add your answer
Q2. Business case problem which was to be solved in 15 minutes.
Add your answer

Q1. About yourself and Internship Experience
Add your answer
Q2. Guesstimate on what is prominent in your CV
Ans. 
My experience in financial analysis and data interpretation stands out in my CV.
• Extensive experience in financial analysis

• Strong skills in data interpretation and modeling

• Proven track record of making data-driven recommendations

• Proficiency in financial software and tools

• Completed projects that involved complex financial modeling
Answered by AI
Add your answer

Q1. What are the tools you used
Ans. 
I have used a variety of tools including Excel, SQL, Tableau, Python, and Power BI.
• Excel

• SQL

• Tableau

• Python

• Power BI
Answered by AI
Add your answer
Q2. Power Apps used for reporting and automation
Ans. 
Power Apps can be used for creating custom reporting and automating business processes.
• Power Apps can connect to various data sources to pull in data for reporting purposes.

• Users can create custom dashboards and reports using Power Apps to visualize data.

• Automation can be achieved by creating workflows and processes within Power Apps.

• Examples: Creating a Power App to track sales leads and generate reports, automating a
Answered by AI
Add your answer

Easy to medium level

Q1. Everything related to all the processes followed in a ML project like qs related to outliers, feature engg, l1, l2 regularization, multicollinearity and its detection, overfitting, cross validation and its...read more
Add your answer

Q1. Qs related to my resumes and business related qs
Add your answer

Q1. This was with the director there were two case studies he gave to solve
Add your answer

Q1. Basic behavioural qs
Add your answer

It was a altitude test.

Q1. It was a technical inyerview.
Add your answer

Q1. This was 2nd thechnical interview.
Add your answer

Q1. Final hr round. Job relayed discussion
Add your answer

1 hr long test consisting english, quant and reasoning

We had to write some key pointers on a given topic and speak on that for 5 minutes

Q1. Resume Drilling, Questions based on internships and projects.
Add your answer

Q1. Overall Experience Project Controls Basics Risk Management Basics
Add your answer
Q2. Describe how your daily work to do list looks like
Ans. 
My daily work to do list includes prioritizing tasks, setting deadlines, and tracking progress.
• I start by reviewing my tasks for the day and prioritizing them based on deadlines and importance.

• I set specific deadlines for each task to ensure timely completion.

• I track my progress throughout the day and make adjustments to my schedule as needed.

• I also make sure to allocate time for unexpected tasks or emergencies that ma
Answered by AI
Add your answer

Q1. Detailed discussion on handled projects in past company Project Management Scheduling concepts risk management and
Add your answer

Q1. Technical question on planning and risk management
Add your answer
Q2. Quantitative and Qualitative cost and schedule risk management and controls ~ process
Add your answer