i
ZS
Compare
Filter interviews by
ZS Data Analyst Interview Questions and Answers for Experienced
ZS Data Analyst Interview Experiences for Experienced
2 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.
Set of questions on english , aptitude , all are at easy level
Sql basics and some query questions
(2 Questions)
- Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
- Q2. Question on real life scenarios
(2 Questions)
- Q1. Salary expectation
- Q2. When can u join
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
Guesstimates related to different scenario
Aptitude questions to check your critical thinking
Interview questions from similar companies
(2 Questions)
- Q1. Explain all types of joins
- Ans.
Different types of joins in SQL are inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a 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 outer join: Returns rows when there is a match in either table
- Q2. Difference between having and where
- Ans.
The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.
HAVING is used with GROUP BY to filter groups based on aggregate functions results
WHERE is used to filter rows based on conditions
HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY
Example: SELECT department, AVG(salary) FROM employees GROU...
Skills evaluated in this interview
Sohini Bera
(1 Question)
- Q1. Write a code to determine average salary wrt location
- Ans.
Code to calculate average salary based on location
Create a dictionary to store salaries based on location
Calculate average salary for each location using the dictionary
Return the average salaries for each location
(2 Questions)
- Q1. Sql intermediate level
- Q2. Power bi intermediate level
(2 Questions)
- Q1. Family background & earning source
- Q2. What you like about EY
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
I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 2 interview rounds.
60 min of exam and 30 question of apti
(2 Questions)
- Q1. Salary exption and carrer growth
- Q2. Privious organaization
(2 Questions)
- Q1. A little about Alteryx.
- Ans. SQL queries writing -join , like, limit, group by . Alteryx: basic join , transpose, Alteryx scheduler.
- Q2. Sql related queries.
- Ans. Sql queries writing join like group by
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here
(1 Question)
- Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.
Interview Preparation Tips
ZS Interview FAQs
The duration of ZS Data Analyst interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
ZS Interviews By Designations
- ZS Decision Analytics Associate Interview Questions
- ZS Business Technology Associate Interview Questions
- ZS Business Operations Associate Interview Questions
- ZS Business Technology Analyst Interview Questions
- ZS Associate Interview Questions
- ZS Associate Decision Analytics Consultant Interview Questions
- ZS Business Analyst Interview Questions
- ZS Consultant 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
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
ZS Data Analyst Reviews and Ratings
based on 22 reviews
Rating in categories
|
Associate Consultant
2k
salaries
|  ₹9.3 L/yr - ₹26 L/yr |
|
Decision Analytics Associate
1.6k
salaries
| ₹5.5 L/yr - ₹18.2 L/yr |
|
Business Technology Associate
1.1k
salaries
| ₹5.5 L/yr - ₹17.1 L/yr |
|
Associate Decision Analytics Consultant
852
salaries
| ₹10 L/yr - ₹26 L/yr |
|
Consultant
651
salaries
| ₹12 L/yr - ₹37 L/yr |
Wipro
TCS
Infosys
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- ZS Interview Questions >
- ZS Data Analyst Interview Questions for Experienced
