Impact Analytics Interview Questions, Process, and Tips

Coding exercise related to probability

Q1. Database design for ride hailing service like uber, ola
Add your answer
Q2. Tech stack needed to build a real time application
Ans. 
Tech stack for real time applications includes WebSocket, Node.js, Redis, and MongoDB.
• Use WebSocket for real-time communication between client and server

• Node.js for server-side logic and handling multiple connections efficiently

• Redis for caching and storing real-time data

• MongoDB for persistent data storage and retrieval
Answered by AI
Add your answer

The test covered questions around stats (mean, median, etc), python, SQL and aptitude questions

Q1. Write a python code for the Fibonacci series.
Q2. Write a SQL code find the mean salary for every department.
Q3. Write a SQL code to find the employee age at the time of joining the company.
Q4. Rewrite the above queries in Python.

Q1. Python questions, write a SQL query to return employee with the number of leaves in each month, Vlookup, Index Match, Rank, Dense Rank
Add your answer
Q2. Loc and iloc in python
Ans. 
loc and iloc are methods in pandas used for selecting rows and columns by label or integer position.
• loc is used for selecting rows and columns by label

• iloc is used for selecting rows and columns by integer position

• Example: df.loc[0:5, 'column_name']

• Example: df.iloc[0:5, 2]
Answered by AI
Add your answer
Q3. Advantage of Vlookup over-index match
Ans. 
Vlookup is simpler and easier to use, while Index Match is more flexible and efficient.
• Vlookup is easier for beginners to understand and use

• Vlookup is quicker to set up and requires less formula writing

• Index Match is more flexible as it can look up values in any column, not just the first one

• Index Match is more efficient for large datasets as it does not require the entire column to be searched
Answered by AI
Add your answer
Q4. Difference between BRD and FRD
Ans. 
BRD focuses on business requirements while FRD focuses on functional requirements.
• BRD (Business Requirements Document) outlines the business problem that needs to be solved.

• FRD (Functional Requirements Document) details how the system will meet the business requirements.

• BRD is more high-level and focuses on the 'what', while FRD is more detailed and focuses on the 'how'.

• BRD is typically created before FRD in the projec...read more
Answered by AI
Add your answer
Q5. Retail experience and analysis
Ans. 
Retail experience and analysis
• I have over 5 years of experience in retail industry analysis

• Proficient in using data analytics tools to track sales trends and customer behavior

• Implemented strategies based on market research to increase sales and customer satisfaction

• Collaborated with cross-functional teams to optimize inventory management and pricing strategies
Answered by AI
Add your answer

It was of 1 hour. It consist of 2 coding questions and 25 MCQ's

This was related to general problem solving

Q1. Talk about your projects
Ans. 
I have worked on various projects including developing web applications, implementing machine learning algorithms, and optimizing database performance.
• Developed a web application for a retail company to manage inventory and sales data

• Implemented machine learning algorithms for predicting customer churn in a telecom company

• Optimized database performance for a healthcare organization to improve query speed
Answered by AI
Add your answer
Q2. Questions related to resume
Add your answer

Q1. Basic behavioural questions
Add your answer

Quant, english, logical reasoning gfg, data interpretation

Q1. Resume related ques and basic HR ques
Add your answer

Q1. Basic python question like sorting
Add your answer