1. Walk me through your profile?
2. Could you please explain your latest project what kind of impact you have created what was problem for that? and tools and technology you have used? what was the data sources you have used in that?
3. what is your skillsets?
4. What type of connections you have used while connecting to power bi?
5. What is a disadvantage of import query mode? what is the size limit to import data in power bi for import mode?
6. Have you worked with parameter in power bi? what’s a usecase of parameter in power query?
7. How to calculate calendar table in parameter?
8. ππππ§ππ«π’π¨: Suppose you developed a report in a development environmentβhow would you switch it to UAT or production?
9. Explain the workflow of power bi project end to end?
10. ππππ§ππ«π’π¨: Let’s say you are working on prod data and you made a mistake and what is the steps you will do to come this problem?
11. ππππ§ππ«π’π¨: You can add a new column using either Power Query or DAX. Which method would you prefer and why?
12. Have you added any new column in your project and what approach you have used to add a new column?
13. let’s say we have complex logic I want to create a column based on multiple conditions can it will be possible in Power Query?
14. Have you worked on data modeling in Power BI? How do you manage complex data models?
15. We have many to many relationship between two tables and it causes a performance issue? what steps you will take to tackle this problem?
16. Have you faced circular dependency error problem while creating a DAX?
17. We have a table that has huge data let’s say in millions, how would you tackle this table to speed up the performance of that only for the table not for report?
18. Have you worked report level security in the power bi? how we can control access of the user in the report?
19. Have you worked with page level security in power bi?
20. What is Month-over-Month (MoM) growth, and how would you write a DAX formula for it?
21. How would you rate yourself in SQL out of 5?
22. Have you worked with window functions in SQL?
23. What is difference between LEAD and LAG?
24. Tell me the output for this Query?
Select ID, sum(sales) from table
where sum(sales) > 10000
25. What is the order of execution in the SQL?
26. How do you handle NULL values in SQL?
27. Explain what Row-Level Security (RLS) is and how you would implement it in Power BI.
29.Β How do you optimize a large Power BI report that is running slowly, Data models for performance?
30.Β How do you handle incremental data loads, validate data accuracy when building visualizations in Power BI?
31.Β How do you handle many-to-many relationships, calculate running totals in Power BI using DAX in Power BI?
32.Β How do you merge and append queries, perform data transformation in Power BI using Power Query?
33. Do you have any questions?
