Add office photos
Filter interviews by
Zinnov Management Consulting Data Analyst Interview Questions and Answers
Zinnov Management Consulting Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed before Feb 2023. There were 2 interview rounds.
(1 Question)
- Q1. About skills in jd
Basic python coding questions
Top trending discussions
Interview questions from similar companies
tejas jain
I applied via Newspaper Ad and was interviewed in Aug 2024. There were 3 interview rounds.
Three sections are there 1) Aptitude Test 2) SQL 3) DSA
(2 Questions)
- Q1. What is DSA , sorting , difference between array and linked list
- Ans.
DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.
DSA stands for Data Structures and Algorithms
Sorting is the process of arranging data in a particular order
Arra...
- Q2. Written a SQL query
(2 Questions)
- Q1. Coding question like add numbers
- Q2. Experience on your project
- Ans.
I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.
Developed predictive models to forecast customer behavior and optimize marketing strategies
Conducted market research to identify trends and opportunities for growth
Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns
Skills evaluated in this interview
(2 Questions)
- Q1. Power BI Difference between ALL() and ALLSELECTED()
- Ans.
ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.
ALL() removes all filters from the specified column or table.
ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.
Example: ALL('Table') would remove all filters on the 'Table' in the query context.
Example: ALLSELECTED('Column') would remove filte...
- Q2. Excel Difference between COUNT() and COUNTA()
- Ans.
COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.
COUNT() counts only cells with numerical values.
COUNTA() counts all non-empty cells, including text and errors.
Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.
(2 Questions)
- Q1. Resume based questions like explain the projects that you have done.
- Q2. Sample dataset questions
Skills evaluated in this interview
Selected
I applied via campus placement at Lady Shri Ram College for Women, Delhi
Basic English, Quants and Statistics
Easy, relevant to pandemic
(1 Question)
- Q1. Python, Tableau, SQL, Stats, ML, all questions easy to medium level
(2 Questions)
- Q1. Behavioural Questions
- Q2. Statistics Case Study
Interview Preparation Tips
I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.
(3 Questions)
- Q1. Basics of power bi and sql
- Q2. What are joins and types of join
- Ans.
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FULL JOIN...
- Q3. How to add date table in power bi
- Ans.
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
Create a new table in Power BI with a list of dates
Add columns for day, month, year, etc. for additional analysis
Establish relationships between the date table and other tables in the data model
(4 Questions)
- Q1. Sql scenario based question on joins
- Q2. Window function questions
- Q3. Performance tuning
- Q4. Power bi dax question
Skills evaluated in this interview
Selected
(1 Question)
- Q1. How good are you with numbers
(1 Question)
- Q1. Vlookup, pivot table, sumif, average, graphs
(1 Question)
- Q1. Do you know the role and responsibility of this position
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.
Basic aptitude questions liek tiem distance, percentage , ratio, work and hour
Excel, Numpy, Pandas, basic ML
Case study talking about how to optimise the supply chain using data analytics
(1 Question)
- Q1. Hard DP level DSA question
(1 Question)
- Q1. What is the number of tourist per day in jaipur
- Ans.
The number of tourists per day in Jaipur varies depending on the season and events happening in the city.
Tourist numbers fluctuate based on time of year (peak season vs off-peak season)
Events like festivals or cultural events can attract more tourists
Historical sites like Amer Fort and Hawa Mahal are popular attractions
Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions
Selected
I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.
(1 Question)
- Q1. Almost everything on Power BI
(1 Question)
- Q1. Behavioral skills
Zinnov Management Consulting Interview FAQs
Tell us how to improve this page.
Zinnov Management Consulting Interviews By Designations
- Zinnov Management Consulting Project Lead Interview Questions
- Zinnov Management Consulting Research Executive Interview Questions
- Zinnov Management Consulting Market Research Intern Interview Questions
- Zinnov Management Consulting Analyst Interview Questions
- Zinnov Management Consulting Associate Research Executive Interview Questions
- Zinnov Management Consulting Consultant Interview Questions
- Zinnov Management Consulting Data Analyst Interview Questions
- Zinnov Management Consulting Engagement Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Zinnov Management Consulting Data Analyst Interview Process
based on 3 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Zinnov Management Consulting Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Project Lead
110
salaries
|  ₹12 L/yr - ₹26 L/yr |
|
Associate Research Executive
103
salaries
| ₹0.9 L/yr - ₹2.5 L/yr |
|
Research Executive
86
salaries
| ₹1.5 L/yr - ₹3.7 L/yr |
|
Consultant
86
salaries
| ₹7 L/yr - ₹16.2 L/yr |
|
Engagement Manager
50
salaries
| ₹26 L/yr - ₹51.7 L/yr |
McKinsey & Company
BCG
Bain & Company
KPMG India
- Home >
- Interviews >
- Zinnov Management Consulting Interview Questions >
- Zinnov Management Consulting Data Analyst Interview Questions
