Certbie
Question 1 of 30
A retail company has two separate datasets: one containing sales data from physical stores and another containing online sales data. The company wants to analyze the total sales across both channels to understand overall performance. To achieve this, they decide to merge the two datasets using Power BI. The sales data from physical stores includes columns for Store ID, Product ID, and Sales Amount, while the online sales data includes columns for Order ID, Product ID, and Sales Amount. What is the most effective approach to combine these datasets in Power BI to ensure that all sales data is accurately represented and can be analyzed collectively?
Use the "Append Queries" feature to stack the two datasets vertically, ensuring that both datasets have the same column structure for seamless analysis.
Use the "Merge Queries" feature to join the datasets based on Product ID, which will create a new dataset that combines sales amounts from both channels.
Create a new table that manually combines the two datasets by copying and pasting the data into a single Excel sheet before importing it into Power BI.
Utilize the "Group By" function on both datasets separately to summarize sales data before attempting to combine them.

Preparing for Microsoft PL-300 Microsoft Power BI Data Analyst? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free