AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Landmark
Group
Compare
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
Landmark Group Business Analyst Interview Questions and Answers
11 Interview questions
Effective salary negotiation involves research, clear communication, and understanding your worth in the market.
Research industry standards: Use websites like Glassdoor or Payscale to find average salaries for your role.
Know your worth: Assess your skills, experience, and unique contributions to justify your salary request.
Practice your pitch: Prepare a clear and confident explanation of why you deserve the salary...
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.
Understanding record counts from left and inner joins helps in data analysis and decision-making.
A left join returns all records from the left table and matched records from the right table.
An inner join returns only the records that have matching values in both tables.
Example: If Table A has 5 records and Table B has 3 matching records, a left join will return 5 records, while an inner join will return 3.
If there...
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;
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...
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 custo...
Landmark Group HR Interview Questions
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
Analyzing customer segments to optimize marketing strategies and improve engagement.
Identify customer demographics: Age, gender, income level, etc. (e.g., targeting millennials for tech products).
Analyze purchasing behavior: Frequency, average spend, and product preferences (e.g., loyal customers vs. one-time buyers).
Utilize data analytics tools: Leverage CRM systems to gather insights (e.g., Salesforce for tracki...
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 w...
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
Landmark Group Business Analyst Interview Experiences
9 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Apr 2024. There were 2 interview rounds.
(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...
- 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...
- Q4. No of records returned after applying left and inner join on 2 tables.
- Ans.
Understanding record counts from left and inner joins helps in data analysis and decision-making.
A left join returns all records from the left table and matched records from the right table.
An inner join returns only the records that have matching values in both tables.
Example: If Table A has 5 records and Table B has 3 matching records, a left join will return 5 records, while an inner join will return 3.
If there are ...
- 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;
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
- SQL
- EXCEL
Skills evaluated in this interview
Basic Aptitude question
Allocated one topic and given half an hour of time to prepare on it
(2 Questions)
- Q1. Tenchnical coding related questions
- Q2. Libraries used for interview, basic joins etc
(1 Question)
- Q1. Business related questions
(1 Question)
- Q1. Why do you want to join this company
(1 Question)
- Q1. About sql, python, visualaization
(1 Question)
- Q1. About sql and business kpi's
(1 Question)
- Q1. Sql and business kpi's
(1 Question)
- Q1. Salary negotiation
60 question 90 minutes
Faviorate sports persion of india
Interview Preparation Tips
Selected
I appeared for an interview before Nov 2023.
Case study +aptitute+SQL
Case study +problem solving round
(2 Questions)
- Q1. Salary negotiation
- Ans.
Effective salary negotiation involves research, clear communication, and understanding your worth in the market.
Research industry standards: Use websites like Glassdoor or Payscale to find average salaries for your role.
Know your worth: Assess your skills, experience, and unique contributions to justify your salary request.
Practice your pitch: Prepare a clear and confident explanation of why you deserve the salary you'...
- Q2. Behavioural questions
Selected
I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.
(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.
- Q2. Power BI interview questions
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. What is logistics regression
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
- 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...
- 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
- Q4. Case study regarding targeting customers ?
- Ans.
Analyzing customer segments to optimize marketing strategies and improve engagement.
Identify customer demographics: Age, gender, income level, etc. (e.g., targeting millennials for tech products).
Analyze purchasing behavior: Frequency, average spend, and product preferences (e.g., loyal customers vs. one-time buyers).
Utilize data analytics tools: Leverage CRM systems to gather insights (e.g., Salesforce for tracking cu...
Interview Preparation Tips
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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Selected
I applied via Company Website and was interviewed before Aug 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Subjective based
- Q2. Situational awareness
Interview Preparation Tips
Landmark Group Interview FAQs
Some of the top questions asked at the Landmark Group Business Analyst interview -
Tell us how to improve this page.
Landmark Group Interviews By Designations
- Landmark Group Assistant Manager Interview Questions
- Landmark Group Store Manager Interview Questions
- Landmark Group Business Analyst Interview Questions
- Landmark Group Department Manager Interview Questions
- Landmark Group Retail Store Manager Interview Questions
- Landmark Group Cluster Manager Interview Questions
- Landmark Group Inventory Controller Interview Questions
- Landmark Group Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 7 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Landmark Group Business Analyst Reviews and Ratings
based on 17 reviews
Rating in categories
2-4 Yrs
₹ 8.9-20 LPA
|
Assistant Manager
393
salaries
|  ₹9 L/yr - ₹14 L/yr |
|
Store Manager
317
salaries
| ₹5.3 L/yr - ₹12.5 L/yr |
|
Senior Executive
232
salaries
| ₹4.5 L/yr - ₹8.7 L/yr |
|
Department Manager
200
salaries
| ₹2.2 L/yr - ₹6.3 L/yr |
|
Business Analyst
126
salaries
| ₹9.9 L/yr - ₹17 L/yr |
DMart
Vishal Mega Mart
Future Group
Walmart
- Home >
- Interviews >
- Landmark Group Interview Questions
