Exl India Data Analyst Interview Questions and Answers

Q1. Highlight min & Max sales for each year in tableau.
Ans. 
Use Tableau to highlight the minimum and maximum sales for each year.
• Create a new worksheet in Tableau

• Drag the 'Year' field to the Columns shelf

• Drag the 'Sales' field to the Rows shelf

• Drag the 'Sales' field again to the Color shelf

• Right-click on the 'Sales' field in the Color shelf and select 'Measure' > 'Min'

• Right-click on the 'Sales' field in the Color shelf again and select 'Measure' > 'Max'

• Format the visualization
Answered by AI
Add your answer

SQL, Python and Power BI

Python, SQL, Aptitude

Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Add your answer

Talk to the head hunter. General phone screening

Q1. Talk to the hiring manager and another manager from BI. Asked about work experience and gave me a SQL test
Add your answer

Shared a dataset and wanted me to provide some insights and also build some slides to present