1

Etapa 1

Section 1: Introduction

2

Etapa 2

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

3

Etapa 3

The Power of Power Query

4

Etapa 4

Important Power Query Tips & Tricks

5

Etapa 5

Helpful Power Query Transformations

6

Etapa 6

Powerful Power Query Transformations

7

Etapa 7

Date & Time Transformations

8

Etapa 8

Custom Column & Basic M Manipulation

9

Etapa 9

Power Query Online Data Sources (Online)

10

Etapa 10

Combining / Appending Data

11

Etapa 11

PROJECT Report on HR Data

12

Etapa 12

Merge Options – Join Kind Options Explained

13

Etapa 13

When to Use Power Pivot & Load to Data Model

14

Etapa 14

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

15

Etapa 15

Solving Complex Data Analysis Problems with Merge

16

Etapa 16

Advanced Problem Solving using the Power Query Interface

17

Etapa 17

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

18

Etapa 18

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

19

Etapa 19

Working With List & Table Functions

20

Etapa 20

Creating & Invoking Custom Functions

21

Etapa 21

Flexible Importing of Data with the Help of M Functions

22

Etapa 22

PROJECT – Power Query and Power BI

23

Etapa 23

Final Words

1

Etapa 1

Section 1: Introduction

2

Etapa 2

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

3

Etapa 3

The Power of Power Query

4

Etapa 4

Important Power Query Tips & Tricks

5

Etapa 5

Helpful Power Query Transformations

6

Etapa 6

Powerful Power Query Transformations

7

Etapa 7

Date & Time Transformations

8

Etapa 8

Custom Column & Basic M Manipulation

9

Etapa 9

Power Query Online Data Sources (Online)

10

Etapa 10

Combining / Appending Data

11

Etapa 11

PROJECT Report on HR Data

12

Etapa 12

Merge Options – Join Kind Options Explained

13

Etapa 13

When to Use Power Pivot & Load to Data Model

14

Etapa 14

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

15

Etapa 15

Solving Complex Data Analysis Problems with Merge

16

Etapa 16

Advanced Problem Solving using the Power Query Interface

17

Etapa 17

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

18

Etapa 18

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

19

Etapa 19

Working With List & Table Functions

20

Etapa 20

Creating & Invoking Custom Functions

21

Etapa 21

Flexible Importing of Data with the Help of M Functions

22

Etapa 22

PROJECT – Power Query and Power BI

23

Etapa 23

Final Words

03 enero 2021

El objetivo está desatendido

El autor lleva sin comentar el objetivo 7 meses 26 días

Autor del objetivo

Aracari

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

34 año / año / año

General

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

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

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

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

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

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

 Criterio del fin

Получен диплом о прохождении курса на 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

  • 1053
  • 03 enero 2021, 13:49
Registración

Las posibilidades
están ilimitadas.
Es la hora
de descubrir las suyas

Уже зарегистрированы?
Entrada al sitio

Entre.
Está abierto.

¿Aún no está registrado?
 
Conéctese a cualquiera de sus cuentas, sus datos se tomarán de la cuenta.
¿Ha olvidado la contraseña?