Lenskart MIS Executive and Analyst Interview Questions and Answers

Q1. Basic Communication Skills
Add your answer
Q2. Background and why to change the job
Add your answer

Q1. Brief about your background
Add your answer
Q2. Excel and SQL basic questions. For data visualisation.
Add your answer

Q1. What are the roles you were responsible for in previous company
Add your answer
Q2. Pivot tables and Financial basic questions on revenue.
Add your answer

Q1. How do you think will fit in the role?
Add your answer
Q2. Basic understanding of Revenue and Financial statements.
Add your answer
Q3. What do you want to do in life? The goal.
Add your answer

Q1. Basic communication skills with the background test.
Add your answer
Q2. Why this role suits you.
Add your answer
Q3. Current and expectation of salary.
Add your answer

Q1. How do you gain experience in data analysis?
Add your answer
Q2. What are your thoughts on the matter?
Add your answer
Q3. What is algorithm
Add your answer

Q1. What is a data structure?
Add your answer
Q2. What are the different types of data structures available?
Add your answer

Q1. Difference Between Rank and Dense Rank
Ans. 
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
• Rank does not skip ranks when there are ties, while Dense Rank does

• Rank will have gaps in ranks if there are ties, while Dense Rank will not

• Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
Answered by AI
Add your answer
Q2. Some Basic Joins
Add your answer
Q3. Socks Pair Puzzle Qustions
Add your answer

Q1. Sql Medium Level questions
Add your answer
Q2. Easy guesstimates were asked
Add your answer

Q1. Caee Study was asked
Add your answer
Q2. Resume grilling was done
Add your answer

Q1. Why you want to join Ola ?
Ans. 
I want to join Ola because of its innovative technology, market leadership, and potential for growth.
• Ola is a market leader in the ride-sharing industry, which presents exciting challenges and opportunities for a business analyst.

• I am impressed by Ola's focus on innovation and technology, which aligns with my passion for leveraging data and analytics to drive business decisions.

• I believe Ola's fast-paced environment an...read more
Answered by AI
Add your answer
Q2. Salary Negotiation was done
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Q1. About previous experience situation based questions excel problem solving
Add your answer
Q2. Tell me about yourself difference between data quality and data validity
Add your answer

Q1. Projects Worked
Ans. 
I have worked on various projects involving data analysis, visualization, and interpretation.
• Developed predictive models using machine learning algorithms

• Performed data cleaning and preprocessing to ensure accuracy

• Created interactive dashboards for stakeholders to easily understand insights
Answered by AI
Add your answer
Q2. SQL functions used in the projects
Ans. 
Common SQL functions used in projects include COUNT, SUM, AVG, MAX, MIN, and GROUP BY.
• COUNT: Used to count the number of rows in a table.

• SUM: Used to calculate the sum of a column.

• AVG: Used to calculate the average value of a column.

• MAX: Used to find the maximum value in a column.

• MIN: Used to find the minimum value in a column.

• GROUP BY: Used to group rows that have the same values into summary rows.
Answered by AI
Add your answer
Q3. Machine learning alogriths
Add your answer

Q1. What is pivot table , v lookup
Add your answer
Q2. Write Sql query for find min and max
Add your answer