AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Landmark Group
Compare
Filter interviews by
Landmark Group Business Analyst Interview Questions and Answers for Freshers
Landmark Group Business Analyst Interview Experiences for Freshers
2 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.
- 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
Selected
I appeared for an interview before Nov 2023.
Case study +aptitute+SQL
Case study +problem solving round
(2 Questions)
- Q1. Salary negotiation
- Q2. Behavioural questions
Interview questions from similar companies
Selected
I applied via LinkedIn and was interviewed before May 2023. There were 3 interview rounds.
(1 Question)
- Q1. SQL and Visualizationbased questions
Case study for business problems
(1 Question)
- Q1. Behaviour fit round
yogini katkar
I applied via Job Portal and was interviewed in Jan 2024. There was 1 interview round.
(1 Question)
- Q1. Difference between SQL /NON SQL
- Ans.
SQL is a structured query language used for relational databases, while NoSQL is a non-relational database management system.
SQL is used for structured data with predefined schema, while NoSQL is used for unstructured or semi-structured data.
SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.
SQL databases are ACID compliant, ensuring data integrity, while NoSQL databases sacrifice so...
Skills evaluated in this interview
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
I applied via Referral and was interviewed in Sep 2023. There was 1 interview round.
(2 Questions)
- Q1. How do you align with the core values and mission of Walmart?
- Q2. What advice would you give to the CEO of walmart?
(2 Questions)
- Q1. General question on powerbi and sql
- Q2. Had solve sone queries on sql
Selected
I appeared for an interview before Jan 2024.
Some power BI problems and excel problems
(1 Question)
- Q1. SQL query questions along with power bi
(1 Question)
- Q1. Excel and Power Bi and Analytics
Selected
I appeared for an interview in Jul 2024.
Advance excel... Will check your logical thinking skills.
(4 Questions)
- Q1. Tell me about your relevant experience and what makes you qualified for this position. (Answer should be in Situation, Behaviour and Outcome format)
- Q2. Describe how you partner with someone who holds opinions that often differ from your own. (Answer should be in Situation Behaviour and Outcome format)
- Ans.
I actively listen, seek common ground, and collaborate to find solutions.
Actively listen to understand their perspective
Seek common ground and areas of agreement
Collaborate to find mutually beneficial solutions
Respectfully communicate and discuss differences
Focus on the end goal and shared objectives
- Q3. Describe the steps you take to collaborate with others to accomplish a goal. (Answer should be in Situation Behaviour and Outcome format)
- Q4. Describe what you do to propose solutions that are right for the organization's guests and team members in the role you've applied to. (Answer should be in Situation Behaviour and Outcome format)
- Ans.
I conduct thorough research, gather feedback, and collaborate with stakeholders to propose solutions that meet the needs of guests and team members.
Conduct research to understand the needs and preferences of guests and team members
Gather feedback from various stakeholders to identify pain points and areas for improvement
Collaborate with cross-functional teams to brainstorm and develop solutions that address the identif...
Selected
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. Describe a scenario where you tackled a situation successfully
Interview Preparation Tips
Landmark Group Interview FAQs
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
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
Landmark Group Business Analyst Interview Process for Freshers
based on 2 interviews
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
Landmark Group Business Analyst Reviews and Ratings
based on 16 reviews
Rating in categories
|
Assistant Manager
406
salaries
|  ₹5 L/yr - ₹20 L/yr |
|
Store Manager
309
salaries
| ₹4.9 L/yr - ₹15 L/yr |
|
Senior Executive
229
salaries
| ₹1.7 L/yr - ₹10.1 L/yr |
|
Department Manager
200
salaries
| ₹2 L/yr - ₹5.5 L/yr |
|
Manager
120
salaries
| ₹7.3 L/yr - ₹28.5 L/yr |
DMart
Future Group
Vishal Mega Mart
Walmart
- Home >
- Interviews >
- Landmark Group Interview Questions >
- Landmark Group Business Analyst Interview Questions for Fresher
