Power BI test
Bi Engineer Interview Questions
1,658 bi engineer interview questions shared by candidates
All questions were logical and scenario based on the projects.
1. Are you single power bi developer or there is team? 2. How did you get the raw data, from where you get the raw data? 3. Which kind of transformation you perform in raw data? 4. What do you mean by completeness of data? How do you insure completeness of data? 5. Why do you need calculated columns? 6. What is the use of measures and what is difference between them? 7. Which kind of data you have used in power bi? Nature of data? 8. What kind of kpi you have used to get the calculated columns and measures? 9. Why do you use what if parameter? 10. What is field parameter? 11. What is data modelling? 12. Let us suppose you come across many to many relationship, on which column you will create relationship? Sometimes there many too many relationship so how will you resolve this? If there is no date column how will you create relationship? 13. What is star schema and snowflake schema? Which you have used most of the time and why? What is deference b/w them? 14. What is duplicate table and reference table? 15. Let us we have a sharepoint folder? 16. Have you worked on RLA? Differences b/w RLA and Dynamic level security? 17. How will you check RLA? 19. Column profiling and column distribution? 20. What is gateway? 21. Differences b/w licencing in power bi? Pro n Premium with use case? Don’t be generic give some real world example? 22. How do you optimize your report? 24. What is query foldeing? 25. What dax you have used? This was related technical round
How do you handle data modeling in Power BI? Can you explain the process?
What data sources have you connected to using Power BI?
How do you manage and optimize performance in Power BI reports and dashboards?
SQL & Advanced Tableau questions
First round was fairly straight forward tell me about yourself and your projects type questions. Second round was an in-depth take home assessment.
SQL,Linux commands,basic cpp codes and concepts
What are challenges have you faced in your Tech career and how have you resolved it?
Viewing 1571 - 1580 interview questions