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 Senior Data Analyst Interview Questions and Answers
8 Interview questions
There are three types of filters available in Power BI.
Visual level filters
Page level filters
Report level filters
SELECTEDVALUE() is a DAX function used to return the value of a column if it has only one distinct value.
Used in Power BI to retrieve the value of a column if it has only one distinct value
Returns an error if the column has more than one distinct value
Can be used in combination with IF statement to handle errors
Example: SELECTEDVALUE('Table'[Column], 'No value found')
Example: IF(ISBLANK(SELECTEDVALUE('Table'[Colum...
There are four types of connections available in Power BI.
Power BI Desktop Connection
Power BI Service Connection
Power BI Mobile Connection
Power BI Gateway Connection
Power Pivot is available in Power BI Desktop and Power BI Service.
Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.
In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.
In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Source...
What people are saying about Ernst & Young
Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.
Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.
Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.
Direct connection is useful for small datase...
Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.
Incremental refresh is useful for large datasets that take a long time to refresh.
It allows you to refresh only the new or updated data since the last refresh.
You can set up incremental refresh by defining a range of values for a column that represents the refresh window.
For example, yo...
Dependent slicer in Power BI allows filtering of data based on selection in another slicer.
Create two slicers, one for the main category and another for the sub-category.
Add the main category slicer to the report page and select the sub-category slicer.
Go to the Format pane and select the 'Edit interactions' option.
Choose the 'Filter' option for the sub-category slicer.
Now, when a main category is selected, the su...
To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.
Use the Publish to Web feature to generate an embed code that can be shared with external users
Ensure that the report contains only non-sensitive data before using the Publish to Web feature
Alternatively, share the report via email by granting access to the external user's email address
The external user mu...
Ernst & Young Senior Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
I appeared for an interview in Apr 2025, where I was asked the following questions.
- Q1. Tell me about yourself
- Q2. Describe your current project
- Q3. As a data analyst, how do you ensure that the data presented in your dashboard is accurate, and what methods do you use for validation?
I applied via Naukri.com and was interviewed in Apr 2022. There was 1 interview round.
(8 Questions)
- Q1. How many type of conections are available in Power BI?
- Ans.
There are four types of connections available in Power BI.
Power BI Desktop Connection
Power BI Service Connection
Power BI Mobile Connection
Power BI Gateway Connection
- Q2. What is incremental refresh in Power BI?
- Ans.
Incremental refresh is a feature in Power BI that allows you to refresh only a portion of your data instead of the entire dataset.
Incremental refresh is useful for large datasets that take a long time to refresh.
It allows you to refresh only the new or updated data since the last refresh.
You can set up incremental refresh by defining a range of values for a column that represents the refresh window.
For example, you can...
- Q3. Diffrence between direct connection and live connection?
- Ans.
Direct connection is a static connection to a data source, while live connection is a dynamic connection that updates in real-time.
Direct connection requires data to be imported into the analysis tool, while live connection accesses data directly from the source.
Live connection allows for real-time updates and analysis, while direct connection requires manual refreshing.
Direct connection is useful for small datasets or...
- Q4. Where power pivot is available in Power bi?
- Ans.
Power Pivot is available in Power BI Desktop and Power BI Service.
Power Pivot is a data modeling tool in Excel that allows you to create relationships between tables and perform complex calculations.
In Power BI Desktop, you can access Power Pivot by going to the 'Data' tab and selecting 'Manage Relationships'.
In Power BI Service, you can access Power Pivot by going to the 'Settings' menu and selecting 'Data Sources'.
Po...
- Q5. Use of SELECTEDVALUE() fax function?
- Ans.
SELECTEDVALUE() is a DAX function used to return the value of a column if it has only one distinct value.
Used in Power BI to retrieve the value of a column if it has only one distinct value
Returns an error if the column has more than one distinct value
Can be used in combination with IF statement to handle errors
Example: SELECTEDVALUE('Table'[Column], 'No value found')
Example: IF(ISBLANK(SELECTEDVALUE('Table'[Column])),...
- Q6. How can we create a dependent slicer in Power bi?
- Ans.
Dependent slicer in Power BI allows filtering of data based on selection in another slicer.
Create two slicers, one for the main category and another for the sub-category.
Add the main category slicer to the report page and select the sub-category slicer.
Go to the Format pane and select the 'Edit interactions' option.
Choose the 'Filter' option for the sub-category slicer.
Now, when a main category is selected, the sub-cat...
- Q7. How many type of filters are available in Power bi?
- Ans.
There are three types of filters available in Power BI.
Visual level filters
Page level filters
Report level filters
- Q8. How can we share a power bi report with an external user?
- Ans.
To share a Power BI report with an external user, we can use the Publish to Web feature or share it via email.
Use the Publish to Web feature to generate an embed code that can be shared with external users
Ensure that the report contains only non-sensitive data before using the Publish to Web feature
Alternatively, share the report via email by granting access to the external user's email address
The external user must ha...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via Job Portal and was interviewed before Jan 2021. There were 2 interview rounds.
Interview Preparation Tips
- Procurement
- Marketing
- Career goal
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
- 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 .
- Ans.
Query to generate state-wise sales summary report with ranking using multiple table joins.
Use SQL JOINs to combine sales, states, and products tables.
Aggregate sales data using SUM() function grouped by state.
Use RANK() or DENSE_RANK() to rank states based on total sales.
Example SQL: SELECT state, SUM(sales) AS total_sales, RANK() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM sales_data JOIN states ON sales_data.s...
Interview Preparation Tips
Skills evaluated in this interview
What people are saying about Ernst & Young
Interview Questionnaire
1 Question
- Q1. Tell me about yourself
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Aug 2021. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Tell me about yourself, hobbies, interests, projects.
Interview Preparation Tips
Selected
I applied via Walk-in and was interviewed before May 2022. There were 2 interview rounds.
(2 Questions)
- Q1. What are SQL joins and various types of join
- Q2. What are different types of schemas
- Ans.
Schemas are the blueprint of a database. There are three types of schemas - Physical, Logical, and View.
Physical schema defines how data is stored in a database
Logical schema defines the structure of the data in a database
View schema defines how users view the data in a database
Examples of physical schema include file systems, RAID, etc.
Examples of logical schema include ER diagrams, UML diagrams, etc.
Examples of view ...
Interview Preparation Tips
Skills evaluated in this interview
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
- 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 Company Website and was interviewed in Dec 2021. There were 11 interview rounds.
A test designed to a determination a person ability in particular skill of field knowledge
Coding and decoding
Devolpment of a particular person group or situation over a period of time
(1 Question)
- Q1. Relating to a particular Subject art or carft or its techNical Terms
Is a situation faced when individuals collectively make a choice from alternative before them
A task or piEce of work allocated to someone a part of a job or course of study a home work assignment
(1 Question)
- Q1. InvolVoing or concerned with applied and industrial science
Coding interview test candidate technical knowledge coding ability creativity typically on a white board
(1 Question)
- Q1. Managing an organisation employees
(1 Question)
- Q1. Each player from one team is matched a single player from other team
The from are checked and returned to the census officer for coding
Interview Preparation Tips
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 Senior Associate Interview Questions
- Ernst & Young Manager Interview Questions
- Ernst & Young Technology Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Analyst Interview Questions
- Data Analyst Interview Questions
- Senior Consultant Interview Questions
- Senior Analyst Interview Questions
- Programmer Analyst Interview Questions
- Senior Business Analyst Interview Questions
- Research Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Ernst & Young Senior Data Analyst Reviews and Ratings
based on 19 reviews
Rating in categories
|
Senior Consultant
19.3k
salaries
|  ₹9.1 L/yr - ₹30 L/yr |
|
Consultant
13.1k
salaries
| ₹6.4 L/yr - ₹21 L/yr |
|
Manager
8k
salaries
| ₹16.8 L/yr - ₹51 L/yr |
|
Assistant Manager
6.8k
salaries
| ₹9.9 L/yr - ₹28.5 L/yr |
|
Associate Consultant
4.3k
salaries
| ₹4.8 L/yr - ₹15 L/yr |
Deloitte
PwC
EY Global Delivery Services ( EY GDS)
Accenture
- Home >
- Interviews >
- Ernst & Young Interview Questions
