Conteúdo do Curso
Data Analysis with Excel
Data Analysis with Excel
Data Merging
Data merging involves changing the structure of data to make it more suitable for analysis. This process is crucial for several reasons:
- Converts data into formats that are easier to analyze and visualize;
- Enables deeper insights by structuring data to support specific analytical goals.
Task
Now lets practise these techniques:
- Merge Branches and Sales tables by Branch_ID to add the Location column to each sale. Here's how it should look like:
Note
During the merging process, you can delete unnecessary columns and rearrange the remaining ones as needed until you select the Close & Load button.
- Append the extra data to the Products column. You can download them here:
Obrigado pelo seu feedback!