Business Intelligence with Microsoft Power BI - with Material - Merging Data from Different Data Sources

The video tutorial explains how to merge data from different sources using Power BI. It begins with an overview of various data sources like Excel, CSV, SQL, and Hadoop. The tutorial then demonstrates how to prepare and load data files into Power BI, specifically focusing on a master Excel file and a transactional CSV file. Finally, it details the steps to merge these files using Power BI's query editor, highlighting the use of a left outer join to bring a salary column from the master table into the transactional table.

What are the two types of files used in the example for merging data?

• Excel and CSV

• SQL and Oracle

• CSV and SQL

• Excel and SQL

What is the main objective when transferring data between the Excel and CSV files?

• To create a new CSV file

• To delete unnecessary data from the CSV file

• To add a new column to the Excel file

• To transfer the salary column to the transactional table

Which tool is used to merge the data from Excel and CSV files?

• Power BI

• SQL Server

• Oracle

• Microsoft Excel

What type of join is used to merge the salary column into the transactional table?

• Inner join

• Right outer join

• Left outer join

• Full outer join

In Power BI, what is the first step to load the Excel file?

• Click on 'New Source' and select 'CSV'

• Click on 'Transform Data' and select 'SQL'

• Click on 'Merge Queries' and select 'Excel'

• Click on 'Get Data' and select 'Excel'