Power BI MOOC. Initial example, part 1. Data loading | 8/136 | UPV
Title: Power BI MOOC. Initial Example Part 1: Data Loading
Self-description: This video explains how to load and manipulate data from two web sources using analytics software to analyze the best and worst states for retirement in a country. Initially, information is obtained from a table on a web page, and then another table is added from an online encyclopedia containing the abbreviated codes for each state.
It demonstrates the use of a query tool to clean and prepare the data: unnecessary rows and columns are removed, irrelevant content is filtered, and field data types are adjusted. Data is removed from a capital district, saving only the column with the state name and its corresponding code.
The information from both tables is then combined using a left outer join process, associating matching records from both sources. During the process, emphasis is placed on selecting the correct fields to ensure only the necessary data is added.
Finally, it demonstrates how to use the resulting table to create a chart in the software, indicating the overall classification and associating each status with its corresponding code. It also mentions the possibility of establishing automatic relationships between common fields in tables, although this time it focuses on working with a single table.
Author: Despujol Zabala Ignacio
Course: This video is 8/136 of the Power BI MOOC course. • MOOC Power BI
Register at: https://www.edx.org/es/professional-c...
Universitat Politècnica de València (UPV): https://www.upv.es
More videos at: / valenciaupv
Access our MOOCs: https://upvx.es
#Power BI #Desktop #load #data