Skip to contentSkip to footer

Data Analyst Intern Interview Questions

Salaries
Interviews

2,102 data analyst intern interview questions shared by candidates

Some things I remember: 1. Mention a project you’re most proud of and what you achieved. How were you able to do it, and what challenges did you face . Follow up: how did you figure out there was a need for this project. -What steps did you go through from ideation to implementation? -what was the feedback like? 2. How would you communicate insights to stakeholders 3. How would you approach a data analysis project? Follow-up: if you had two datasets, with the same columns, how would you clean it up? How would you communicate your findings to a technical and non-technical audience? And so many other data-related questions. 4. How did you hear about Scottish water and what motivated you to apply? -what motivated you to apply for the data analysis intern role? 5. Describe a situation where you interfaced with a customer who had issues, how did you resolve it and what results did you achieve from the experience? 6. What skills do you have that are relevant to this role and how would you add value and stand out? 7. How would you foster open communication between team members and other teams? Follow-up questions from my response were asked (I can’t remember all) 8. Is there any other thing you haven’t mentioned in this interview that you think will add value and help your application? 9. Do you have any questions for us?
avatar

Data Analyst Graduate Intern

Interviewed at Zopa

3.3★
Oct 12, 2024

Some things I remember: 1. Mention a project you’re most proud of and what you achieved. How were you able to do it, and what challenges did you face . Follow up: how did you figure out there was a need for this project. -What steps did you go through from ideation to implementation? -what was the feedback like? 2. How would you communicate insights to stakeholders 3. How would you approach a data analysis project? Follow-up: if you had two datasets, with the same columns, how would you clean it up? How would you communicate your findings to a technical and non-technical audience? And so many other data-related questions. 4. How did you hear about Scottish water and what motivated you to apply? -what motivated you to apply for the data analysis intern role? 5. Describe a situation where you interfaced with a customer who had issues, how did you resolve it and what results did you achieve from the experience? 6. What skills do you have that are relevant to this role and how would you add value and stand out? 7. How would you foster open communication between team members and other teams? Follow-up questions from my response were asked (I can’t remember all) 8. Is there any other thing you haven’t mentioned in this interview that you think will add value and help your application? 9. Do you have any questions for us?

𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 𝗘𝗱𝗶𝘁𝗼𝗿 (𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗘𝗧𝗟) 1. What did you do with your project and what are your roles & responsibilities? 2. What are the transformations used in your project? 3. What are the different sources you have used in your project? 4. What is the difference between Import Mode and Direct Query? 5. What is the Fact table and Dimension table? 6. Difference between Star Schema and Snowflake Schema? 7. What is Merge and Append in the power query editor? 8. What are the building blocks of Power BI? 9. What is Query Folding in Power Query? 10. What is Power BI Q&A? 11. What are the components of Power BI? 12. What is Conditional Formatting in Power BI? 13. How do you handle errors in Power Query? 14. Three processes to replace and replaces null values? 15. Difference between referencing and duplicating a query in Power Query. 16. What is the M language, and how does it relate to Power Query? 17. How do you schedule data refreshes in Power Query? 18. What are custom columns in Power Query, and how do you create them? 19. What is the 'Group By' function in Power Query, and how is it used? 20. Explain how to remove duplicates from a dataset in Power Query. 𝗣𝗼𝘄𝗲𝗿 𝗩𝗶𝗲𝘄 / 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 1. What are the charts you have used in your project? 2. Any Custom Charts you have used? 3. What is the difference between Filters and Slicers? 4. What are Bookmarks in Power BI? 5. How can you make your reports dynamic? 6. Types of relationship in Power BI? 7. What are Drillthrough and Drilldown in Power BI? 8. How do you optimize the performance of a Power BI report? 9. How do you handle large datasets in Power BI Desktop? 10. Difference between Tile vs Report vs Dashboard ? 𝗗𝗔𝗫 1. What is the difference between Measures and Calculated Column? 2. What are DAX functions you have used in your project? 3. What is the difference between SUM and SUMX? 4. What is the use case of the SUMMARIZE function? 5. What is ALL and ALLEXCEPT function? 6. What is the need for a Data Master Table? 7. Can you explain the use case of SAMEPERIODLASTYEAR? 8. What is Row Context in DAX? 9. What do you mean by MTD , QTD & YTD? 10. Difference between Sum vs SumX? 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗦𝗲𝗿𝘃𝗶𝗰𝗲𝘀 1. Which Power BI License you have used in your project? 2. What is the Difference between MyWorkspace and Workspace? 3. What are the roles available in the workspace? 4. What is RLS? 5. What is Gateway? How many types? 6. Difference between Report and Dashboard? 7. How can you refresh data in Power BI? 8. Explain the concept of Scheduled Refresh and Incremental Refresh? 9. What is Dataflow? 10. How do you share Power BI reports with external users?
avatar

