Answer-first summary for fast verification
Answer: Use the 'Get Data' feature to connect to the data sources, transform and clean the data using Power Query, and combine the data using the 'Merge Queries' feature, then create relationships between the data tables.
The most comprehensive approach involves not only importing the data but also transforming and cleaning it to ensure consistency and accuracy. Additionally, establishing relationships between the data tables is crucial for a meaningful analysis. Option D covers all these steps, making it the correct choice. Options A, B, and C each miss one or more critical steps in the process.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with creating a Power BI Desktop project (.pbix) to analyze sales data from multiple sources, including SQL Server and Excel files. The project must ensure data consistency and accuracy for reliable analysis. Considering the need for data transformation, cleaning, and the establishment of relationships between data tables, which of the following steps is the MOST comprehensive approach to achieve this goal? (Choose one option from A to D)
A
Use the 'Get Data' feature in Power BI Desktop to connect to the SQL Server and Excel files, and import the required data tables without any further steps.
B
Create a new folder on your machine, copy the Excel files, and import them into Power BI Desktop as data sources, then manually adjust the data in Power BI.
C
Use Power Query in Power BI Desktop to transform and clean the data from both SQL Server and Excel files, ensuring consistency and accuracy, but do not establish any relationships between the data tables.
D
Use the 'Get Data' feature to connect to the data sources, transform and clean the data using Power Query, and combine the data using the 'Merge Queries' feature, then create relationships between the data tables.
E
All of the above
No comments yet.