1

Step 1

Section 1: Introduction

2

Step 2

******* POWER QUERY ESSENTIALS *******

3

Step 3

The Power of Power Query

4

Step 4

Important Power Query Tips & Tricks

5

Step 5

Helpful Power Query Transformations

6

Step 6

Powerful Power Query Transformations

7

Step 7

Date & Time Transformations

8

Step 8

Custom Column & Basic M Manipulation

9

Step 9

Power Query Online Data Sources (Online)

10

Step 10

Combining / Appending Data

11

Step 11

PROJECT Report on HR Data

12

Step 12

Merge Options – Join Kind Options Explained

13

Step 13

When to Use Power Pivot & Load to Data Model

14

Step 14

******* POWER QUERY ADVANCED TO PRO *******

15

Step 15

Solving Complex Data Analysis Problems with Merge

16

Step 16

Advanced Problem Solving using the Power Query Interface

17

Step 17

PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

18

Step 18

Understanding The M Formula Language (Let, Lists, Records & Improving Performance)

19

Step 19

Working With List & Table Functions

20

Step 20

Creating & Invoking Custom Functions

21

Step 21

Flexible Importing of Data with the Help of M Functions

22

Step 22

PROJECT – Power Query and Power BI

23

Step 23

Final Words

1

Step 1

Section 1: Introduction

2

Step 2

******* POWER QUERY ESSENTIALS *******

3

Step 3

The Power of Power Query

4

Step 4

Important Power Query Tips & Tricks

5

Step 5

Helpful Power Query Transformations

6

Step 6

Powerful Power Query Transformations

7

Step 7

Date & Time Transformations

8

Step 8

Custom Column & Basic M Manipulation

9

Step 9

Power Query Online Data Sources (Online)

10

Step 10

Combining / Appending Data

11

Step 11

PROJECT Report on HR Data

12

Step 12

Merge Options – Join Kind Options Explained

13

Step 13

When to Use Power Pivot & Load to Data Model

14

Step 14

******* POWER QUERY ADVANCED TO PRO *******

15

Step 15

Solving Complex Data Analysis Problems with Merge

16

Step 16

Advanced Problem Solving using the Power Query Interface

17

Step 17

PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

18

Step 18

Understanding The M Formula Language (Let, Lists, Records & Improving Performance)

19

Step 19

Working With List & Table Functions

20

Step 20

Creating & Invoking Custom Functions

21

Step 21

Flexible Importing of Data with the Help of M Functions

22

Step 22

PROJECT – Power Query and Power BI

23

Step 23

Final Words

03 January 2021

Goal abandoned

The author does not write in the goal 1 year 1 month 4 days

Goal author

Aracari

Russia, Калининград

32 years old

General

Пройти курс Master Excel Power Query

Купила курс на новогодней распродаже Master Excel power query

Посмотрела превью к курсу, обещает быть интересно. Преподаватель: Leila Gharani, безумно очаровательная женщина, есть свой канал на youtube.

В курсе 23 раздела. В начале курса предлагают скачать архив всех материалов курса, включая и готовые решения.

Просматривая видео уже понятно, что освоив надстройку Power query можно в разы облегчить себе работу и сэкономить кучу времени, если правильно автоматизировать этот процесс. Я уже вижу некоторые решения при формировании своих ежемесячных отчётов для руководителей.

Всего 180 лекций. Общее время прохождения: 16:36:21

 Goal Accomplishment Criteria

Получен диплом о прохождении курса на Udemy

  1. Section 1: Introduction

    4 lectures 10:42

  2. ******* POWER QUERY ESSENTIALS *******

    3 lectures 06:32

  3. The Power of Power Query

    11 lectures 01:10:35

  4. Important Power Query Tips & Tricks

    12 lectures 56:16

  5. Helpful Power Query Transformations

    10 lectures 58:20

  6. Powerful Power Query Transformations

    12 lectures 01:11:41

  7. Date & Time Transformations

    6 lectures 36:11

  8. Custom Column & Basic M Manipulation

    9 lectures 42:24

  9. Power Query Online Data Sources (Online)

    9 lectures 37:28

  10. Combining / Appending Data

    11 lectures 01:13:18

  11. PROJECT Report on HR Data

    5 lectures 20:52

  12. Merge Options – Join Kind Options Explained

    12 lectures 01:03:15

  13. When to Use Power Pivot & Load to Data Model

    7 lectures 37:18

  14. ******* POWER QUERY ADVANCED TO PRO *******

    2 lectures 02:05

  15. Solving Complex Data Analysis Problems with Merge

    7 lectures 36:44

  16. Advanced Problem Solving using the Power Query Interface

    6 lectures 36:46

  17. PROJECT – Create a Modern Excel Dashboard with Power Query & Pivot Tables

    14 lectures 01:19:11

  18. Understanding The M Formula Language (Let, Lists, Records & Improving Performance)

    13 lectures 01:43:37

  19. Working With List & Table Functions

    5 lectures 39:18

  20. Creating & Invoking Custom Functions

    5 lectures 27:03

  21. Flexible Importing of Data with the Help of M Functions

    7 lectures 47:48

  22. PROJECT – Power Query and Power BI

    7 lectures 35:19

  23. Final Words

    3 lectures 03:32

  • 323
  • 03 January 2021, 13:49
Sign up

Signup

Уже зарегистрированы?
Quick sign-up through social networks.
Sign in

Sign in.
Allowed.

Not registered yet?
 
Log in through social networks
Forgot your password?