Power BI Interview Questions Asked Bajaj Auto Ltd

1. Self Introduction
2. What are your roles and responsibilities of your project?
3. Difference between Import Mode and Direct Mode?
4. What kind of projects have you worked on Domain?
5. How do you handle complex data transformations in Power Query? Can you provide an example of a challenging transformation you implemented?
6. What challenges you faced while doing a projects?
7. Types of Refreshes in Power BI?
8. What is DAX in Power BI?
9. How do you perform data cleansing and transformation in Power BI?
10. How do you connect to data sources in Power BI?
11. What are the components in Power BI?
12. What is Power Pivot will do in Power BI?
13. Write a query to fetch top 5 employees having highest salary?
14. Write a query to find 2nd highest salary from employee table?
15. Difference between Rank function & Dense Rank function in SQL?
16. Difference between Power BI Desktop & Power BI Service?
17. How will you optimize Power BI reports?
18. What are the difficulties you have faced when doing a projects?
19. How can you optimize a SQL query?
20. What is Indexes?
21. How ETL process happen in Power BI?
22. What is difference between Star schema & Snowflake schema and how will know when to use which schemas respectively?
23. How will you perform filtering & it's types?
24. What is Bookmarks?
25. Difference between Drilldown and Drill through in Power BI?
26. Difference between Calculated column and measure?
27. Difference between Slicer and Filter?
28. What is a use Pandas, Matplotlib, seaborn Libraries?
29. Difference between Sum and SumX?
30. Do you have any questions?