Data Analyst Intern

Interviewed at EY

3.6★
Mar 26, 2025

𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 𝗘𝗱𝗶𝘁𝗼𝗿 (𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗘𝗧𝗟) 1. What did you do with your project and what are your roles & responsibilities? 2. What are the transformations used in your project? 3. What are the different sources you have used in your project? 4. What is the difference between Import Mode and Direct Query? 5. What is the Fact table and Dimension table? 6. Difference between Star Schema and Snowflake Schema? 7. What is Merge and Append in the power query editor? 8. What are the building blocks of Power BI? 9. What is Query Folding in Power Query? 10. What is Power BI Q&A? 11. What are the components of Power BI? 12. What is Conditional Formatting in Power BI? 13. How do you handle errors in Power Query? 14. Three processes to replace and replaces null values? 15. Difference between referencing and duplicating a query in Power Query. 16. What is the M language, and how does it relate to Power Query? 17. How do you schedule data refreshes in Power Query? 18. What are custom columns in Power Query, and how do you create them? 19. What is the 'Group By' function in Power Query, and how is it used? 20. Explain how to remove duplicates from a dataset in Power Query. 𝗣𝗼𝘄𝗲𝗿 𝗩𝗶𝗲𝘄 / 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗗𝗲𝘀𝗸𝘁𝗼𝗽 1. What are the charts you have used in your project? 2. Any Custom Charts you have used? 3. What is the difference between Filters and Slicers? 4. What are Bookmarks in Power BI? 5. How can you make your reports dynamic? 6. Types of relationship in Power BI? 7. What are Drillthrough and Drilldown in Power BI? 8. How do you optimize the performance of a Power BI report? 9. How do you handle large datasets in Power BI Desktop? 10. Difference between Tile vs Report vs Dashboard ? 𝗗𝗔𝗫 1. What is the difference between Measures and Calculated Column? 2. What are DAX functions you have used in your project? 3. What is the difference between SUM and SUMX? 4. What is the use case of the SUMMARIZE function? 5. What is ALL and ALLEXCEPT function? 6. What is the need for a Data Master Table? 7. Can you explain the use case of SAMEPERIODLASTYEAR? 8. What is Row Context in DAX? 9. What do you mean by MTD , QTD & YTD? 10. Difference between Sum vs SumX? 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗦𝗲𝗿𝘃𝗶𝗰𝗲𝘀 1. Which Power BI License you have used in your project? 2. What is the Difference between MyWorkspace and Workspace? 3. What are the roles available in the workspace? 4. What is RLS? 5. What is Gateway? How many types? 6. Difference between Report and Dashboard? 7. How can you refresh data in Power BI? 8. Explain the concept of Scheduled Refresh and Incremental Refresh? 9. What is Dataflow? 10. How do you share Power BI reports with external users?

Viewing 951 - 960 interview questions

Glassdoor has 2,102 interview questions and reports from Data analyst intern interviews. Prepare for your interview. Get hired. Love your job.