589689.xyz

[] Udemy - Microsoft Excel - Intro to Power Query, Power Pivot & DAX

  • 收录时间:2019-05-22 16:10:43
  • 文件大小:1GB
  • 下载次数:115
  • 最近下载:2021-01-19 11:36:36
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 6. Common DAX Functions/21. Time Intelligence Formulas.mp4 62MB
  2. 6. Common DAX Functions/7. Logical Functions (IFANDOR).mp4 51MB
  3. 6. Common DAX Functions/17. Iterator (X) Functions SUMX.mp4 38MB
  4. 6. Common DAX Functions/13. Adding Filter Context with FILTER (Part 2).mp4 37MB
  5. 6. Common DAX Functions/4. Basic Math & Stats Functions.mp4 37MB
  6. 6. Common DAX Functions/5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp4 35MB
  7. 6. Common DAX Functions/11. The CALCULATE Function.mp4 33MB
  8. 6. Common DAX Functions/9. Text Functions.mp4 32MB
  9. 3. Power Query/7. Text-Specific Tools.mp4 29MB
  10. 5. Power Pivot & DAX 101/11. Step-by-Step Measure Calculation.mp4 29MB
  11. 6. Common DAX Functions/18. Iterator (X) Functions RANKX.mp4 27MB
  12. 5. Power Pivot & DAX 101/5. Calculated Columns.mp4 27MB
  13. 6. Common DAX Functions/8. SWITCH & SWITCH(TRUE).mp4 25MB
  14. 3. Power Query/17. Connecting to a Folder of Files.mp4 25MB
  15. 3. Power Query/6. Basic Table Transformations.mp4 24MB
  16. 6. Common DAX Functions/14. Removing Filter Context with ALL.mp4 24MB
  17. 3. Power Query/8. Number-Specific Tools.mp4 22MB
  18. 2. Intro to “Power Excel/2. The Best Thing to Happen to Excel in 20 Years.mp4 22MB
  19. 6. Common DAX Functions/12. Adding Filter Context with FILTER (Part 1).mp4 21MB
  20. 5. Power Pivot & DAX 101/10. Understanding Filter Context.mp4 20MB
  21. 3. Power Query/9. Date-Specific Tools.mp4 20MB
  22. 3. Power Query/11. Adding Index & Conditional Columns.mp4 19MB
  23. 3. Power Query/15. Merging Queries.mp4 19MB
  24. 3. Power Query/13. Pivoting & Unpivoting.mp4 19MB
  25. 5. Power Pivot & DAX 101/9. Creating Explicit Measures (Power Pivot).mp4 18MB
  26. 3. Power Query/12. Grouping & Aggregating data.mp4 17MB
  27. 5. Power Pivot & DAX 101/8. Creating Explicit Measures (AutoSum).mp4 16MB
  28. 6. Common DAX Functions/20. Basic Date & Time Functions.mp4 16MB
  29. 4. Data Modeling 101/7. Creating Table Relationships.mp4 15MB
  30. 1. Getting Started/1. Course Structure & Outline.mp4 15MB
  31. 3. Power Query/16. Appending Queries.mp4 15MB
  32. 4. Data Modeling 101/11. Connecting Multiple Data Tables.mp4 13MB
  33. 4. Data Modeling 101/5. Data Tables vs. Lookup Tables.mp4 13MB
  34. 5. Power Pivot & DAX 101/2. Creating a Power PivotTable.mp4 12MB
  35. 7. Wrapping Up/3. Sneak Peek PowerBI.mp4 12MB
  36. 4. Data Modeling 101/10. Relationship Cardinality.mp4 12MB
  37. 3. Power Query/10. PRO TIP Creating a Rolling Calendar.mp4 11MB
  38. 3. Power Query/14. Modifying Workbook Queries.mp4 11MB
  39. 4. Data Modeling 101/2. Meet Excel's Data Model.mp4 10MB
  40. 4. Data Modeling 101/13. Hiding Fields from Client Tools.mp4 10MB
  41. 4. Data Modeling 101/12. Filter Direction.mp4 10MB
  42. 1. Getting Started/2. IMPORTANT Versions & Compatibility.mp4 10MB
  43. 4. Data Modeling 101/4. Database Normalization.mp4 9MB
  44. 4. Data Modeling 101/9. Active vs. Inactive Relationships.mp4 9MB
  45. 6. Common DAX Functions/16. Joining Data with RELATED.mp4 8MB
  46. 7. Wrapping Up/2. Data Visualization Options.mp4 8MB
  47. 6. Common DAX Functions/2. DAX Formula Syntax & Operators.mp4 8MB
  48. 4. Data Modeling 101/14. Defining Hierarchies.mp4 8MB
  49. 6. Common DAX Functions/3. Common DAX Function Categories.mp4 7MB
  50. 2. Intro to “Power Excel/1. The “Power Excel” Workflow.mp4 7MB
  51. 1. Getting Started/1.1 PowerQuery_PowerPivot_DAX.pdf.pdf 7MB
  52. 7. Wrapping Up/4. Resources & Next Steps.mp4 7MB
  53. 3. Power Query/3. The Query Editor.mp4 7MB
  54. 4. Data Modeling 101/3. Data vs. Diagram View.mp4 7MB
  55. 6. Common DAX Functions/23. Speed & Performance Considerations.mp4 6MB
  56. 1. Getting Started/4.3 FoodMart_Transactions_1998.csv.csv 6MB
  57. 7. Wrapping Up/1. Introduction.mp4 6MB
  58. 4. Data Modeling 101/8. Modifying Table Relationships.mp4 6MB
  59. 5. Power Pivot & DAX 101/3. Power Pivots vs. “Normal” Pivots.mp4 6MB
  60. 1. Getting Started/4. Downloading the Course Project Files.mp4 6MB
  61. 3. Power Query/18. Power Query Best Practices.mp4 5MB
  62. 3. Power Query/2. Meet Power Query (aka “Get & Transform”).mp4 5MB
  63. 1. Getting Started/5. Setting Expectations.mp4 5MB
  64. 5. Power Pivot & DAX 101/12. Recap Calculated Columns vs. Measures.mp4 5MB
  65. 5. Power Pivot & DAX 101/6. DAX Measures = Supercharged Calculated Fields.mp4 5MB
  66. 4. Data Modeling 101/6. Relationships vs. Merged Tables.mp4 4MB
  67. 1. Getting Started/4.7 FoodMart_Data_Model_COMPLETE.xlsx.xlsx 4MB
  68. 5. Power Pivot & DAX 101/7. Creating Implicit Measures.mp4 4MB
  69. 6. Common DAX Functions/24. DAX Best Practices.mp4 4MB
  70. 5. Power Pivot & DAX 101/1. Introduction.mp4 4MB
  71. 5. Power Pivot & DAX 101/13. Power Pivot Best Practices.mp4 4MB
  72. 4. Data Modeling 101/1. Introduction.mp4 3MB
  73. 3. Power Query/1. Introduction.mp4 3MB
  74. 3. Power Query/4. Data Loading Options.mp4 3MB
  75. 4. Data Modeling 101/15. Data Model Best Practices.mp4 3MB
  76. 1. Getting Started/4.1 FoodMart_Transactions_1997.csv.csv 3MB
  77. 6. Common DAX Functions/1. Introduction.mp4 3MB
  78. 5. Power Pivot & DAX 101/4. Intro to Data Analysis Expressions (DAX).mp4 2MB
  79. 1. Getting Started/4.8 Customer_Lookup.csv.csv 2MB
  80. 2. Intro to “Power Excel/3. When to use Power Query & Power Pivot.mp4 1MB
  81. 1. Getting Started/4.4 FoodMart_Returns_1997-1998.csv.csv 138KB
  82. 1. Getting Started/4.2 Product_Lookup.csv.csv 102KB
  83. 6. Common DAX Functions/7. Logical Functions (IFANDOR).vtt 19KB
  84. 6. Common DAX Functions/21. Time Intelligence Formulas.vtt 18KB
  85. 6. Common DAX Functions/13. Adding Filter Context with FILTER (Part 2).vtt 16KB
  86. 6. Common DAX Functions/11. The CALCULATE Function.vtt 16KB
  87. 6. Common DAX Functions/4. Basic Math & Stats Functions.vtt 15KB
  88. 5. Power Pivot & DAX 101/11. Step-by-Step Measure Calculation.vtt 14KB
  89. 6. Common DAX Functions/17. Iterator (X) Functions SUMX.vtt 13KB
  90. 6. Common DAX Functions/9. Text Functions.vtt 13KB
  91. 3. Power Query/7. Text-Specific Tools.vtt 13KB
  92. 6. Common DAX Functions/5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.vtt 12KB
  93. 3. Power Query/17. Connecting to a Folder of Files.vtt 12KB
  94. 6. Common DAX Functions/8. SWITCH & SWITCH(TRUE).vtt 11KB
  95. 5. Power Pivot & DAX 101/10. Understanding Filter Context.vtt 11KB
  96. 6. Common DAX Functions/12. Adding Filter Context with FILTER (Part 1).vtt 11KB
  97. 2. Intro to “Power Excel/2. The Best Thing to Happen to Excel in 20 Years.vtt 11KB
  98. 3. Power Query/13. Pivoting & Unpivoting.vtt 10KB
  99. 5. Power Pivot & DAX 101/5. Calculated Columns.vtt 10KB
  100. 6. Common DAX Functions/14. Removing Filter Context with ALL.vtt 10KB
  101. 3. Power Query/6. Basic Table Transformations.vtt 10KB
  102. 5. Power Pivot & DAX 101/9. Creating Explicit Measures (Power Pivot).vtt 10KB
  103. 3. Power Query/15. Merging Queries.vtt 10KB
  104. 3. Power Query/8. Number-Specific Tools.vtt 9KB
  105. 5. Power Pivot & DAX 101/8. Creating Explicit Measures (AutoSum).vtt 9KB
  106. 3. Power Query/9. Date-Specific Tools.vtt 9KB
  107. 3. Power Query/11. Adding Index & Conditional Columns.vtt 9KB
  108. 4. Data Modeling 101/7. Creating Table Relationships.vtt 9KB
  109. 3. Power Query/12. Grouping & Aggregating data.vtt 8KB
  110. 1. Getting Started/4.6 Calendar_Lookup.csv.csv 8KB
  111. 7. Wrapping Up/3. Sneak Peek PowerBI.vtt 7KB
  112. 4. Data Modeling 101/11. Connecting Multiple Data Tables.vtt 7KB
  113. 4. Data Modeling 101/10. Relationship Cardinality.vtt 7KB
  114. 5. Power Pivot & DAX 101/2. Creating a Power PivotTable.vtt 7KB
  115. 4. Data Modeling 101/5. Data Tables vs. Lookup Tables.vtt 7KB
  116. 3. Power Query/16. Appending Queries.vtt 7KB
  117. 3. Power Query/10. PRO TIP Creating a Rolling Calendar.vtt 6KB
  118. 6. Common DAX Functions/18. Iterator (X) Functions RANKX.vtt 6KB
  119. 7. Wrapping Up/2. Data Visualization Options.vtt 6KB
  120. 4. Data Modeling 101/12. Filter Direction.vtt 6KB
  121. 4. Data Modeling 101/13. Hiding Fields from Client Tools.vtt 6KB
  122. 3. Power Query/14. Modifying Workbook Queries.vtt 6KB
  123. 6. Common DAX Functions/20. Basic Date & Time Functions.vtt 6KB
  124. 6. Common DAX Functions/2. DAX Formula Syntax & Operators.vtt 5KB
  125. 6. Common DAX Functions/3. Common DAX Function Categories.vtt 5KB
  126. 4. Data Modeling 101/4. Database Normalization.vtt 5KB
  127. 2. Intro to “Power Excel/1. The “Power Excel” Workflow.vtt 5KB
  128. 4. Data Modeling 101/9. Active vs. Inactive Relationships.vtt 5KB
  129. 4. Data Modeling 101/2. Meet Excel's Data Model.vtt 5KB
  130. 4. Data Modeling 101/14. Defining Hierarchies.vtt 5KB
  131. 5. Power Pivot & DAX 101/15. HOMEWORK Power Pivot & DAX 101.html 4KB
  132. 1. Getting Started/2. IMPORTANT Versions & Compatibility.vtt 4KB
  133. 6. Common DAX Functions/16. Joining Data with RELATED.vtt 4KB
  134. 3. Power Query/3. The Query Editor.vtt 4KB
  135. 3. Power Query/20. HOMEWORK Power Query.html 4KB
  136. 6. Common DAX Functions/23. Speed & Performance Considerations.vtt 4KB
  137. 1. Getting Started/3. Important Notes for New Students.html 4KB
  138. 6. Common DAX Functions/6. HOMEWORK Math & Stats Functions.html 4KB
  139. 6. Common DAX Functions/10. HOMEWORK Logical & Text Functions.html 4KB
  140. 1. Getting Started/4. Downloading the Course Project Files.vtt 4KB
  141. 6. Common DAX Functions/15. HOMEWORK CALCULATE, FILTER & ALL.html 4KB
  142. 5. Power Pivot & DAX 101/3. Power Pivots vs. “Normal” Pivots.vtt 4KB
  143. 3. Power Query/18. Power Query Best Practices.vtt 3KB
  144. 3. Power Query/2. Meet Power Query (aka “Get & Transform”).vtt 3KB
  145. 1. Getting Started/5. Setting Expectations.vtt 3KB
  146. 4. Data Modeling 101/3. Data vs. Diagram View.vtt 3KB
  147. 7. Wrapping Up/4. Resources & Next Steps.vtt 3KB
  148. 4. Data Modeling 101/17. HOMEWORK Data Modeling 101.html 3KB
  149. 5. Power Pivot & DAX 101/12. Recap Calculated Columns vs. Measures.vtt 3KB
  150. 6. Common DAX Functions/19. HOMEWORK Iterator Functions.html 3KB
  151. 1. Getting Started/4.9 Store_Lookup.csv.csv 3KB
  152. 1. Getting Started/4.5 Region_Lookup.csv.csv 3KB
  153. 5. Power Pivot & DAX 101/6. DAX Measures = Supercharged Calculated Fields.vtt 3KB
  154. 3. Power Query/5. IMPORTANT Regional Settings.html 3KB
  155. 4. Data Modeling 101/8. Modifying Table Relationships.vtt 3KB
  156. 4. Data Modeling 101/6. Relationships vs. Merged Tables.vtt 3KB
  157. 6. Common DAX Functions/24. DAX Best Practices.vtt 3KB
  158. 7. Wrapping Up/5. BONUS LECTURE More from Excel Maven.html 3KB
  159. 5. Power Pivot & DAX 101/7. Creating Implicit Measures.vtt 2KB
  160. 1. Getting Started/1. Course Structure & Outline.vtt 2KB
  161. 5. Power Pivot & DAX 101/13. Power Pivot Best Practices.vtt 2KB
  162. 6. Common DAX Functions/22. HOMEWORK Time Intelligence.html 2KB
  163. 3. Power Query/4. Data Loading Options.vtt 2KB
  164. 4. Data Modeling 101/15. Data Model Best Practices.vtt 2KB
  165. 5. Power Pivot & DAX 101/4. Intro to Data Analysis Expressions (DAX).vtt 1KB
  166. 7. Wrapping Up/1. Introduction.vtt 1KB
  167. 2. Intro to “Power Excel/3. When to use Power Query & Power Pivot.vtt 887B
  168. 2. Intro to “Power Excel/5. HOMEWORK Intro to Power Excel.html 783B
  169. 3. Power Query/1. Introduction.vtt 739B
  170. 5. Power Pivot & DAX 101/1. Introduction.vtt 631B
  171. 4. Data Modeling 101/1. Introduction.vtt 621B
  172. 6. Common DAX Functions/1. Introduction.vtt 598B
  173. 2. Intro to “Power Excel/4. QUIZ Intro to Power Excel.html 149B
  174. 3. Power Query/19. QUIZ Power Query.html 149B
  175. 4. Data Modeling 101/16. QUIZ Data Modeling 101.html 149B
  176. 5. Power Pivot & DAX 101/14. QUIZ Power Pivot & DAX 101.html 149B
  177. 6. Common DAX Functions/25. QUIZ Common DAX Functions.html 149B
  178. [DesireCourse.Com].url 51B