Sr Data Analyst Interview Questions

2,956 sr data analyst interview questions shared by candidates

Technical Round: Power BI theoretical and practical questions like PBI components, power query, power pivot, how to create calculate column and measure, explain about sumx, rolling avg, variables and their syntax, etc. SQL: theoretical and practical questions on window functions, joins, aggregates, etc.
avatar

Senior Data Analyst

Interviewed at CGI

3.7
Feb 27, 2024

Technical Round: Power BI theoretical and practical questions like PBI components, power query, power pivot, how to create calculate column and measure, explain about sumx, rolling avg, variables and their syntax, etc. SQL: theoretical and practical questions on window functions, joins, aggregates, etc.

On power day, 2 case study rounds where the interviewer will provide case details and ask series of questions about the problem and data (give accurate answers and reasoning for your answer). In Data challenge round you have to explain the process and idea behind how you solved the challenge, then you will have series of questions based on your approach and explanation (e.g. why PCA ?, difference in weights obtained in manual and PCA?). Last is behavioral round.
avatar

Sr Data Analyst

Interviewed at Capital One

5
Jul 23, 2025

On power day, 2 case study rounds where the interviewer will provide case details and ask series of questions about the problem and data (give accurate answers and reasoning for your answer). In Data challenge round you have to explain the process and idea behind how you solved the challenge, then you will have series of questions based on your approach and explanation (e.g. why PCA ?, difference in weights obtained in manual and PCA?). Last is behavioral round.

Viewing 791 - 800 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 2,956 interview questions and reports from Sr data analyst interviews. Prepare for your interview. Get hired. Love your job.