Landmark Group Data Analyst Interview Questions and Answers

Mcqs of coding and ML

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...read more
Answered by AI
Add your answer

50 questions in 12 minutes to be solved.

Q1. Based on CV tell me about yourself five-year plan
Ans. 
I am an experienced Analyst with a strong background in data analysis and problem-solving. My five-year plan includes advancing my skills in predictive modeling and becoming a team leader in my field.
• Experienced Analyst with expertise in data analysis and problem-solving

• Strong background in predictive modeling

• Goal to become a team leader in the next five years
Answered by AI
Add your answer
Q2. Situational based question
Add your answer

Q1. Tell me about your projects
Ans. 
I have worked on various projects involving data analysis, process improvement, and system implementation.
• Implemented a new CRM system to streamline customer data management

• Conducted data analysis to identify trends and opportunities for cost savings

• Led a cross-functional team to improve inventory management processes

• Developed KPI dashboards to track project performance and ROI
Answered by AI
Add your answer
Q2. What are your day to day activities
Ans. 
As a Business Analyst, my day to day activities include gathering and analyzing data, creating reports, identifying business trends, and collaborating with stakeholders.
• Gathering and analyzing data to identify business opportunities and trends

• Creating reports and presentations to communicate findings to stakeholders

• Collaborating with stakeholders to understand business needs and requirements

• Conducting meetings and inte...read more
Answered by AI
Add your answer

Asked me to prepare a PPT on reliance retail

Q1. We can give only 30% hike.. why would I hire you?
Ans. 
I bring a unique combination of skills, experience, and passion for the role that will drive value beyond just the salary increase.
• My track record of delivering successful projects on time and within budget showcases my ability to add significant value to the organization.

• I possess a diverse skill set including data analysis, problem-solving, and stakeholder management which are crucial for a Business Analyst role.

• My p...read more
Answered by AI
Add your answer

Q1. Tell about project that you have been Working on
Ans. 
Developed a data analysis tool for tracking customer behavior on e-commerce platform
• Used Python and SQL to extract and analyze data from the database

• Implemented machine learning algorithms to predict customer preferences

• Created visualizations to present findings to stakeholders
Answered by AI
Add your answer

English, Logic, Quantitative Analysis, Situation.

Q1. Can you provide an introduction and describe your past experience?
Ans. 
Experienced business analyst with a strong background in data analysis and process improvement.
• Over 5 years of experience in analyzing business processes and identifying areas for improvement

• Proficient in data analysis tools such as Excel, SQL, and Tableau

• Led cross-functional teams to implement process improvements resulting in cost savings of 10%

• Developed KPIs to track project performance and ensure alignment with bus
Answered by AI
Add your answer
Q2. What attracts you to this company, and what are your goals and areas of focus?
Ans. 
I am attracted to this company's innovative approach to problem-solving and collaborative work environment. My goal is to leverage my analytical skills to drive business growth and efficiency.
• Attracted to company's innovative approach to problem-solving

• Excited about collaborative work environment

• Goal is to leverage analytical skills for business growth and efficiency
Answered by AI
Add your answer

Q1. Basic details about previous experience, our expectations and educational details
Add your answer

Q1. Technical question on basic electrical engineering
Add your answer
Q2. Technical questions from previous employments
Add your answer
Q3. Technical questions on IoT project and college project
Add your answer

Given a regulation and asked to prepare a presentation and asked to present the ppt

Q1. Salary expectation
Add your answer
Q2. Comfortable about travelling
Ans. 
Yes, I am comfortable with traveling for work.
• I have previous experience traveling for work and am familiar with the demands of it.

• I am flexible and adaptable to different travel schedules and locations.

• I understand the importance of face-to-face interactions with stakeholders and clients, which may require travel.

• I am willing to travel as needed to ensure project success and meet business objectives.
Answered by AI
Add your answer
Q3. Comfortable relocated to job location
Ans. 
Yes, I am comfortable relocating to the job location.
• I am open to relocating for the right opportunity

• I have relocated for previous jobs and have had positive experiences

• I am flexible and adaptable to new environments
Answered by AI
Add your answer
Q4. Basic HR questions
Add your answer

Q1. Vlookup sumif all excel formulas
Add your answer