Description

Power Query

Free tool part of Excel and Power BI What is it for? Automate manual and repetitive tasks Solve data analysis problems that require complex formulas Easy to import and transform data in ways Excel finds hard Designed to pull data from a source Modify it Return the modified version What you can do with Power Query?

Import data from different sources Transform and clean data Load data as a basis for reports Import data from different sources

Another workbook Text file Folder Sharepoint drive Databases … Example

Can make a PivotTable from 50 million records Power Query Editor

Graphical script editor Part of Excel and Power BI Course Curriculum

Advanced topics in Power Query and M. Experience

Excel experience recommended No Power Query or programming experience required Programming experience will help What You’ll Need

A PC computer Power Query isn’t available on Excel for Mac What You’ll Need

A free trial or paid license of Excel https://go.microsoft.com/fwlink/p/?LinkID=403802

• 1. 0 - Course Overview
  • Clean and Transform Data | Advanced Excel Power Query and M | 0.0

    4:09

  • Clean and Transform Data | What are Power Query and M | 0.1

    8:15

• 2. 1 - Build expressions with let
  • Clean and Transform Data | Build Nested Let Expressions | 1.1

    3:54

  • Clean and Transform Data | Build a List with a Sequence | 1.2

    2:43

  • Clean and Transform Data | Build an Unnamed Record | 1.3

    4:14

• 3. 2 - Build expressions with each
  • Clean and Transform Data | Work with the Each Keyword | 2.1

    5:00

  • Clean and Transform Data | Generate a List | 1.2

    5:41

  • Clean and Transform Data | Find an Entry in a Record | 1.3

    2:17

  • Clean and Transform Data | Select Items From a List | 1.4

    5:07

  • Clean and Transform Data | Serialize a Column | 1.5

    13:44

  • Clean and Transform Data | Find Best Match of Values | 1.6

    21:50

• 4. 3 - Build M functions to perform tasks
  • Clean and Transform Data | Build a Function | 3.1

    3:21

  • Clean and Transform Data | Build a Closure | 3.2

    6:28

  • Clean and Transform Data | Build a Function in a Record | 3.3

    4:24

  • Clean and Transform Data | Count Fibonacci Numbers With a Recursive Function | 3.4

    7:05

  • Clean and Transform Data | Remove HTML Tags | 3.5

    9:20

  • Clean and Transform Data | Build A For Each Loop | 3.6

    9:38

• 5. 4 - Work with tables in M
  • Clean and Transform Data | Select a Column From a Table | 4.1

    3:41

  • Clean and Transform Data | Select a Value at a Row and Column | 4.2

    3:05

  • Clean and Transform Data | Select Row Where a Condition is Met | 4.3

    3:54

  • Clean and Transform Data | Cross Join Tables | 4.4

    8:40

  • Clean and Transform Data | Join Tables on a Key | 4.5

    5:49

  • Clean and Transform Data | Change Column Types | 4.6

    3:49

  • Clean and Transform Data | Fill a Table With Random Values | 4.7

    7:12

• 6. 5 - Pivot a table
  • Clean and Transform Data | What is Pivoting | 5.0

    1:28

  • Clean and Transform Data | Pivot a Table | 5.1

    12:05

• 7. 6 - Build expressions with evaluate
  • Clean and Transform Data | Build an Expression with Evaluate | 6.1

    3:06

  • Clean and Transform Data | Build a Nested Evaluate Expression | 6.2

    3:04

  • Clean and Transform Data | Use Global Library Functions | 6.3

    2:27

• 8. 7 - Work with matrices in M
  • Clean and Transform Data | How to Multiply Matrices | 7.0

    3:03

  • Clean and Transform Data | Build Matrices in M | 7.1

    4:32

  • Clean and Transform Data | Multiply Matrices | 7.2

    17:46