Instructions:
Use the Fact and Dimension Data Set to answer the following questions. Perform the necessary calculations and transformations in Power BI.

1. Measure Calculation: Create a Total Profit measure using the fact table. What is the correct DAX formula to achieve this? (100 to 1,200 characters) *

2. Measure Calculation: Compute the Average Quantity from the fact table. Which DAX function is most appropriate for this calculation? (100 to 1,200 characters) *

3. Measure Calculation: Derive an Average Sales measure. How would you write the DAX expression for this? (100 to 1,200 characters) *

4. Measure Calculation: Count the Total Products in the dataset. Which function should be used to ensure unique product count? (100 to 1,200 characters) *

5. Calculated Column: Create a Sales Category column using the IF logical function:
o Sales < 100 → "Low Sales"
o Sales between 100 and 5,000 → "Mid Sales"
o Sales > 5,000 → "High Sales"
Provide the correct DAX formula for this transformation. (100 to 1,200 characters) *

6. Data Transformation: Convert all Customer Names to uppercase. What function should be used in Power BI to achieve this? (100 to 1,200 characters) *

7. Filtering Data: Apply a filter to the Fact Order table to only include rows where Ship Mode is “First Class.” How can this filter be applied using Power Query? (100 to 1,200 characters) *

8. Filtering Data: Modify the Dim Product table to display only rows where Sub-Category is “Office Supplies.” What Power BI transformation method should be used to achieve this? (100 to 1,200 characters) *

Bonus Question:
9. Explain the difference between Measures and Calculated Columns in Power BI. Provide an
example of when you would use each. (100 to 1,200 characters) *

This quiz is designed to test your ability to apply DAX calculations, use logical functions, and apply
transformations in Power BI. Good luck! (100 to 1,200 characters) *

DATA ANALYSIS - POWER BI

Power BI 4 – Quiz