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. Delete duplicates, SCD types , datawarehousing concepts
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

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. All about my previous projects and questions based on that. Also, they checked the knowledge of Generative AI & LLM.
Add your answer

Q1. All about my previous projects and questions based on that. It was a techno-managerial round which was also focused on situation based scenarios. Taken by Head of AI/ML - CoE.
Add your answer