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 |