In this section, we'll practice connecting to websites. We can only retrieve data from web pages that contain tabular data. A key advantage of this approach is that if the data on the webpage is periodically updated, the data in Power Query will automatically update as well.

We'll practice extracting a table from this web resource:

<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <link
      rel="stylesheet"
      href="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.css"
    />
    <link
      rel="stylesheet"
      href="https://content-media-cdn.codefinity.com/courses/c1087363-9025-4c37-8d5e-983a32a007e9/text-boxes-section/copyable-text-box.css"
    />
  </head>
  <body>
    <div class="text-widget">
      
      <input type="text" class="text-field" id="widget1-text" value="https://www.ecb.europa.eu/stats/policy_and_exchange_rates/euro_reference_exchange_rates/html/index.en.html" />
      <button class="copy-button" onclick="handleClick('widget1-text', 'widget1-notify')">
        <svg width="20" height="20" viewBox="0 0 32 32" xml:space="preserve">
          <g>
            <path
              d="m26.121 6.707-3.828-3.828A2.98 2.98 0 0 0 20.172 2H12a3.003 3.003 0 0 0-3 3v1H8a3.003 3.003 0 0 0-3 3v18a3.003 3.003 0 0 0 3 3h12a3.003 3.003 0 0 0 3-3v-1h1a3.003 3.003 0 0 0 3-3V8.829a2.982 2.982 0 0 0-.879-2.122ZM22 5.414 23.586 7H22ZM20 28H8a1.001 1.001 0 0 1-1-1V9a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1ZM18 9.414 19.586 11H18ZM24 24h-1V12.829a2.982 2.982 0 0 0-.879-2.122l-3.828-3.828A2.98 2.98 0 0 0 16.171 6H11V5a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1Zm-6-8h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Z"
              fill="#a6b8e6"
            ></path>
          </g>
        </svg>
      </button>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.js"></script>
    <script src="https://content-media-cdn.codefinity.com/courses/c1087363-9025-4c37-8d5e-983a32a007e9/text-boxes-section/copyable-text-box.js"></script>
  </body>
</html>

If you need a step-by-step guide, here’s a <a 
href="https://docs.google.com/document/d/1VJEMcE4iRF1ilLkLIyykB7mz0Dwc2vXXWw1sVkcx6NE/edit?usp=sharing"
target="_blank"
style="color: #ff8a00; font-weight: 600; text-decoration: none; transition: 0.3s ease-in-out;"
onmouseover="this.style.color='#ff0000'"
onmouseout="this.style.color='#d27204'">e-book</a> for you.

This advanced course will guide you from preparing raw data for analysis to building an automated dashboard. You will learn how to calculate the Profits & Losses for a small business, "The Artisan Bakery". Dive deep into the essentials of business analytics with practical, real-world applications and transform data into insightful, actionable outcomes.

Prepare to discover the fundamentals of Power Query, including navigating the Get Data tab, establishing connections with databases and Excel workbooks, and effectively merging queries to streamline your data processing tasks.

You will dive deeper into Power Query's capabilities by connecting and integrating data from CSV files and folders. This section will guide you through adding custom columns, merging data sources, handling errors gracefully, and efficiently grouping and unpivoting columns to prepare data for advanced analysis.

The section covers advanced data preparation, relationship building, and calculation methods using Power Pivot.

Delve into creating a highly automated and interactive dashboard from start to finish. We explore advanced features such as pivot charts, KPI integration, and slicers to enhance functionality and user interaction. 

Discover advanced functions to create an interactive and automated report for calculating key financial metrics on a monthly basis.

Connecting to the Web

Awesome!

Connecting to the Web