|
|
01. Class Promo Video-en-US.vtt
|
VTT
|
4.4 KB
|
|
|
01. Class Promo Video.mp4
|
MP4
|
35.7 MB
|
|
|
02. Please Follow me on SkillShare-en-US.vtt
|
VTT
|
614.4 B
|
|
|
02. Please Follow me on SkillShare.mp4
|
MP4
|
4.5 MB
|
|
|
03. Course Introduction & Know your Instructor!-en-US.vtt
|
VTT
|
5.4 KB
|
|
|
03. Course Introduction & Know your Instructor!.mp4
|
MP4
|
13.5 MB
|
|
|
04. DAX Functions Guide-en-US.vtt
|
VTT
|
3 KB
|
|
|
04. DAX Functions Guide.mp4
|
MP4
|
19.9 MB
|
|
|
05. Enabling PowerPivot in Excel-en-US.vtt
|
VTT
|
7.2 KB
|
|
|
05. Enabling PowerPivot in Excel.mp4
|
MP4
|
33 MB
|
|
|
06. Loading the Data - Using the PowerPivot tab-en-US.vtt
|
VTT
|
3.5 KB
|
|
|
06. Loading the Data - Using the PowerPivot tab.mp4
|
MP4
|
25.9 MB
|
|
|
07. Loading the Data - Using PowerQuery-en-US.vtt
|
VTT
|
16.5 KB
|
|
|
07. Loading the Data - Using PowerQuery.mp4
|
MP4
|
128.8 MB
|
|
|
08. Relationships in the Data Model - Fact vs Dimension Tables-en-US.vtt
|
VTT
|
11.3 KB
|
|
|
08. Relationships in the Data Model - Fact vs Dimension Tables.mp4
|
MP4
|
62 MB
|
|
|
09. Relationship Types - Part 1-en-US.vtt
|
VTT
|
16 KB
|
|
|
09. Relationship Types - Part 1.mp4
|
MP4
|
61.2 MB
|
|
|
1.3 Loading The Data - Start.xlsx
|
XLSX
|
54.4 KB
|
|
|
1.3 Loading The Data.xlsx
|
XLSX
|
3 MB
|
|
|
1.4 Relationships in the Data Model - Start.xlsx
|
XLSX
|
3 MB
|
|
|
1.4 Relationships in the Data Model.xlsx
|
XLSX
|
3.1 MB
|
|
|
1.5 Measures and Calculated Columns - Start.xlsx
|
XLSX
|
4.7 MB
|
|
|
1.5 Measures and Calculated Columns.xlsx
|
XLSX
|
4.8 MB
|
|
|
1.6 Implicit vs Explicit Measures - Start.xlsx
|
XLSX
|
4.8 MB
|
|
|
1.6 Implicit vs Explicit Measures.xlsx
|
XLSX
|
4.8 MB
|
|
|
10. Relationship Types - Part 2-en-US.vtt
|
VTT
|
5.3 KB
|
|
|
10. Relationship Types - Part 2.mp4
|
MP4
|
16.1 MB
|
|
|
11. Measures and Calculated Columns - Part 1-en-US.vtt
|
VTT
|
12.7 KB
|
|
|
11. Measures and Calculated Columns - Part 1.mp4
|
MP4
|
86.4 MB
|
|
|
12. Measures and Calculated Columns - Part 2-en-US.vtt
|
VTT
|
14 KB
|
|
|
12. Measures and Calculated Columns - Part 2.mp4
|
MP4
|
107.3 MB
|
|
|
13. Implicit vs Explicit Measures-en-US.vtt
|
VTT
|
6.5 KB
|
|
|
13. Implicit vs Explicit Measures.mp4
|
MP4
|
45.8 MB
|
|
|
14. What is the Filter Context-en-US.vtt
|
VTT
|
19.6 KB
|
|
|
14. What is the Filter Context.mp4
|
MP4
|
134.6 MB
|
|
|
15. What is the Row Context-en-US.vtt
|
VTT
|
16.6 KB
|
|
|
15. What is the Row Context.mp4
|
MP4
|
82.7 MB
|
|
|
16. Building the Data Model & Relationships-en-US.vtt
|
VTT
|
9.4 KB
|
|
|
16. Building the Data Model & Relationships.mp4
|
MP4
|
55.3 MB
|
|
|
17. Creating Sales & Total Product cost measures-en-US.vtt
|
VTT
|
3.7 KB
|
|
|
17. Creating Sales & Total Product cost measures.mp4
|
MP4
|
19.5 MB
|
|
|
18. More Measures - Homework-en-US.vtt
|
VTT
|
2.4 KB
|
|
|
18. More Measures - Homework.mp4
|
MP4
|
8.1 MB
|
|
|
19. More Measures - Solutions-en-US.vtt
|
VTT
|
8.6 KB
|
|
|
19. More Measures - Solutions.mp4
|
MP4
|
59.5 MB
|
|
|
2.1 What is the Filter Context - Start.xlsx
|
XLSX
|
4.8 MB
|
|
|
2.1 What is the Filter Context.xlsx
|
XLSX
|
4.8 MB
|
|
|
2.2 The Row Context - Start.xlsx
|
XLSX
|
4.8 MB
|
|
|
2.2 The Row Context.xlsx
|
XLSX
|
4.9 MB
|
|
|
20. RELATED() Function - Part 1-en-US.vtt
|
VTT
|
8.8 KB
|
|
|
20. RELATED() Function - Part 1.mp4
|
MP4
|
48.4 MB
|
|
|
21. RELATED() Function - Part 2-en-US.vtt
|
VTT
|
5.9 KB
|
|
|
21. RELATED() Function - Part 2.mp4
|
MP4
|
30.4 MB
|
|
|
22. RELATEDTABLE() Function-en-US.vtt
|
VTT
|
11 KB
|
|
|
22. RELATEDTABLE() Function.mp4
|
MP4
|
66 MB
|
|
|
23. Installing PP Utilities and DAX Studio-en-US.vtt
|
VTT
|
7.6 KB
|
|
|
23. Installing PP Utilities and DAX Studio.mp4
|
MP4
|
42 MB
|
|
|
24. Iterator Functions-en-US.vtt
|
VTT
|
3.4 KB
|
|
|
24. Iterator Functions.mp4
|
MP4
|
14.6 MB
|
|
|
25. Aggregation iterator functions-en-US.vtt
|
VTT
|
9.9 KB
|
|
|
25. Aggregation iterator functions.mp4
|
MP4
|
81.1 MB
|
|
|
26. The Filter Function - Part 1-en-US.vtt
|
VTT
|
11.7 KB
|
|
|
26. The Filter Function - Part 1.mp4
|
MP4
|
67.1 MB
|
|
|
27. The FIlter Function - Part 2-en-US.vtt
|
VTT
|
8.5 KB
|
|
|
27. The FIlter Function - Part 2.mp4
|
MP4
|
75.1 MB
|
|
|
28. The Filter Function - Part 3-en-US.vtt
|
VTT
|
8.3 KB
|
|
|
28. The Filter Function - Part 3.mp4
|
MP4
|
54.9 MB
|
|
|
29. The FILTER Function Part 4-en-US.vtt
|
VTT
|
2.7 KB
|
|
|
29. The FILTER Function Part 4.mp4
|
MP4
|
22.5 MB
|
|
|
3.1 More Measures - Start.xlsx
|
XLSX
|
8.2 KB
|
|
|
3.1 More Measures.xlsx
|
XLSX
|
2.5 MB
|
|
|
30. The Filter Function - Part 5-en-US.vtt
|
VTT
|
6.7 KB
|
|
|
30. The Filter Function - Part 5.mp4
|
MP4
|
37.3 MB
|
|
|
31. Iterator Functions - Exercises-en-US.vtt
|
VTT
|
1.4 KB
|
|
|
31. Iterator Functions - Exercises.mp4
|
MP4
|
6.8 MB
|
|
|
32. Iterator Functions - Exercise Answers-en-US.vtt
|
VTT
|
14.9 KB
|
|
|
32. Iterator Functions - Exercise Answers.mp4
|
MP4
|
100.6 MB
|
|
|
33. ALL Function-en-US.vtt
|
VTT
|
10.3 KB
|
|
|
33. ALL Function.mp4
|
MP4
|
50.1 MB
|
|
|
34. ALL Function with Columns-en-US.vtt
|
VTT
|
13.6 KB
|
|
|
34. ALL Function with Columns.mp4
|
MP4
|
67.2 MB
|
|
|
35. ALLSELECTED() Function-en-US.vtt
|
VTT
|
14.4 KB
|
|
|
35. ALLSELECTED() Function.mp4
|
MP4
|
83.5 MB
|
|
|
36. VALUES vs DISTINCT Function-en-US.vtt
|
VTT
|
23.6 KB
|
|
|
36. VALUES vs DISTINCT Function.mp4
|
MP4
|
108 MB
|
|
|
37. Variables in DAX-en-US.vtt
|
VTT
|
14.3 KB
|
|
|
37. Variables in DAX.mp4
|
MP4
|
71.8 MB
|
|
|
38. CALCULATE - Intro-en-US.vtt
|
VTT
|
1.2 KB
|
|
|
38. CALCULATE - Intro.mp4
|
MP4
|
3.4 MB
|
|
|
39. Removing filters with ALL-en-US.vtt
|
VTT
|
11.5 KB
|
|
|
39. Removing filters with ALL.mp4
|
MP4
|
61.4 MB
|
|
|
4.1 RELATED and RELATEDTABLE - Start.xlsx
|
XLSX
|
2.6 MB
|
|
|
4.1 RELATED and RELATEDTABLE.xlsx
|
XLSX
|
2.7 MB
|
|
|
40. CALCULATE() with ALLSELECTED()-en-US.vtt
|
VTT
|
8.5 KB
|
|
|
40. CALCULATE() with ALLSELECTED().mp4
|
MP4
|
48.6 MB
|
|
|
41. CALCULATE - Overwriting Filter Context-en-US.vtt
|
VTT
|
12.6 KB
|
|
|
41. CALCULATE - Overwriting Filter Context.mp4
|
MP4
|
62.5 MB
|
|
|
42. CALCULATE - Multiple Filters-en-US.vtt
|
VTT
|
3.6 KB
|
|
|
42. CALCULATE - Multiple Filters.mp4
|
MP4
|
18.8 MB
|
|
|
43. CALCULATE with KEEPFILTERS-en-US.vtt
|
VTT
|
10.1 KB
|
|
|
43. CALCULATE with KEEPFILTERS.mp4
|
MP4
|
46.6 MB
|
|
|
44. Nested CALCULATE()-en-US.vtt
|
VTT
|
7.7 KB
|
|
|
44. Nested CALCULATE().mp4
|
MP4
|
41 MB
|
|
|
45. CALCULATETABLE Function - Intro-en-US.vtt
|
VTT
|
9.2 KB
|
|
|
45. CALCULATETABLE Function - Intro.mp4
|
MP4
|
43.3 MB
|
|
|
46. CALCULATETABLE Function - New Customers Measure-en-US.vtt
|
VTT
|
30 KB
|
|
|
46. CALCULATETABLE Function - New Customers Measure.mp4
|
MP4
|
158.9 MB
|
|
|
47. CALCULATE - Exercises-en-US.vtt
|
VTT
|
1 KB
|
|
|
47. CALCULATE - Exercises.mp4
|
MP4
|
5.4 MB
|
|
|
48. CALCULATE - Exercises Answers - Part 1-en-US.vtt
|
VTT
|
19.7 KB
|
|
|
48. CALCULATE - Exercises Answers - Part 1.mp4
|
MP4
|
164.7 MB
|
|
|
49. CALCULATE - Exercise Answers Part 2-en-US.vtt
|
VTT
|
19.5 KB
|
|
|
49. CALCULATE - Exercise Answers Part 2.mp4
|
MP4
|
130.4 MB
|
|
|
5- Iterator Functions - Exercises - Answers.xlsx
|
XLSX
|
2.7 MB
|
|
|
5- Iterator Functions - Exercises.xlsx
|
XLSX
|
2.7 MB
|
|
|
5- Iterator Functions - Start.xlsx
|
XLSX
|
2.6 MB
|
|
|
5- Iterator Functions.xlsx
|
XLSX
|
2.7 MB
|
|
|
5.2- The Filter Function - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
5.2- The Filter Function.xlsx
|
XLSX
|
2.7 MB
|
|
|
50. Time Intelligence - Intro-en-US.vtt
|
VTT
|
4.5 KB
|
|
|
50. Time Intelligence - Intro.mp4
|
MP4
|
16.1 MB
|
|
|
51. Creating the Calendar Table - Part 1-en-US.vtt
|
VTT
|
12.4 KB
|
|
|
51. Creating the Calendar Table - Part 1.mp4
|
MP4
|
66.4 MB
|
|
|
52. Creating the Calendar Table - Part 2-en-US.vtt
|
VTT
|
23.8 KB
|
|
|
52. Creating the Calendar Table - Part 2.mp4
|
MP4
|
136.4 MB
|
|
|
53. Calculating YTD Results-en-US.vtt
|
VTT
|
23 KB
|
|
|
53. Calculating YTD Results.mp4
|
MP4
|
137.9 MB
|
|
|
54. Calculating Previous Periods-en-US.vtt
|
VTT
|
19.4 KB
|
|
|
54. Calculating Previous Periods.mp4
|
MP4
|
149.3 MB
|
|
|
55. Calculating Moving Running Total-en-US.vtt
|
VTT
|
10.4 KB
|
|
|
55. Calculating Moving Running Total.mp4
|
MP4
|
64.1 MB
|
|
|
56. Calculating Moving Average-en-US.vtt
|
VTT
|
13.9 KB
|
|
|
56. Calculating Moving Average.mp4
|
MP4
|
81.1 MB
|
|
|
57. Weekly Time Intelligence in DAX - Calculate weekly results-en-US.vtt
|
VTT
|
31.8 KB
|
|
|
57. Weekly Time Intelligence in DAX - Calculate weekly results.mp4
|
MP4
|
210.9 MB
|
|
|
58. Time Intelligence - Exercises-en-US.vtt
|
VTT
|
2.9 KB
|
|
|
58. Time Intelligence - Exercises.mp4
|
MP4
|
14.7 MB
|
|
|
59. Time Intelligence - Exercise Answers - Part 1-en-US.vtt
|
VTT
|
22.2 KB
|
|
|
59. Time Intelligence - Exercise Answers - Part 1.mp4
|
MP4
|
154.9 MB
|
|
|
6.1 ALL Function - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
6.1 ALL Function.xlsx
|
XLSX
|
2.7 MB
|
|
|
6.2 VALUES and DISTINCT - Start.xlsx
|
XLSX
|
25.3 KB
|
|
|
6.2 VALUES and DISTINCT.xlsx
|
XLSX
|
200.9 KB
|
|
|
6.3 ALLSELECTED Function - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
6.3 ALLSELECTED Function.xlsx
|
XLSX
|
2.7 MB
|
|
|
60. Time Intelligence - Exercise Answers - Part 2-en-US.vtt
|
VTT
|
19.3 KB
|
|
|
60. Time Intelligence - Exercise Answers - Part 2.mp4
|
MP4
|
143.6 MB
|
|
|
61. Thanks for watching-en-US.vtt
|
VTT
|
819.2 B
|
|
|
61. Thanks for watching.mp4
|
MP4
|
702.2 KB
|
|
|
62. Please Rate the class-en-US.vtt
|
VTT
|
614.4 B
|
|
|
62. Please Rate the class.mp4
|
MP4
|
4.6 MB
|
|
|
7.1 Variables in DAX - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
7.1 Variables in DAX.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.1 CALCULATE - Intro - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.1 CALCULATE - Intro.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.10 CALCULATE - Exercises - Answers.xlsx
|
XLSX
|
2.8 MB
|
|
|
8.2 CALCULATE - Removing Filters with ALL - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.2 CALCULATE - Removing Filters with ALL.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.3 CALCULATE with ALLSELECTED - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.3 CALCULATE with ALLSELECTED.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.4 CALCULATE overwrites the FILTER Context - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.4 CALCULATE overwrites the FILTER Context.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.5 CALCULATE with Multiple Filters - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.5 CALCULATE with Multiple Filters.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.6 CALCULATE with KEEPFILTERS - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.6 CALCULATE with KEEPFILTERS.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.7 Nested CALCULATE - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.7 Nested CALCULATE.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.8 CALCULATETABLE - Start.xlsx
|
XLSX
|
2.7 MB
|
|
|
8.8 CALCULATETABLE.xlsx
|
XLSX
|
2.8 MB
|
|
|
8.9 CALCULATE - Exercises.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.1 Time Intelligence in DAX.pptx
|
PPTX
|
71.9 KB
|
|
|
9.2 Creating the Calendar Table - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.2 Creating the Calendar Table.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.3 Calculating YTD - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.3 Calculating YTD.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.4 Calculating Previous Periods - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.4 Calculating Previous Periods.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.5 Calculating Moving Running Total - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.5 Calculating Moving Running Total.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.6 Calculating Moving Average - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.6 Calculating Moving Average.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.7 Weekly Time Intelligence - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.7 Weekly Time Intelligence.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.8 Time Intelligence - Exercises.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.9 Time Intelligence - Exercise Answers - Start.xlsx
|
XLSX
|
2.8 MB
|
|
|
9.9 Time Intelligence - Exercise Answers.xlsx
|
XLSX
|
2.9 MB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Customers.xlsx
|
XLSX
|
615.2 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
PowerPivot & Power Query Download Links.txt
|
TXT
|
204.8 B
|
|
|
Products.xlsx
|
XLSX
|
38.6 KB
|
|
|
Sales.xlsx
|
XLSX
|
7.9 MB
|
|
|
Territories.xlsx
|
XLSX
|
8.9 KB
|
