0:00 Intro
-------------------------------------------------------------------------
3:27 PQB01: Introduction "Get & Transform" Automate Data Transformation
To download excel workbook:
[ Ссылка ]
-------------------------------------------------------------------------
17:04 PQB02: Extract data from current workbook, and create dynamic unique list
To download excel workbook:
Start: ttps://docs.google.com/spreadsheets/d/1G1dA8JJxVWUCDiQutMX53MSWn1Y4HFpe/edit?usp=sharing&ouid=110580770751308536617&rtpof=true&sd=true
Finish: [ Ссылка ]
-------------------------------------------------------------------------
29:47 PQB03:Extract from excel workbook & consolidate multiple worksheets in 1 pivot table
Excel file:
[ Ссылка ]
Data file:
[ Ссылка ]
-------------------------------------------------------------------------
42:28 PQB04:Extract data from a folder contains “CSV files” automatically update new data
Excel file:
[ Ссылка ]
CSV files:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
-------------------------------------------------------------------------
58:41 PQB05: Extract data from Access Database and load to excel data model
Excel file:
[ Ссылка ]
Access database:
[ Ссылка ]
-------------------------------------------------------------------------
1:19:35 PQB05.5: Power Query in Power BI. from access database to an interactive dashboard
Access database:
[ Ссылка ]
Power BI file:
[ Ссылка ]
-------------------------------------------------------------------------
1:46:45 PQB06: Connect to the web with power Query
Excel file:
[ Ссылка ]
-------------------------------------------------------------------------
1:58:05 PQB07: Split Column to Rows - Automate & Organize Chaotic Input Data
Excel file:
[ Ссылка ]
-------------------------------------------------------------------------
2:12:05 PQB08: Append data from 3 different Tables
Excel file:
[ Ссылка ]
-------------------------------------------------------------------------
2:26:07 PQB09: Merge Queries: V-lookup in Power Query
CSV:
[ Ссылка ]
Excel:
[ Ссылка ]
----------------------------------------------------------------------
2:40:28 PQB10: Merge Queries: Compare between 2 tables
Excel file:
[ Ссылка ]--
----------------------------------------------------------------------
2:58:00 PQB11: Merge Queries: Left Outer - Solve duplicate issues
Excel file:
[ Ссылка ]
---------------------------------------------------------------------
3:10:10 PQB12: Merge Queries: Replace Sum-if
Excel file:
[ Ссылка ]
---------------------------------------------------------------------
3:20:01 PQB13: Merge Queries: 2D search using Formulas (V-lookup + Match) & Power Query
Excel file:
[ Ссылка ]
---------------------------------------------------------------------
3:40:44 PQB14: Excel.CurrentWorkbook() to extract data & “Group by” to Summarize data
Start file:
[ Ссылка ]
End file:
[ Ссылка ]
Additional data:
[ Ссылка ]
---------------------------------------------------------------------
4:06:20 PQB15: Dynamic Filter with PQ, criteria input from excel & customized refresh button
Working files:
[ Ссылка ]
---------------------------------------------------------------------
4:30:49 PQB16: Manage Queries: Duplicate, Reference or Append
Working files:
[ Ссылка ]
---------------------------------------------------------------------
To subscribe:
[ Ссылка ]
