1) What is the purpose of using Power BI “Dataflows”?

2) In Power BI, what does “Append Queries” do?

3) Which visual type is ideal for visualizing large datasets and finding correlations?

4) What is the primary use of the “What If” parameter in Power BI?

5) Which DAX function would be used to find the average of a specific column?

6) What does the “Publish to Web” option in Power BI allow users to do?

7) What is the purpose of “Conditional Formatting” in Power BI?

8) What does the “Quick Measure” feature in Power BI do?

9) Which DAX function would you use to create a calculation that dynamically adjusts based on filters applied in the report?

10) In Power BI, which of the following options is best suited for handling a many-to-many relationship between two tables?

11) What is the purpose of the USERELATIONSHIP function in DAX?

12) Which DAX function would you use to calculate a value as of the end of the last quarter?

13) In Power BI, how can you improve the performance of reports with large datasets?

14) What is the purpose of the “Incremental Refresh” feature in Power BI?

15) Which DAX function is suitable for calculating the difference in days between two dates while ignoring weekends?

16) In Power BI, which scenario would benefit most from using a “Composite Model”?

17) What is the primary use of the “ALLSELECTED” function in DAX?

18) Which DAX function would you use to return the month name from a date column?

19) In Power BI, what does “Field Parameters” allow users to do in a report?

20) What is the primary benefit of using “DirectQuery” over “Import” mode?