Introduction to Power Query

Introduction to Power Query in Excel

Lyndsay Girard

Performance Analytics Consultant

What is Excel Power Query?

• Powerful tool built into Microsoft Excel (and Power BI)!
• Enables efficient data import, transformation, and loading.
• Simplifies manual processes.
• User-friendly interface.

Excel Workbook vs Power Query Editor

Excel Workbooks:

• Spreadsheet software.
• Manual data entry and formatting.
• Ideal for conducting analysis, reporting, and visualization.

Excel Power Query Editor:

• Add-in within Excel.
• Integrated data processing and transformation.
• Facilitates data workflows.

The Power of Power Query

The Power of Power Query

The Power of Power Query

ETL in Excel Power Query

ETL in Excel Power Query

ETL in Excel Power Query

Data Sources

• Daily census activities
• Drug administration transactions
• Patient Experience Survey questionnaire
• Patient Experience Survey responses

Let's practice!

Introduction to Power Query in Excel