1
Free Advanced Data Analysis & BI Course at YouTube (MSPTDA)
1:48
2020-10-26
2
Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.
12:13
2018-06-18
3
MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class
31:26
2018-06-24
4
MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop
57:13
2018-06-28
5
MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set
32:04
2018-07-04
6
Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662
0:57
2020-04-12
7
MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook
27:44
2018-07-12
8
MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations
23:39
2018-07-14
9
MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
37:39
2018-07-22
10
MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)
30:43
2018-07-30
11
MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences
8:34
2018-08-07
12
MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More
1:07:27
2018-08-20
13
Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)
5:22
2018-08-30
14
MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column
29:40
2018-08-28
15
Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546
12:44
2019-04-10
16
Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
21:48
2019-06-20
17
MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop
19:11
2018-09-10
18
MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!
3:17
2018-09-12
19
MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
21:19
2018-09-22
20
MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report
15:24
2018-10-06
21
MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel
19:09
2018-10-12
22
MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
2:04:00
2018-11-17
23
MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing
1:19:35
2018-12-09
24
MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets.
8:35
2018-12-18
25
MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI
1:07:00
2018-12-30
26
MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)
1:48:28
2019-02-02
27
MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT?
15:12
2019-06-28
28
MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query
11:07
2019-04-27
29
MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size
25:13
2019-05-04
30
MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations
20:08
2019-05-08
31
EMT 1493: Excel Formulas PivotTable: Allocate Invoice Header Amounts To Transaction Line Table
21:40
2018-05-10
32
EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table
15:37
2018-05-12
33
MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table
1:04:59
2019-05-15
34
MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!
6:29
2019-05-18
35
Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678.
11:50
2020-07-11
36
MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
6:17
2019-05-23
37
MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model
10:51
2019-05-23
38
Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
5:26
2017-04-15
39
Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables
12:46
2017-04-19
40
MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
13:38
2019-05-31
41
MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
17:28
2019-06-02
42
MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
10:20
2019-06-11
43
MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports
10:19
2019-06-14
44
MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas
8:34
2019-10-14
45
MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable
12:46
2019-10-17
46
MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not
7:10
2019-10-21
47
MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot
11:30
2019-10-25
48
MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions
10:34
2019-10-26
49
Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total
7:34
2017-03-14
50
Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
16:33
2017-03-16
51
Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item
5:13
2017-03-17
52
Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total
34:41
2017-03-18
53
Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years
22:36
2017-07-24
54
Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)
11:08
2017-03-21
55
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
19:28
2017-03-23
56
Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart
12:12
2017-03-25
57
Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
12:47
2017-03-26
58
Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks
41:14
2017-03-27
59
Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553
31:16
2019-06-07
60
Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer
12:10
2017-05-09
61
Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
14:28
2017-05-11
62
Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
27:06
2017-05-12
63
Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns
12:51
2017-05-14
64
Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!
5:41
2017-05-19
65
Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?
29:29
2017-02-11
66
Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions
7:05
2017-04-17
67
Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)
14:01
2017-04-22
68
Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?
28:07
2017-05-17
69
Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552
22:45
2019-05-28
70
Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc
12:14
2017-05-20
71
Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report
13:34
2017-04-15
72
Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop
21:12
2017-06-23
73
Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR
9:45
2017-05-22
74
Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S…
19:53
2017-05-23
75
Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set.
12:12
2017-05-26
76
Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet
8:00
2017-05-28
77
Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total
6:52
2017-05-30
78
Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function
16:16
2017-05-31
79
Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)
9:44
2019-11-30
80
Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)
18:34
2019-12-13
81
Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621
15:43
2019-12-20
82
MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables
13:23
2019-12-22
83
Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.
22:22
2020-04-17
