Torrent Info
Title [FreeCourseLab.com] Udemy - Microsoft Excel - Intro to Power Query, Power Pivot & DAX
Category PC
Size 1.11GB

Files List
Please note that this page does not hosts or makes available any of the listed filenames. You cannot download any of those files from here.
[FreeCourseLab.com].url 126B
1.1 PowerQuery_PowerPivot_DAX.pdf.pdf 7.31MB
1. Course Structure & Outline.mp4 15.22MB
1. Course Structure & Outline.vtt 2.29KB
1. Introduction.mp4 3.02MB
1. Introduction.mp4 3.17MB
1. Introduction.mp4 3.62MB
1. Introduction.mp4 2.87MB
1. Introduction.mp4 6.01MB
1. Introduction.vtt 739B
1. Introduction.vtt 621B
1. Introduction.vtt 631B
1. Introduction.vtt 598B
1. Introduction.vtt 1.08KB
1. The “Power Excel” Workflow.mp4 7.38MB
1. The “Power Excel” Workflow.vtt 4.83KB
10. HOMEWORK Logical & Text Functions.html 3.75KB
10. PRO TIP Creating a Rolling Calendar.mp4 11.08MB
10. PRO TIP Creating a Rolling Calendar.vtt 6.33KB
10. Relationship Cardinality.mp4 11.55MB
10. Relationship Cardinality.vtt 6.79KB
10. Understanding Filter Context.mp4 20.28MB
10. Understanding Filter Context.vtt 11.07KB
11. Adding Index & Conditional Columns.mp4 19.19MB
11. Adding Index & Conditional Columns.vtt 9.06KB
11. Connecting Multiple Data Tables.mp4 13.12MB
11. Connecting Multiple Data Tables.vtt 7.10KB
11. Step-by-Step Measure Calculation.mp4 29.43MB
11. Step-by-Step Measure Calculation.vtt 13.70KB
11. The CALCULATE Function.mp4 32.93MB
11. The CALCULATE Function.vtt 16.31KB
12. Adding Filter Context with FILTER (Part 1).mp4 21.28MB
12. Adding Filter Context with FILTER (Part 1).vtt 10.65KB
12. Filter Direction.mp4 10.25MB
12. Filter Direction.vtt 5.97KB
12. Grouping & Aggregating data.mp4 17.01MB
12. Grouping & Aggregating data.vtt 8.17KB
12. Recap Calculated Columns vs. Measures.mp4 4.64MB
12. Recap Calculated Columns vs. Measures.vtt 3.04KB
13. Adding Filter Context with FILTER (Part 2).mp4 37.08MB
13. Adding Filter Context with FILTER (Part 2).vtt 16.37KB
13. Hiding Fields from Client Tools.mp4 10.42MB
13. Hiding Fields from Client Tools.vtt 5.76KB
13. Pivoting & Unpivoting.mp4 18.98MB
13. Pivoting & Unpivoting.vtt 10.48KB
13. Power Pivot Best Practices.mp4 3.54MB
13. Power Pivot Best Practices.vtt 2.29KB
14. Defining Hierarchies.mp4 7.70MB
14. Defining Hierarchies.vtt 4.54KB
14. Modifying Workbook Queries.mp4 10.96MB
14. Modifying Workbook Queries.vtt 5.71KB
14. QUIZ Power Pivot & DAX 101.html 149B
14. Removing Filter Context with ALL.mp4 24.01MB
14. Removing Filter Context with ALL.vtt 10.28KB
15. Data Model Best Practices.mp4 2.98MB
15. Data Model Best Practices.vtt 2.05KB
15. HOMEWORK CALCULATE, FILTER & ALL.html 3.61KB
15. HOMEWORK Power Pivot & DAX 101.html 4.38KB
15. Merging Queries.mp4 19.13MB
15. Merging Queries.vtt 9.52KB
16. Appending Queries.mp4 14.61MB
16. Appending Queries.vtt 6.71KB
16. Joining Data with RELATED.mp4 8.32MB
16. Joining Data with RELATED.vtt 4.10KB
16. QUIZ Data Modeling 101.html 149B
17. Connecting to a Folder of Files.mp4 25.07MB
17. Connecting to a Folder of Files.vtt 11.69KB
17. HOMEWORK Data Modeling 101.html 3.11KB
17. Iterator (X) Functions SUMX.mp4 38.30MB
17. Iterator (X) Functions SUMX.vtt 13.20KB
18. Iterator (X) Functions RANKX.mp4 26.69MB
18. Iterator (X) Functions RANKX.vtt 6.10KB
18. Power Query Best Practices.mp4 5.42MB
18. Power Query Best Practices.vtt 3.50KB
19. HOMEWORK Iterator Functions.html 3.00KB
19. QUIZ Power Query.html 149B
2. Creating a Power PivotTable.mp4 11.92MB
2. Creating a Power PivotTable.vtt 6.72KB
2. Data Visualization Options.mp4 8.31MB
2. Data Visualization Options.vtt 5.99KB
2. DAX Formula Syntax & Operators.mp4 8.00MB
2. DAX Formula Syntax & Operators.vtt 5.17KB
2. IMPORTANT Versions & Compatibility.mp4 9.95MB
2. IMPORTANT Versions & Compatibility.vtt 4.10KB
2. Meet Excel's Data Model.mp4 10.47MB
2. Meet Excel's Data Model.vtt 4.72KB
2. Meet Power Query (aka “Get & Transform”).mp4 5.35MB
2. Meet Power Query (aka “Get & Transform”).vtt 3.29KB
2. The Best Thing to Happen to Excel in 20 Years.mp4 21.86MB
2. The Best Thing to Happen to Excel in 20 Years.vtt 10.56KB
20. Basic Date & Time Functions.mp4 15.77MB
20. Basic Date & Time Functions.vtt 5.61KB
20. HOMEWORK Power Query.html 3.79KB
21. Time Intelligence Formulas.mp4 62.32MB
21. Time Intelligence Formulas.vtt 17.60KB
22. HOMEWORK Time Intelligence.html 2.25KB
23. Speed & Performance Considerations.mp4 6.09MB
23. Speed & Performance Considerations.vtt 3.77KB
24. DAX Best Practices.mp4 3.81MB
24. DAX Best Practices.vtt 2.54KB
25. QUIZ Common DAX Functions.html 149B
3. Common DAX Function Categories.mp4 7.44MB
3. Common DAX Function Categories.vtt 5.10KB
3. Data vs. Diagram View.mp4 6.90MB
3. Data vs. Diagram View.vtt 3.16KB
3. Important Notes for New Students.html 3.76KB
3. Power Pivots vs. “Normal” Pivots.mp4 5.74MB
3. Power Pivots vs. “Normal” Pivots.vtt 3.59KB
3. Sneak Peek PowerBI.mp4 11.86MB
3. Sneak Peek PowerBI.vtt 7.34KB
3. The Query Editor.mp4 7.10MB
3. The Query Editor.vtt 4.08KB
3. When to use Power Query & Power Pivot.mp4 1.46MB
3. When to use Power Query & Power Pivot.vtt 887B
4.1 FoodMart_Transactions_1997.csv.csv 2.90MB
4.2 Product_Lookup.csv.csv 101.81KB
4.3 FoodMart_Transactions_1998.csv.csv 6.08MB
4.4 FoodMart_Returns_1997-1998.csv.csv 138.21KB
4.5 Region_Lookup.csv.csv 2.82KB
4.6 Calendar_Lookup.csv.csv 7.82KB
4.7 FoodMart_Data_Model_COMPLETE.xlsx.xlsx 4.27MB
4.8 Customer_Lookup.csv.csv 1.50MB
4.9 Store_Lookup.csv.csv 2.83KB
4. Basic Math & Stats Functions.mp4 36.93MB
4. Basic Math & Stats Functions.vtt 15.32KB
4. Database Normalization.mp4 8.78MB
4. Database Normalization.vtt 5.02KB
4. Data Loading Options.mp4 3.01MB
4. Data Loading Options.vtt 2.14KB
4. Downloading the Course Project Files.mp4 5.55MB
4. Downloading the Course Project Files.vtt 3.74KB
4. Intro to Data Analysis Expressions (DAX).mp4 2.49MB
4. Intro to Data Analysis Expressions (DAX).vtt 1.42KB
4. QUIZ Intro to Power Excel.html 149B
4. Resources & Next Steps.mp4 7.27MB
4. Resources & Next Steps.vtt 3.13KB
5. BONUS LECTURE More from Excel Maven.html 2.51KB
5. Calculated Columns.mp4 26.63MB
5. Calculated Columns.vtt 10.40KB
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp4 34.68MB
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.vtt 11.83KB
5. Data Tables vs. Lookup Tables.mp4 12.51MB
5. Data Tables vs. Lookup Tables.vtt 6.72KB
5. HOMEWORK Intro to Power Excel.html 783B
5. IMPORTANT Regional Settings.html 2.75KB
5. Setting Expectations.mp4 5.26MB
5. Setting Expectations.vtt 3.24KB
6. Basic Table Transformations.mp4 24.02MB
6. Basic Table Transformations.vtt 10.16KB
6. DAX Measures = Supercharged Calculated Fields.mp4 4.54MB
6. DAX Measures = Supercharged Calculated Fields.vtt 2.79KB
6. HOMEWORK Math & Stats Functions.html 3.76KB
6. Relationships vs. Merged Tables.mp4 4.46MB
6. Relationships vs. Merged Tables.vtt 2.60KB
7. Creating Implicit Measures.mp4 3.94MB
7. Creating Implicit Measures.vtt 2.43KB
7. Creating Table Relationships.mp4 15.22MB
7. Creating Table Relationships.vtt 8.80KB
7. Logical Functions (IFANDOR).mp4 51.44MB
7. Logical Functions (IFANDOR).vtt 19.01KB
7. Text-Specific Tools.mp4 29.47MB
7. Text-Specific Tools.vtt 12.54KB
8. Creating Explicit Measures (AutoSum).mp4 15.99MB
8. Creating Explicit Measures (AutoSum).vtt 9.14KB
8. Modifying Table Relationships.mp4 6.00MB
8. Modifying Table Relationships.vtt 2.61KB
8. Number-Specific Tools.mp4 22.07MB
8. Number-Specific Tools.vtt 9.19KB
8. SWITCH & SWITCH(TRUE).mp4 25.27MB
8. SWITCH & SWITCH(TRUE).vtt 11.44KB
9. Active vs. Inactive Relationships.mp4 8.65MB
9. Active vs. Inactive Relationships.vtt 4.74KB
9. Creating Explicit Measures (Power Pivot).mp4 17.51MB
9. Creating Explicit Measures (Power Pivot).vtt 9.92KB
9. Date-Specific Tools.mp4 20.13MB
9. Date-Specific Tools.vtt 9.12KB
9. Text Functions.mp4 31.57MB
9. Text Functions.vtt 12.80KB
Distribution statistics by country
Ukraine (UA) 2
France (FR) 1
Mexico (MX) 1
Vietnam (VN) 1
Total 5
IP List List of IP addresses which were distributed this torrent