Self-review: Configure data sources :Deploy and Maintain Power BI Assets and Capstone project (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

What was the purpose of selecting the Whole Number data type for the OrderID column in the Tailwind Traders Sales data?

✅ To ensure every OrderID is consistent and avoids any reporting error
❌ To allow OrderID to have decimal values for more granularity
❌ To convert the OrderID into a textual format for better readability

Explanation:
OrderID is an identifier, not a value for calculations. Setting it as a Whole Number ensures consistency, prevents invalid decimal values, and avoids reporting or relationship issues in Power BI.

Question 2

True or False: When configuring the Purchases dataset, ensuring the Valid percentage is less than 100% in the Column Quality pane indicated no errors or empty cells needed addressing in the ReturnStatus column.

❌ True
✅ False

Explanation:
A Valid percentage less than 100% means there are errors or empty (null) values in the column. If there were no issues, the Valid percentage would be 100%.

Question 3

What purpose did the Python script serve in the exercise?

❌ To ensure data consistency and integrity for datasets.
❌ To assist in the extraction of specific data elements from datasets.
✅ To transform and refine the historical currency exchange data.

Explanation:
The Python script was used to process, clean, and refine historical currency exchange data, making it suitable for accurate analysis and conversion in the dataset.

🧾 Summary Table