Upload Button Icon Add office photos

Lowe's

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Lowe's Business Analyst Interview Questions and Answers

Updated 25 Jan 2025

Lowe's Business Analyst Interview Experiences

2 interviews found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. General question on powerbi and sql
  • Q2. Had solve sone queries on sql
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Assignment 

Some power BI problems and excel problems

Round 2 - Technical 

(1 Question)

  • Q1. SQL query questions along with power bi
Round 3 - HR 

(1 Question)

  • Q1. Excel and Power Bi and Analytics

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What is logistics regression
  • Ans. 

    Logistic regression is a statistical method used to analyze and model the relationship between a dependent variable and one or more independent variables.

    • It is a type of regression analysis used for predicting binary outcomes

    • It uses a logistic function to model the probability of the dependent variable

    • It is commonly used in fields such as healthcare, finance, and marketing

    • Example: Predicting whether a customer will buy...

  • Answered by AI

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is logistics regression
  • Ans. 

    Logistic regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.

    • It is a type of regression analysis used for predicting binary outcomes

    • It uses a logistic function to model the probability of the dependent variable

    • It is commonly used in fields such as healthcare, finance, and marketing

    • Example: Predicting whether a customer w...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics of statistics, SQL and Python

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. In brick and motor business which are the key metrics responsible for tracking growth ?
  • Ans. 

    Key metrics for tracking growth in brick and mortar business.

    • Sales revenue

    • Customer footfall

    • Average transaction value

    • Customer retention rate

    • Inventory turnover rate

    • Gross profit margin

    • Net promoter score

    • Employee productivity

    • Marketing ROI

  • Answered by AI
  • Q2. How are they interrelated to each other ? Basically a KPI tree ?
  • Ans. 

    KPIs are interrelated in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

    • KPIs are Key Performance Indicators that measure the success of a business or project.

    • KPIs can be organized in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.

    • For example, a company's overall revenue might be a high-level KPI, with lower-level KPIs such as sales revenue and cust...

  • Answered by AI
  • Q3. Case study of advertising of a new store opening in location ?
  • Ans. 

    Advertising a new store opening in a location

    • Identify target audience and their preferences

    • Create a catchy slogan and design attractive visuals

    • Utilize social media platforms and local newspapers for promotion

    • Offer discounts and promotions to attract customers

    • Organize a grand opening event to create buzz and excitement

  • Answered by AI
  • Q4. Case study regarding targeting customers ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Should be prepared with in and out of brick and mortar business .
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic Aptitude question

Round 2 - Group Discussion 

Allocated one topic and given half an hour of time to prepare on it

Round 3 - Technical 

(2 Questions)

  • Q1. Tenchnical coding related questions
  • Q2. Libraries used for interview, basic joins etc
Round 4 - One-on-one 

(1 Question)

  • Q1. Business related questions
Round 5 - HR 

(1 Question)

  • Q1. Why do you want to join this company
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
  • Q2. Difference between Vlookup and Xlookup ?
  • Ans. 

    Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.

    • Vlookup searches vertically in a table and returns a value from a specified column.

    • Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

    • Vlookup requ...

  • Answered by AI
  • Q3. Difference between Subquery and CTE. Which is better?
  • Ans. 

    Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.

    • Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

    • CTE is defined using the WITH keyword and can be referenced multiple times in a query.

    • CTEs are more readable and easier to maintain compared to subqueries.

    • Subqueries are useful when t...

  • Answered by AI
  • Q4. No of records returned after applying left and inner join on 2 tables.
  • Q5. Pivot the table in SQL using case when statements.
  • Ans. 

    Pivoting a table in SQL using case when statements

    • Use the CASE WHEN statement to create new columns based on specific conditions

    • Use the SUM or COUNT function to aggregate data in the pivoted table

    • Group by the remaining columns to ensure correct aggregation

    • Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;

  • Answered by AI
Round 2 - Case Study 

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Interview Preparation Tips

Topics to prepare for Landmark Group Business Analyst interview:
  • SQL
  • EXCEL
Interview preparation tips for other job seekers - Solve as many Business case studies as you can. Prepare well for SQL questions. You might get asked situation-based questions. Follow and show a structured approach while solving these questions. and you are good to go.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Write sql query on leet code
  • Ans. 

    SQL query on LeetCode platform for business analysis.

    • Use SELECT statement to retrieve data from database tables.

    • Use JOIN clause to combine data from multiple tables.

    • Use WHERE clause to filter data based on specific conditions.

  • Answered by AI
  • Q2. Power BI interview questions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

60 question 90 minutes

Round 2 - Group Discussion 

Faviorate sports persion of india

Interview Preparation Tips

Interview preparation tips for other job seekers - good
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. About sql, python, visualaization
Round 2 - Technical 

(1 Question)

  • Q1. About sql and business kpi's
Round 3 - Technical 

(1 Question)

  • Q1. Sql and business kpi's
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Contribute & help others!
anonymous
You can choose to be anonymous

Lowe's Interview FAQs

How many rounds are there in Lowe's Business Analyst interview?
Lowe's interview process usually has 2 rounds. The most common rounds in the Lowe's interview process are Technical, Assignment and HR.
What are the top questions asked in Lowe's Business Analyst interview?

Some of the top questions asked at the Lowe's Business Analyst interview -

  1. Excel and Power Bi and Analyt...read more
  2. SQL query questions along with power...read more
  3. General question on powerbi and ...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

Millennium Management

No Interviews

INTERVIEWS

DE Shaw

No Interviews

LIST OF COMPANIES

DE Shaw

Locations

INTERVIEWS

Builders FirstSource

No Interviews

INTERVIEWS

Lowe's

No Interviews

Tell us how to improve this page.

Lowe's Business Analyst Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more
Lowe's Business Analyst Salary
based on 38 salaries
₹5 L/yr - ₹20 L/yr
24% more than the average Business Analyst Salary in India
View more details

Lowe's Business Analyst Reviews and Ratings

based on 5 reviews

3.8/5

Rating in categories

3.3

Skill development

3.8

Work-life balance

3.6

Salary

3.7

Job security

4.1

Company culture

2.9

Promotions

3.4

Work satisfaction

Explore 5 Reviews and Ratings
Software Engineer
1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
962 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
231 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
221 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Software Engineer
164 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Lowe's with

Home Depot

3.7
Compare

Ace Hardware

2.7
Compare

Menards

3.0
Compare

Sherwin Williams Paints

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview