Lawand Marketing Consultancy Analyst Interview Questions and Answers

Shortlisted students were divided in group of 19

Selected students from gd got the call for case study round

Q1. Questions were based on the case study and guesstimates
Add your answer
Q2. No. of aeroplane flying in the sky right now
Ans. 
It is impossible to accurately determine the exact number of airplanes flying in the sky at any given moment.
• The number of airplanes in the sky constantly changes due to take-offs, landings, and flights being at different stages.

• Factors such as time of day, weather conditions, and air traffic also affect the number of airplanes in the sky.

• Air traffic control systems may provide estimates of the number of airplanes in a
Answered by AI
Add your answer
Q3. How will u utilise 1 acre of land provided to u near ur college
Ans. 
I would utilize the 1 acre of land near my college for creating a sustainable community garden.
• Establishing vegetable and fruit gardens to promote healthy eating among students

• Setting up a composting area to reduce waste and enrich the soil

• Creating a space for outdoor classes and events to enhance learning and community engagement
Answered by AI
Add your answer
Q4. How to start a starbuck franchisein ur town
Ans. 
To start a Starbucks franchise in your town, you need to follow a specific process set by the company.
• Contact Starbucks corporate office to inquire about franchise opportunities

• Meet the financial requirements and submit a franchise application

• Find a suitable location for the Starbucks store

• Complete the required training and adhere to Starbucks' standards and guidelines
Answered by AI
Add your answer
Q5. Sql extraction of the given table and data
Ans. 
Use SQL query to extract data from a given table
• Use SELECT statement to retrieve data from the table

• Specify the columns you want to retrieve after SELECT

• Use FROM clause to specify the table name

• Add conditions using WHERE clause if needed

• Use ORDER BY clause to sort the results if necessary
Answered by AI
Add your answer

Q1. Tell about yourself
Add your answer
Q2. Please summarize your experience with analytical or programming tools (e.g. Excel, Python, R, SQL, etc) (1 min 30 s)
Ans. 
I have extensive experience with Excel, Python, R, and SQL for data analysis and programming tasks.
• Proficient in Excel for data manipulation, analysis, and visualization

• Skilled in Python for data cleaning, statistical analysis, and machine learning

• Familiar with R for statistical modeling and data visualization

• Experience with SQL for querying databases and extracting insights
Answered by AI
Add your answer
Q3. Describe your experience in working in a cusomer support/service or client-facing role (1 min)
Add your answer
Q4. Why should we hire you (1 min)
Add your answer

120 minutes,aptitude,basic programming questions,three c problems from easy medium to hard

Q1. Tell me about yourself
Add your answer
Q2. Past experience
Add your answer
Q3. Explain about past projects
Ans. 
I have worked on various projects involving data analysis, market research, and financial modeling.
• Conducted market research to identify growth opportunities for a tech startup

• Developed financial models to forecast revenue and expenses for a retail company

• Analyzed customer data to improve retention rates for an e-commerce platform
Answered by AI
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and have completed multiple data analysis projects during my studies.

• I am proficient in using statistical software such as R and Python for data analysis.

• I have experience in conducting market research and creating reports to help businesses make informed decisions.

• I am a q...read more
Answered by AI
Add your answer
Q2. Why u want to join?
Ans. 
I am passionate about analyzing data and providing valuable insights to drive business decisions.
• Passionate about data analysis

• Enjoy providing insights to drive decisions

• Excited about contributing to business success
Answered by AI
Add your answer

Q1. Tell me in which subject u have confidence
Ans. 
I have confidence in the subject of data analysis and statistics.
• I have a strong understanding of statistical methods and data analysis techniques.

• I am proficient in using software tools like Excel, R, and Python for data analysis.

• I have experience in conducting hypothesis testing, regression analysis, and data visualization.

• I have successfully completed projects where I analyzed large datasets and provided actionable
Answered by AI
Add your answer
Q2. Random forest tell me
Ans. 
Random forest is an ensemble learning method used for classification and regression tasks.
• Random forest is a collection of decision trees that are trained on random subsets of the data.

• Each tree in the random forest independently predicts the target variable, and the final prediction is made by averaging the predictions of all trees.

• Random forest is known for its high accuracy and ability to handle large datasets with ...read more
Answered by AI
Add your answer

Insurance based questions

Mostly on insurance and accounting