Power Query (Get & Transform) Intro

Last reviewed May 28, 2026 Content v20260528

Track mode

none

Means

Read / quiz

Reading

~1 min

Level

intermediate

This lesson

An orientation to the Excel track—workbooks, formulas, pivots, charts, and analyst workflows you practice in your own spreadsheet app.

Business partners still live in spreadsheets—developers who read formulas catch bugs in exports and speak the same language in reviews.

You will apply Power Query (Get & Transform) Intro in contexts like: Recurring CSV exports from ERP, ads platforms, and warehouse snapshots.

Read the lesson, type formulas in your local Excel or compatible spreadsheet, rebuild examples in excel-practice.xlsx, and complete MCQs—no in-browser runner. Also read the interview prep blocks; sketch Inputs/Calcs/Outputs sheets for a report you know.

When you exchange CSV/xlsx with non-engineers—or before analyst interviews; pair with /sql/intro for warehouse metrics.

Power Query imports, cleans, and reshapes data reproducibly—better than manual copy-paste for recurring reports.

Start

Data → Get Data → From CSV/Database/Workbook. Power Query Editor shows applied steps.

Steps

Remove columns, filter rows, change types
Split/merge columns, unpivot wide to long
Load to worksheet or Data Model

Refresh all

Data → Refresh All reruns queries—automate Monday morning reports.

Important interview questions and answers

Q: Why Power Query?
A: Repeatable ETL inside Excel without re-clicking manual steps.
Q: Unpivot?
A: Turns wide month columns into rows for pivots.

Self-check

What is an applied step?
Why Refresh All matters?

Tip: Rename query steps descriptively—future you debugs faster.

Interview prep

Power Query?: Repeatable import/transform steps.

Discussion

Past discussion is visible to everyone. Only logged-in users can post comments and replies.

Starter discussion topics

Applied steps?
Refresh All?

No discussion yet. Be the first to ask a question.