Xpo Logistics Senior Engineer Interview Questions and Answers

Aptitude round MCQ Dot net csharp sal

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

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
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
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

Q1. Tell me about yourself
Add your answer
Q2. How to use vernier calliper
Ans. 
Vernier caliper is a precision measuring tool used to measure dimensions with high accuracy.
• Ensure the jaws are clean and properly aligned before use

• Close the jaws and adjust the main scale to zero

• Open the jaws and place the object to be measured between them

• Close the jaws gently to ensure a snug fit and read the measurement on the vernier scale

• Take the measurement from the point where the zero on the vernier scale ali...read more
Answered by AI
Add your answer

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

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