Lowe's Data Analyst Interview Questions and Answers for Freshers

Q1. Python questions dataframe creata
Add your answer
Q2. SQL questions joins , windows function,cte
Add your answer

Q1. Find top 3 students in a class
Ans. 
Identify the top 3 students based on their grades in a class.
• Calculate the average grade for each student

• Sort the students based on their average grades in descending order

• Select the top 3 students
Answered by AI
View 1 more answer

Guesstimate questions

Q1. Directors ask behavioural questions
Add your answer

Basic SQL and tableau questions

Q1. How do you work in a team?
Add your answer

Road daily revenue collection

Q1. SQL question, Python coding
Add your answer
Q2. Highest salary in a table
Add your answer

Q1. Salary Negotiation
Add your answer

It was Python based basic questions only

Q1. Basic question, strength, weakness
Add your answer

Q1. The difference between union and union all
Ans. 
Union combines and removes duplicates, while Union All combines without removing duplicates.
• Union combines two result sets and removes duplicates

• Union All combines two result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Union requires both result sets to have the same number of columns and compatible data types
Answered by AI
Add your answer
Q2. SQL query execution order
Add your answer

10 sql and 10 python questions

Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...read more
Add your answer