AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Ernst & Young
Compare
Filter interviews by
Ernst & Young Data Analyst Interview Questions, Process, and Tips for Experienced
Top Ernst & Young Data Analyst Interview Questions and Answers for Experienced
- Q1. Cut Cake in 3 cut to maximum pieces
- Q2. Write the sql query for 2nd highest salary .
- Q3. How we can optimize sql query
Ernst & Young Data Analyst Interview Experiences for Experienced
6 interviews found
Anonymous
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Write the sql query for 2nd highest salary .
- Ans.
Retrieve the second highest salary from a salary table using SQL.
Use the 'DISTINCT' keyword to avoid duplicate salaries.
Utilize 'ORDER BY' to sort salaries in descending order.
Use 'LIMIT' or 'OFFSET' to fetch the second record.
Example SQL: 'SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;'
- Q2. How we can optimize sql query
- Ans.
Optimizing SQL queries improves performance and reduces resource consumption, leading to faster data retrieval.
Use indexes: Create indexes on columns frequently used in WHERE clauses. Example: CREATE INDEX idx_name ON table_name(column_name);
Avoid SELECT *: Specify only the columns you need. Example: SELECT column1, column2 FROM table_name;
Use WHERE clauses: Filter data as early as possible. Example: SELECT column1 FRO...
- Q3. Difference between slicer and filter
- Ans.
Slicers provide a visual way to filter data, while filters apply conditions to limit data in reports or dashboards.
Slicers are visual elements that allow users to select values to filter data interactively.
Filters are typically applied behind the scenes and can be more complex, allowing for multiple conditions.
Example of a slicer: A dropdown menu for selecting a specific region in a sales dashboard.
Example of a filter:...
- Q4. Dax for year over year growth
- Ans.
DAX calculates year-over-year growth by comparing current year values to previous year values using time intelligence functions.
Use the DAX function 'SAMEPERIODLASTYEAR' to reference the same period in the previous year.
Example: 'YoY Growth = (SUM(Sales[Amount]) - CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date]))) / CALCULATE(SUM(Sales[Amount]), SAMEPERIODLASTYEAR(Date[Date]))'
Ensure your date table is mark...
- Q5. Difference types of filters in power BI
- Ans.
Power BI offers various filters to refine data visualizations, including report, page, and visual-level filters.
Report-level filters: Apply to all pages in the report. Example: Filtering out data for a specific region across all visuals.
Page-level filters: Apply to a single page in the report. Example: Showing sales data for a specific product category on one page.
Visual-level filters: Apply to individual visuals. Exam...
Interview Preparation Tips
(2 Questions)
- Q1. Sql intermediate level
- Q2. Power bi intermediate level
(2 Questions)
- Q1. Family background & earning source
- Q2. What you like about EY
Selected
I applied via Approached by Company and was interviewed in Jan 2024. There were 4 interview rounds.
(1 Question)
- Q1. Hr asked me basics details like Role and responsibilities, About overall experience, About notice period, About Current CTC and ectc.
Hr round+ assessment+manager round
(1 Question)
- Q1. They asked about work experience And role & responsibility and apart from that they asked case study Formula from Excel and some questions from power bi and 2 questions from sql
(1 Question)
- Q1. They negotiated salary
Interview Preparation Tips
- Basics Excel and Advance excel
- Power Bi
- SQL
- Python
What people are saying about Ernst & Young
(3 Questions)
- Q1. Sql and power bi
- Q2. Join, window functions
- Q3. Data modeling, dax
Ernst & Young interview questions for designations
It was good, practice well to do well
(2 Questions)
- Q1. What is your experience?
- Q2. What is your salary expectation?
Get interview-ready with Top Ernst & Young Interview Questions
I applied via Walk-in and was interviewed in Apr 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Cut Cake in 3 cut to maximum pieces
- Q2. Basic SQL queries
Interview Preparation Tips
You can be absorbed to much related profile of your interests.
They only check how better you represent yourself and your problem solving approach.
Data Analyst Jobs at Ernst & Young
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Oct 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Write a query where all the customer name start with A
- Ans.
Query to retrieve all customer names starting with A.
Use the SELECT statement to retrieve customer names.
Use the LIKE operator with the pattern 'A%' to match names starting with A.
Specify the table and column name where the customer names are stored.
Example: SELECT customer_name FROM customers WHERE customer_name LIKE 'A%';
- Q2. Write a query where we'll get state wise sales summary report. Actually in this query we have to join multiple table and finding the rank .
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview before Jan 2021.
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
This was an online aptitude round on the Talview platform which we can give from our Home. To attempt this test, we have been given a window of 12-24 hours. It was a proctored online test. The round consisted of 60 aptitude questions in 60 minutes of time without any negative marking. The aptitude test consisted of various questions of Logical Reasoning, Mental Ability, Data Interpretation Questions, Numerical Reasoning.
- Q1.
Matrix Transpose Problem Statement
Given a matrix
MAT, your task is to return the transpose of the matrix. The transpose of a matrix is obtained by converting rows into columns and vice versa. Specificall... - Ans.
Transpose a given matrix by switching rows and columns.
Iterate through the matrix and swap elements at [i][j] with [j][i].
Create a new matrix to store the transposed values.
Ensure the dimensions of the transposed matrix are reversed from the original matrix.
Round duration - 30 minutes
Round difficulty - Medium
This was a video interview round taken immediately after the Aptitude test, it was a proctored round on Talview platform. This round consisted of 8 questions, we have to answer each question in the span of 3 mins and 10 secs were given for reading the question, our audio and video was being recorded while answering those questions. Our soft skills were being judged in this round. The questions basically consisted of HR questions and Guesstimates
Round duration - 120 minutes
Round difficulty - Hard
This round was the case study round, in this round, we were provided a case study which we had to solve in 1 hour using pen and paper and had to share the answers of the case study questions in a PDF format to the HR, the questions were related to market share, advertisement strategies, and can be easily solved using basic mathematics. After this, there was be a one-to-one interview on Zoom Platform in which the interviewer will ask you to describe your approach for every question you have solved in the case study, they will not ask for the exact answer, all they ask is about your approach that you have used to solve a particular problem and the way you explain it. They may or may not ask some guesstimates or puzzles as well in this round. The interviewer was very friendly and he gave me hints as well if I was stuck somewhere.
(1 Question)
Round duration - 60 minutes
Round difficulty - Hard
The next round was the Behavioral interview round, in this round, the interviewer asked me about my projects and some guesstimates or puzzles. This round was for 1 hour. The interviewer was very friendly and helpful, she helped me if I was stuck somewhere, she kept me calm during the interview process.
- Q1. How many people do you estimate watched Ramayana/Mahabharat during the first month of the Covid lockdown in 2020?
(1 Question)
Round duration - 40 minutes
Round difficulty - Hard
The fit round was my final interview round, in this, you will meet the manager/Principal from the company. They will basically check whether you are fit for the organization. They ask about the projects I have done in college/internships. Some basic questions like what are your strengths and weaknesses, why do you want to join the company and some guesstimates or puzzles as well.
On-campus, the behavioral and fit interview rounds were combined into one.
This round was of 40 minutes and the interview was taken on Zoom, the interviewer was helpful and sweet.
- Q1. How many pizzas are sold in one day in Pune?
- Ans.
The number of pizzas sold in Pune in one day varies depending on factors like day of the week, weather, events, etc.
The number of pizzas sold in Pune can range from hundreds to thousands in a day.
Factors like day of the week (weekend vs weekday), weather (rainy vs sunny), events (festivals, holidays) can impact the sales.
Popular pizza outlets in Pune like Domino's, Pizza Hut, etc. contribute to the overall sales.
Data f...
Interview Preparation Tips
Tip 1 : Prepare well for guesstimates and puzzles.
Tip 2 : Practice Data Interpretation Questions.
Tip 3 : Be well versed with your projects.
Tip 1 : The resume should be very precise and concise
Tip 2 : Do not add such skills in your resume in which you're not comfortable.
Skills evaluated in this interview
I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.
Interview Preparation Tips
- Procurement
- Marketing
- Career goal
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
Ernst & Young Interview FAQs
Tell us how to improve this page.
Ernst & Young Interviews By Designations
- Ernst & Young Consultant Interview Questions
- Ernst & Young Senior Consultant Interview Questions
- Ernst & Young Analyst Interview Questions
- Ernst & Young Associate Consultant Interview Questions
- Ernst & Young Tax Analyst Interview Questions
- Ernst & Young Manager Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Ernst & Young Advanced Analyst 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
Ernst & Young Data Analyst Interview Process for Experienced
based on 5 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Ernst & Young Data Analyst Reviews and Ratings
based on 77 reviews
Rating in categories
|
Senior Consultant
16.3k
salaries
|  ₹9.1 L/yr - ₹33.3 L/yr |
|
Consultant
12.4k
salaries
| ₹6.5 L/yr - ₹21 L/yr |
|
Manager
7.7k
salaries
| ₹16 L/yr - ₹47 L/yr |
|
Assistant Manager
6.5k
salaries
| ₹9.5 L/yr - ₹29 L/yr |
|
Associate Consultant
4k
salaries
| ₹4.5 L/yr - ₹12 L/yr |
Deloitte
PwC
EY Global Delivery Services ( EY GDS)
Accenture
- Home >
- Interviews >
- Ernst & Young Interview Questions >
- Ernst & Young Data Analyst Interview Questions for Experienced
