Power Query pre Power BI
2h 43min
Time
67
Chapters
Business & Finance
Category
4.6
Rating
Beginner
Level
slovak
Language
Chapters
Úvodné nastavenia Power BI a Power Query
Intro kapitoly - Úvodné info a nastavenia Power BI a Power Query
28s
Available only with full access purchase
38s
Available in course preview
38s
Available in course preview
2min
Available in course preview
1min
Available in course preview
1min
Available in course preview
1min
Available in course preview
Ako zapnúť M-riadok vzorcov v Power Query
55s
Available only with full access purchase
Close & Apply
1min
Available only with full access purchase
Čo je Query?
1min
Available only with full access purchase
Čo je M-jazyk?
1min
Available only with full access purchase
Materiály ku kurzu Power Query
Predstavenie materiálov - SalesDatasetDemoData.xlsx
3min
Available only with full access purchase
Materialy
-
Available only with full access purchase
Načítaj dáta z rôznych zdrojov
Intro kapitoly - Načítaj dáta z rôznych zdrojov
45s
Available only with full access purchase
4min
Available in course preview
1min
Available in course preview
5min
Available in course preview
4min
Available in course preview
Vlastná tabuľka
1min
Available only with full access purchase
2min
Available in course preview
6min
Available in course preview
Pripojenie na SQL databázu
2min
Available only with full access purchase
Pripojenie na MySQL databázu
3min
Available only with full access purchase
Pripojenie na web API
3min
Available only with full access purchase
Iné konektory
5min
Available only with full access purchase
Základné úpravy stĺpcov
Intro kapitoly - Základné úpravy stĺpcov
25s
Available only with full access purchase
Automaticky vytvárané kroky v Power Query
1min
Available only with full access purchase
Zmena názvu a poradia stĺpcov
1min
Available only with full access purchase
Change Type – Zmena typu hodnôt v stĺpcoch
4min
Available only with full access purchase
Change Type Using Change Locale
5min
Available only with full access purchase
Select or Remove Columns – Výber stĺpcov
1min
Available only with full access purchase
Promote Headers
2min
Available only with full access purchase
Tvorba nových stĺpcov
Intro kapitoly - Vytváranie nových stĺpcov
20s
Available only with full access purchase
Duplicate Columns – Zdvojenie stĺpcov
1min
Available only with full access purchase
Rozdiel Transform vs. Add Column
2min
Available only with full access purchase
New Custom Column – Vlastný stĺpec
2min
Available only with full access purchase
Conditional Column – Podmienený stĺpec
4min
Available only with full access purchase
Index Column – Stĺpec s automatickým číslovaním
2min
Available only with full access purchase
Prepájanie a kopírovanie Query
Intro kapitoly - Prepájanie Query
23s
Available only with full access purchase
Duplicate & Reference Query
3min
Available only with full access purchase
Copy Query
3min
Available only with full access purchase
Zmenšenie počtu riadkov
Intro kapitoly - Zmenšenie počtu riadkov
25s
Available only with full access purchase
Filter & Sort Rows
5min
Available only with full access purchase
Remove Top Rows – Odstráň prvé riadky
2min
Available only with full access purchase
Remove Duplicates – Odstráň duplicity
2min
Available only with full access purchase
Group – Zoskupovanie riadkov
2min
Available only with full access purchase
Group by All Rows
3min
Available only with full access purchase
Zväčšenie počtu riadkov
Intro kapitoly - Zväčenie počtu riadkov
26s
Available only with full access purchase
Multiple Rows by Lists
4min
Available only with full access purchase
Operácie Pivot a Unpivot
Intro kapitoly - Pivot a unpivot
39s
Available only with full access purchase
Unpivot
6min
Available only with full access purchase
Pivot
4min
Available only with full access purchase
Spájanie viacerých tabuliek a queries
Intro kapitoly - Spájanie viacerých tabuliek a Queries
30s
Available only with full access purchase
Základy ku spájaniu tabuliek
1min
Available only with full access purchase
Append
3min
Available only with full access purchase
Join (Merge) Queries
33s
Available only with full access purchase
Tipy z praxe k udržateľnosti
Intro kapitoly - Tipy z praxe k udržateľnosti
37s
Available only with full access purchase
Bez diakritiky
1min
Available only with full access purchase
Load/Not Load Power Query
2min
Available only with full access purchase
Import/Direct Query
1min
Available only with full access purchase
Native Query
2min
Available only with full access purchase
Preview Now/Preview All
3min
Available only with full access purchase
Error Handling v Power Query
2min
Available only with full access purchase
Kde nájsť online zdroje k Power BI
4min
Available only with full access purchase
3
Online courses
1
Posts