Naukri Business Analyst Interview Questions and Answers

The weight of an aircraft is crucial for its performance and safety.

• The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

• The weight of an aircraft is measured in pounds or kilograms.

• The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

• Aircraft manufacturers provide maximum takeoff and la...read more

SQL query to get top 100 Uber drivers by city

• Join drivers and users tables on city

• Aggregate driver ratings and count of rides

• Order by rating and count of rides

• Limit to top 100

Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

• Analyze user behavior and preferences to understand their needs and preferences

• Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

• Optimize search functionality to ensure accurate and relevant results

• Collaborate with restaurants to imp...read more

Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

• Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

• Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

• Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

• Linear Regression is...read more

Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

• Bias-Variance trade-off is a fundamental concept in machine learning.

• High bias models are simple and have low variance, but are inaccurate.

• Low bias models are complex and have high variance, but can overfit the data.

• Examples of high bias models are linear r...read more

Possible reasons for a car manufacturer's decline in profits by 40% year over year

• Decreased demand for cars due to economic downturn

• Increased competition from other car manufacturers

• Rising production costs and expenses

• Decline in consumer confidence and spending

• Changes in government regulations impacting the automotive industry

I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

• Experienced in conducting market research and competitor analysis

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

• Skilled in identifying business needs and translating them into functional requirements

• Excellent communication and presentation skills

• Ability to work colla...read more

I want to work here because of the company's reputation, growth opportunities, and alignment with my skills and interests.

• I am impressed by the company's reputation in the industry.

• I see great potential for growth and advancement within the company.

• The company's values and mission align with my own.

• I believe my skills and experience would be a valuable asset to the company.

• I am excited about the opportunity to contribu...read more

I have a unique combination of technical skills and business acumen, allowing me to bridge the gap between IT and business stakeholders.

• I have a strong background in both technology and business domains.

• I can effectively communicate with both technical and non-technical stakeholders.

• I have a track record of successfully translating business requirements into technical solutions.

• I possess a deep understanding of various...read more

The company is a leading technology firm specializing in software development and consulting services.

• The company was founded in 2005 and has since grown to have a global presence.

• They offer a wide range of services including business analysis, software development, and project management.

• Some of their notable clients include Fortune 500 companies in various industries.

• They have a strong focus on innovation and staying...read more

My key professional strengths include analytical thinking, problem-solving, and effective communication.

• Analytical thinking: I have a strong ability to analyze complex business problems and identify key insights.

• Problem-solving: I am skilled at finding creative solutions to challenges and implementing them effectively.

• Effective communication: I can communicate complex ideas and findings clearly and concisely to stakeho...read more

My biggest weaknesses include perfectionism, overthinking, and public speaking anxiety.

• Perfectionism: I tend to spend too much time on tasks to ensure they are flawless.

• Overthinking: I sometimes overanalyze situations, which can lead to indecisiveness.

• Public speaking anxiety: I get nervous when presenting in front of large audiences.