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 10 meses 28 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

  • 1164
  • 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?