1) How does “Dual Storage Mode” benefit Power BI composite models?

2) What is the benefit of setting up aggregations in Power BI models?

3) In Power BI, what does using the “Summarize” function in DAX accomplish?

4) What does the DAX function “REMOVEFILTERS” achieve in a calculation?

5) Which tool would best help you identify slow-performing visuals in a Power BI report?

6) How does “Dynamic Row-Level Security” in Power BI function?

7) Which DAX function can be used to return a filtered table that only contains rows matching a specified condition?

8) What does the “Optimize” button in Power BI’s Power Query do?

9) Which DAX function is appropriate for returning the highest value in a column that meets a specific condition?

10) What is the function of the “Drillthrough” feature in Power BI?

11) How does using the “Combine Files” feature in Power Query help with folder data sources?

12) Which DAX function should you use to find the unique count of a specific column?

13) You are creating a Power BI report for a retail company with sales data from multiple stores across regions. What steps would you take to ensure that sales performance comparisons are accurate across all regions and seasons?

14) You have a dataset with employee information, including each employee’s department, hire date, and salary. How would you calculate the total annual salary expense for each department?

15) A client requests a Power BI dashboard to track website performance, including monthly traffic, bounce rate, and conversion rate. Data is updated daily. How would you set up your model to ensure efficient data refresh and minimize load times?

16) For a supply chain project, you are asked to track order fulfillment times. The data includes order date, shipment date, and delivery date. What DAX measure would you create to calculate the average time taken to deliver an order once shipped?

17) You are tasked with building a Power BI report that tracks product sales by category, with a filter for top 5 best-selling products within each category. How would you implement this?

18) In a project tracking report, you need to calculate the percentage of completed tasks within each project. Task statuses include “Not Started,” “In Progress,” and “Completed.” How would you implement this metric?

19) You are building a report that needs to display sales growth on a monthly basis but should compare this to the same month of the previous year. What DAX function would you use to accomplish this?

20) A sales report requires showing the average order value, defined as total sales divided by the number of orders. The dataset includes a sales amount column and an order ID column. What is the best way to calculate average order value?