Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power Query - Advanced Microsoft Excel
Rating: 4.6 out of 5(822 ratings)
15,097 students

Power Query - Advanced Microsoft Excel

Connect, collect and clean data without writing code.
Created byetrainingdeck Canada
Last updated 12/2021
English
English [Auto],

What you'll learn

  • How to import data from multiple source and perform ETL [Extract, Transform and Load] process to sanitize data.
  • How to establish link with existing reports to collect data without disturbing look and structure of your report.
  • Transform data, merge tables, apply conditional logics to group and summarize large datasets.
  • Automate data import & ETL process and get latest and real time information with just one click.

Course content

2 sections • 9 lectures • 1h 52m total length

  • Modern Challenges for Everyone6:10

    Explore how to connect to scattered data sources, collect and analyze information, and communicate insights using Excel's Power Query, Power Pivot, and Power Map for smarter business decisions.

  • What is Power Query?4:06

    Power Query enables you to connect to almost any data source, extract, transform, and clean data, and load results into Excel tables, Power Pivot, or Power BI for analysis.

Requirements

  • Working knowledge of Microsoft Excel.

Description

Our data sources are scattered and dynamic. To connect, collect and clean the data is a time consuming and tedious task. Power Query is a data connection technology that enables you to discover, connect, combine, and refine data sources.

Power Query is a data transformation tool that helps to connect almost any data source and transform data using user-friendly features with just one click and no coding. You import and clean millions of records and load them to data model for data analysis and reporting.

Business users spend up to 80 percent of their time on data preparation, which delays the work of analysis and decision-making. Several challenges contribute to this situation, and Power Query helps address many of them.

The Power Query Editor is the primary data preparation experience, where you can connect to a wide range of data sources and apply hundreds of different data transformations by previewing data and selecting transformations from the UI. These data transformation capabilities are common across all data sources, whatever the underlying data source limitations.

When you create a new transformation step by interacting with the components of the Power Query interface, Power Query automatically creates the M code required to do the transformation so you don't need to write any code.


Who this course is for:

  • Advanced Microsoft Excel Users

Report abuse