**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:
   <img src='https://codefinity-content-media-v2.s3.eu-west-1.amazonaws.com/courses/0328349f-0845-49dc-9814-060940bbcef3/images/1-3+TaskExample.jpg' style=' border: 4px solid #ff8a00; border-radius: 10px; max-width: 100%; width: 100%;'>

   > **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:
<link
  rel="stylesheet"
  href="https://codefinity-content-media-v2.s3.eu-west-1.amazonaws.com/courses/c1087363-9025-4c37-8d5e-983a32a007e9/buttons-section/course-summary.css"
/>

<div class="custom-container">
  <img
    style="width: 64px; height: auto; margin: 0"
    class="pointer"
    src="https://codefinity-content-media.s3.eu-west-1.amazonaws.com/8c50b100-1d6b-4830-a9a4-5fd966c78e38/pointer+figer+image+for+animation+purpose.png"
    alt="Pointer finger"
    width="64px"
  />
  
  <a
    class="custom-download-link"
    href="https://codefinity-content-media-v2.s3.eu-west-1.amazonaws.com/courses/0328349f-0845-49dc-9814-060940bbcef3/datasets/1/Extra Products.csv"
    target="_blank"
    >Extra Products.csv</a
  >
</div>

Where is the branch located that conducted the transaction with ID 420?

How many total products do you have after appending the data to the Product table?

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Learn how to import, clean, and transform data with advanced Excel functions to prepare datasets for in-depth analysis. Master techniques to navigate complex data with lookup functions.

Delve into the core of Excel's analytical power by mastering conditional analyses, statistical functions, and PivotTables. This section teaches you how to extract meaningful insights from large datasets using a variety of analytical tools.

Gain the skills to create statistical charts to build interactive dashboards that communicate data visually. Learn to automate repetitive tasks and generate reports efficiently, enhancing productivity and data interaction.

It covers correlation analysis to determine relationships between variables using Pearson’s correlation coefficient, linear regression to explore variable relationships, the addition of trendlines for pattern analysis in forecasting, and the use of t-tests and z-tests in hypothesis testing to evaluate statistical significance.

Data Analysis with Excel

Data Merging

Task