Tech Mahindra Business Intelligence Analyst Interview Questions and Answers

Q1. How to connect the SQL & PowerBi backend database
Ans. 
To connect SQL & PowerBI backend database, use the 'Get Data' option in PowerBI and select SQL Server as the data source.
• Open PowerBI and select 'Get Data' option

• Select 'SQL Server' as the data source

• Enter the server name and database name

• Choose the authentication method

• Select the tables/views to import

• Transform the data if required

• Create visualizations using the imported data
Answered by AI
Add your answer

Q1. Complex sql question based on lead lag
Add your answer
Q2. Question based on data index
Add your answer
Q3. Question based on data engineer
Add your answer

Q1. Pandas basics and SQL joins nlp
Add your answer

Q1. Machine learning related questions and the theory of its operation
Add your answer

It was a campus placement during my second year of Mtech. So they followed the usual standard format. Aptitude and personality quiz.

Q1. Tell me about yourself favourite subject Python Libraries Projects Data science (NLP)
Add your answer

Q1. The usual tell me about yourself and some casual conversation.
Add your answer

60 min hackerrank test,with one mysql medium difficulty question and one python medium/little hard level difficulty

Q1. Technical covering each topic from stats, python, ml, dl, nlp,project
Add your answer

Q1. Project-related in-depth discussion, few case scenarios, stats question
Add your answer

General maths n reasoning ques

1 DSA medium level question were asked

Any random topic that we have to speak upon

Q1. Discussed everything written in the resume
Add your answer
Q2. Skillsets written in resume
Add your answer

Q1. Base SAS questions related to PDV, Data pre-processing, merging, character function and SAS macros.
Add your answer

Q1. SAS and data science python questions. Project done in the previous company. What was the problem and how did you solve that give the details.
Add your answer
Q2. I have worked on the Life sciences domain so questions were related to how to add the value to the business. How to initiate POC to client.
Add your answer