99acres MIS Analyst Interview Questions and Answers

Q1. SQL based questions
Add your answer
Q2. Guesstimate on estimating # users on the application
Ans. 
Estimate the number of users on the application based on market research, user demographics, and industry trends.
• Consider the total addressable market (TAM) for the application

• Analyze user demographics and behavior to estimate adoption rate

• Look at industry benchmarks and competitor data for reference

• Use surveys, focus groups, and user feedback to gather insights

• Consider factors like market saturation, growth potential,
Answered by AI
Add your answer

Easy coding questions

Tough level questions , needed high level of thinking

Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
Add your answer
Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
Add your answer
Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Add your answer

Q1. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.
• Rank assigns unique ranks to each distinct value in a dataset

• Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

• For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3
Answered by AI
Add your answer
Q2. How will merge multiple file in python
Ans. 
Merge multiple files in Python using pandas.concat() or pd.merge() functions.
• Use pandas.concat() function to merge multiple files vertically (row-wise).

• Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

• Ensure that the files have compatible column names and data types before merging.

• Handle any missing or duplicate values appropriately during the merging process.

• Consider ...read more
Answered by AI
Add your answer
Q3. Data frame explain in detail
Ans. 
A data frame is a two-dimensional data structure in which data is stored in rows and columns.
• Data frames are commonly used in programming languages like R and Python for data analysis.

• Each column in a data frame represents a variable, while each row represents an observation.

• Data frames can contain different types of data, such as numeric, character, and factor.

• Data frames can be created from various sources like CSV f
Answered by AI
Add your answer

Send assignment doings MS Excel

Q1. Asked about the previous project
Add your answer
Q2. What about your roles in previous company
Add your answer

Q1. Be confident there is no barrier of language in this organisation if you are comfortable in hindi use it
Add your answer

General SQL and Python questions for Data analysis and Visualization tools

Q1. What do you understand y Churn Rate ?
Ans. 
Churn Rate is the percentage of customers who stop using a product or service over a certain period of time.
• Churn Rate is calculated by dividing the number of customers who stopped using the product by the total number of customers at the beginning of the period.

• It is used to measure customer retention and satisfaction.

• A high churn rate indicates that a company may be losing customers at a high rate, while a low churn ...read more
Answered by AI
Add your answer
Q2. What can be done to increase retention rate ?
Ans. 
To increase retention rate, companies can focus on improving employee engagement, providing opportunities for growth and development, offering competitive compensation and benefits, and creating a positive work culture.
• Improve employee engagement through regular feedback sessions and recognition programs

• Provide opportunities for growth and development through training programs and career advancement opportunities

• Offer ...read more
Answered by AI
Add your answer