Bhalchandra Institute of Education and Management Business Analyst Interview Questions and Answers

Question about excel, pivot table , SQL and power bi

Q1. Why your interested
Add your answer
Q2. Why you want to Jon
Add your answer

Q1. Java , oops, version control , ci/cd , springboot
Add your answer
Q2. Microservice, restful api, junit
Add your answer

Email writing in 280 words

Q1. Salary discussion
Add your answer
Q2. Why do you want to join
Ans. 
I am passionate about helping organizations improve their efficiency and effectiveness through strategic consulting.
• Passionate about problem-solving and finding innovative solutions

• Enjoy working with diverse teams and collaborating towards a common goal

• Excited about the opportunity to make a positive impact on businesses
Answered by AI
Add your answer

Q1. Data Given on Excel to Solve.
Add your answer
Q2. Advanced Functions of Excel.
Ans. 
Advanced Excel functions enhance data analysis through powerful tools like VLOOKUP, INDEX, MATCH, and pivot tables.
• VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from a specified column. Example: =VLOOKUP(A2, B2:D10, 3, FALSE)

• INDEX & MATCH: A powerful combination for flexible lookups. Example: =INDEX(B2:B10, MATCH(A2, A2:A10, 0))

• Pivot Tables: Summarize large dataset...read more
Answered by AI
Add your answer

Q1. Spreadsheet automation
Add your answer
Q2. Google sheet work
Add your answer

India gdp growth and make in india

Q1. Global market and em market
Add your answer

Aptitude test aptitude test

Q1. Technical question. Excel power bi
Add your answer

Q1. Salary discussed
Add your answer