Business Intelligence with Microsoft Power BI - with Material - Merging Data from Different Data Sources
Interactive Video
•
Information Technology (IT), Architecture, Social Studies
•
University
•
Hard
Wayground Content
FREE Resource
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.
Read more
1 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
What new insight or understanding did you gain from this video?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
