Xpo Logistics Business Analyst Interview Questions and Answers

Related finance use case

Basic logical reasoning questions and no other things

Not very high level coding questions

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 ...read more
Answered by AI
Add your answer

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

First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset

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
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Add your answer