EY Data Analyst Intern interview questions

𝗣𝗼𝘄𝗲𝗿 𝗤𝘂𝗲𝗿𝘆 𝗘𝗱𝗶𝘁𝗼𝗿 (𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗘𝗧𝗟) 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?

¿Para qué sirve la cláusula WHERE en SQL?