Exl India Tableau Developer Interview Questions and Answers

Q1. How would you handle a situation in which you were unable to meet a high-priority urgent deadline set by a stakeholder?
Ans. 
I would communicate transparently, prioritize tasks, and propose solutions to manage expectations and meet stakeholder needs.
• Assess the situation: Quickly evaluate the reasons for the delay and the impact on the project timeline.

• Communicate proactively: Inform the stakeholder as soon as possible, explaining the challenges and providing a revised timeline.

• Prioritize tasks: Identify critical tasks that can be completed t...read more
Answered by AI
Add your answer
Q2. Can you provide more details about the projects you have worked on and their impact on the business?
Ans. 
I have worked on various data analysis projects that significantly improved decision-making and operational efficiency.
• Developed a sales forecasting model that increased accuracy by 20%, leading to better inventory management.

• Analyzed customer feedback data to identify key pain points, resulting in a 15% increase in customer satisfaction scores.

• Created a dashboard for tracking marketing campaign performance, which help...read more
Answered by AI
Add your answer

Q1. Detailed questions on probability. Statistical questions.
Add your answer

Stats and Reasoning

Q1. SQL questions were asked
Add your answer

Q1. Behavioral type of questions.
Add your answer

Q1. Just the salary discussions
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

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
Ans. 
Find employees with both Python and SQL skills from the EmployeeSkills table.
• Use a GROUP BY clause to group by EmpID.

• Use a HAVING clause to filter groups that contain both skills.

• Example SQL query: SELECT EmpID FROM EmployeeSkills WHERE Skills IN ('Python', 'SQL') GROUP BY EmpID HAVING COUNT(DISTINCT Skills) = 2.
Answered by AI
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Ans. 
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
• Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

• Users can add bookmarks by selecting 'Add' and then naming the bookmark.

• Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

• Bookmarks can be used to save different views of a report for easy acc...read more
Answered by AI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Ans. 
Use SQL query with window function to find cumulative profit sum in a given table.
• Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

• Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

• Ensure the table has a column for date and profit to order and calculate cumulative sum.
Answered by AI
Add your answer

SQL, Python and Power BI

Q1. Sql joins ,proimary key, foreign key,window functions
Add your answer
Q2. What are the different types of charges associated with logistics?
Ans. 
Logistics charges encompass various costs incurred in the transportation and storage of goods.
• Transportation Costs: Fees for moving goods via truck, rail, air, or sea. Example: Freight charges for shipping a container.

• Warehousing Fees: Costs associated with storing goods in a warehouse. Example: Monthly rental fees for storage space.

• Handling Charges: Fees for loading and unloading goods. Example: Charges for palletizin...read more
Answered by AI
Add your answer
Q3. What is the SQL query to retrieve the top three maximum salaries from a table?
Ans. 
Retrieve the top three maximum salaries using SQL with ORDER BY and LIMIT clauses.
• Use the SELECT statement to specify the column (salary) you want to retrieve.

• ORDER BY salary DESC to sort the salaries in descending order.

• Use LIMIT 3 to restrict the result to the top three salaries.

• Example SQL query: SELECT salary FROM employees ORDER BY salary DESC LIMIT 3;
Answered by AI
Add your answer