|
|
1. Course Structure & Outline.mp4
|
MP4
|
15.2 MB
|
|
|
1. Course Structure & Outline.vtt
|
VTT
|
2.3 KB
|
|
|
1. Introduction.mp4
|
MP4
|
6 MB
|
|
|
1. Introduction.vtt
|
VTT
|
1.1 KB
|
|
|
1. The “Power Excel” Workflow.mp4
|
MP4
|
7.4 MB
|
|
|
1. The “Power Excel” Workflow.vtt
|
VTT
|
4.8 KB
|
|
|
1.1 PowerQuery_PowerPivot_DAX.pdf.pdf
|
PDF
|
7.3 MB
|
|
|
10. HOMEWORK Logical & Text Functions.html
|
HTML
|
3.7 KB
|
|
|
10. PRO TIP Creating a Rolling Calendar.mp4
|
MP4
|
11.1 MB
|
|
|
10. PRO TIP Creating a Rolling Calendar.vtt
|
VTT
|
6.3 KB
|
|
|
10. Relationship Cardinality.mp4
|
MP4
|
11.6 MB
|
|
|
10. Relationship Cardinality.vtt
|
VTT
|
6.8 KB
|
|
|
10. Understanding Filter Context.mp4
|
MP4
|
20.3 MB
|
|
|
10. Understanding Filter Context.vtt
|
VTT
|
11.1 KB
|
|
|
11. Adding Index & Conditional Columns.mp4
|
MP4
|
19.2 MB
|
|
|
11. Adding Index & Conditional Columns.vtt
|
VTT
|
9.1 KB
|
|
|
11. Connecting Multiple Data Tables.mp4
|
MP4
|
13.1 MB
|
|
|
11. Connecting Multiple Data Tables.vtt
|
VTT
|
7.1 KB
|
|
|
11. Step-by-Step Measure Calculation.mp4
|
MP4
|
29.4 MB
|
|
|
11. Step-by-Step Measure Calculation.vtt
|
VTT
|
13.7 KB
|
|
|
11. The CALCULATE Function.mp4
|
MP4
|
32.9 MB
|
|
|
11. The CALCULATE Function.vtt
|
VTT
|
16.3 KB
|
|
|
12. Adding Filter Context with FILTER (Part 1).mp4
|
MP4
|
21.3 MB
|
|
|
12. Adding Filter Context with FILTER (Part 1).vtt
|
VTT
|
10.7 KB
|
|
|
12. Filter Direction.mp4
|
MP4
|
10.2 MB
|
|
|
12. Filter Direction.vtt
|
VTT
|
6 KB
|
|
|
12. Grouping & Aggregating data.mp4
|
MP4
|
17 MB
|
|
|
12. Grouping & Aggregating data.vtt
|
VTT
|
8.2 KB
|
|
|
12. Recap Calculated Columns vs. Measures.mp4
|
MP4
|
4.6 MB
|
|
|
12. Recap Calculated Columns vs. Measures.vtt
|
VTT
|
3 KB
|
|
|
13. Adding Filter Context with FILTER (Part 2).mp4
|
MP4
|
37.1 MB
|
|
|
13. Adding Filter Context with FILTER (Part 2).vtt
|
VTT
|
16.4 KB
|
|
|
13. Hiding Fields from Client Tools.mp4
|
MP4
|
10.4 MB
|
|
|
13. Hiding Fields from Client Tools.vtt
|
VTT
|
5.8 KB
|
|
|
13. Pivoting & Unpivoting.mp4
|
MP4
|
19 MB
|
|
|
13. Pivoting & Unpivoting.vtt
|
VTT
|
10.5 KB
|
|
|
13. Power Pivot Best Practices.mp4
|
MP4
|
3.5 MB
|
|
|
13. Power Pivot Best Practices.vtt
|
VTT
|
2.3 KB
|
|
|
14. Defining Hierarchies.mp4
|
MP4
|
7.7 MB
|
|
|
14. Defining Hierarchies.vtt
|
VTT
|
4.5 KB
|
|
|
14. Modifying Workbook Queries.mp4
|
MP4
|
11 MB
|
|
|
14. Modifying Workbook Queries.vtt
|
VTT
|
5.7 KB
|
|
|
14. QUIZ Power Pivot & DAX 101.html
|
HTML
|
102.4 B
|
|
|
14. Removing Filter Context with ALL.mp4
|
MP4
|
24 MB
|
|
|
14. Removing Filter Context with ALL.vtt
|
VTT
|
10.3 KB
|
|
|
15. Data Model Best Practices.mp4
|
MP4
|
3 MB
|
|
|
15. Data Model Best Practices.vtt
|
VTT
|
2.1 KB
|
|
|
15. HOMEWORK CALCULATE, FILTER & ALL.html
|
HTML
|
3.6 KB
|
|
|
15. HOMEWORK Power Pivot & DAX 101.html
|
HTML
|
4.4 KB
|
|
|
15. Merging Queries.mp4
|
MP4
|
19.1 MB
|
|
|
15. Merging Queries.vtt
|
VTT
|
9.5 KB
|
|
|
16. Appending Queries.mp4
|
MP4
|
14.6 MB
|
|
|
16. Appending Queries.vtt
|
VTT
|
6.7 KB
|
|
|
16. Joining Data with RELATED.mp4
|
MP4
|
8.3 MB
|
|
|
16. Joining Data with RELATED.vtt
|
VTT
|
4.1 KB
|
|
|
16. QUIZ Data Modeling 101.html
|
HTML
|
102.4 B
|
|
|
17. Connecting to a Folder of Files.mp4
|
MP4
|
25.1 MB
|
|
|
17. Connecting to a Folder of Files.vtt
|
VTT
|
11.7 KB
|
|
|
17. HOMEWORK Data Modeling 101.html
|
HTML
|
3.1 KB
|
|
|
17. Iterator (X) Functions SUMX.mp4
|
MP4
|
38.3 MB
|
|
|
17. Iterator (X) Functions SUMX.vtt
|
VTT
|
13.2 KB
|
|
|
18. Iterator (X) Functions RANKX.mp4
|
MP4
|
26.7 MB
|
|
|
18. Iterator (X) Functions RANKX.vtt
|
VTT
|
6.1 KB
|
|
|
18. Power Query Best Practices.mp4
|
MP4
|
5.4 MB
|
|
|
18. Power Query Best Practices.vtt
|
VTT
|
3.5 KB
|
|
|
19. HOMEWORK Iterator Functions.html
|
HTML
|
3 KB
|
|
|
19. QUIZ Power Query.html
|
HTML
|
102.4 B
|
|
|
2. Creating a Power PivotTable.mp4
|
MP4
|
11.9 MB
|
|
|
2. Creating a Power PivotTable.vtt
|
VTT
|
6.7 KB
|
|
|
2. DAX Formula Syntax & Operators.mp4
|
MP4
|
8 MB
|
|
|
2. DAX Formula Syntax & Operators.vtt
|
VTT
|
5.2 KB
|
|
|
2. Data Visualization Options.mp4
|
MP4
|
8.3 MB
|
|
|
2. Data Visualization Options.vtt
|
VTT
|
6 KB
|
|
|
2. IMPORTANT Versions & Compatibility.mp4
|
MP4
|
10 MB
|
|
|
2. IMPORTANT Versions & Compatibility.vtt
|
VTT
|
4.1 KB
|
|
|
2. Meet Excel's Data Model.mp4
|
MP4
|
10.5 MB
|
|
|
2. Meet Excel's Data Model.vtt
|
VTT
|
4.7 KB
|
|
|
2. Meet Power Query (aka “Get & Transform”).mp4
|
MP4
|
5.4 MB
|
|
|
2. Meet Power Query (aka “Get & Transform”).vtt
|
VTT
|
3.3 KB
|
|
|
2. The Best Thing to Happen to Excel in 20 Years.mp4
|
MP4
|
21.9 MB
|
|
|
2. The Best Thing to Happen to Excel in 20 Years.vtt
|
VTT
|
10.6 KB
|
|
|
20. Basic Date & Time Functions.mp4
|
MP4
|
15.8 MB
|
|
|
20. Basic Date & Time Functions.vtt
|
VTT
|
5.6 KB
|
|
|
20. HOMEWORK Power Query.html
|
HTML
|
3.8 KB
|
|
|
21. Time Intelligence Formulas.mp4
|
MP4
|
62.3 MB
|
|
|
21. Time Intelligence Formulas.vtt
|
VTT
|
17.6 KB
|
|
|
22. HOMEWORK Time Intelligence.html
|
HTML
|
2.3 KB
|
|
|
23. Speed & Performance Considerations.mp4
|
MP4
|
6.1 MB
|
|
|
23. Speed & Performance Considerations.vtt
|
VTT
|
3.8 KB
|
|
|
24. DAX Best Practices.mp4
|
MP4
|
3.8 MB
|
|
|
24. DAX Best Practices.vtt
|
VTT
|
2.5 KB
|
|
|
25. QUIZ Common DAX Functions.html
|
HTML
|
102.4 B
|
|
|
3. Common DAX Function Categories.mp4
|
MP4
|
7.4 MB
|
|
|
3. Common DAX Function Categories.vtt
|
VTT
|
5.1 KB
|
|
|
3. Data vs. Diagram View.mp4
|
MP4
|
6.9 MB
|
|
|
3. Data vs. Diagram View.vtt
|
VTT
|
3.2 KB
|
|
|
3. Important Notes for New Students.html
|
HTML
|
3.8 KB
|
|
|
3. Power Pivots vs. “Normal” Pivots.mp4
|
MP4
|
5.7 MB
|
|
|
3. Power Pivots vs. “Normal” Pivots.vtt
|
VTT
|
3.6 KB
|
|
|
3. Sneak Peek PowerBI.mp4
|
MP4
|
11.9 MB
|
|
|
3. Sneak Peek PowerBI.vtt
|
VTT
|
7.3 KB
|
|
|
3. The Query Editor.mp4
|
MP4
|
7.1 MB
|
|
|
3. The Query Editor.vtt
|
VTT
|
4.1 KB
|
|
|
3. When to use Power Query & Power Pivot.mp4
|
MP4
|
1.5 MB
|
|
|
3. When to use Power Query & Power Pivot.vtt
|
VTT
|
921.6 B
|
|
|
4. Basic Math & Stats Functions.mp4
|
MP4
|
36.9 MB
|
|
|
4. Basic Math & Stats Functions.vtt
|
VTT
|
15.3 KB
|
|
|
4. Data Loading Options.mp4
|
MP4
|
3 MB
|
|
|
4. Data Loading Options.vtt
|
VTT
|
2.1 KB
|
|
|
4. Database Normalization.mp4
|
MP4
|
8.8 MB
|
|
|
4. Database Normalization.vtt
|
VTT
|
5 KB
|
|
|
4. Downloading the Course Project Files.mp4
|
MP4
|
5.6 MB
|
|
|
4. Downloading the Course Project Files.vtt
|
VTT
|
3.7 KB
|
|
|
4. Intro to Data Analysis Expressions (DAX).mp4
|
MP4
|
2.5 MB
|
|
|
4. Intro to Data Analysis Expressions (DAX).vtt
|
VTT
|
1.4 KB
|
|
|
4. QUIZ Intro to Power Excel.html
|
HTML
|
102.4 B
|
|
|
4. Resources & Next Steps.mp4
|
MP4
|
7.3 MB
|
|
|
4. Resources & Next Steps.vtt
|
VTT
|
3.1 KB
|
|
|
4.1 FoodMart_Transactions_1997.csv.csv
|
CSV
|
2.9 MB
|
|
|
4.2 Product_Lookup.csv.csv
|
CSV
|
101.8 KB
|
|
|
4.3 FoodMart_Transactions_1998.csv.csv
|
CSV
|
6.1 MB
|
|
|
4.4 FoodMart_Returns_1997-1998.csv.csv
|
CSV
|
138.2 KB
|
|
|
4.5 Region_Lookup.csv.csv
|
CSV
|
2.8 KB
|
|
|
4.6 Calendar_Lookup.csv.csv
|
CSV
|
7.8 KB
|
|
|
4.7 FoodMart_Data_Model_COMPLETE.xlsx.xlsx
|
XLSX
|
4.3 MB
|
|
|
4.8 Customer_Lookup.csv.csv
|
CSV
|
1.5 MB
|
|
|
4.9 Store_Lookup.csv.csv
|
CSV
|
2.8 KB
|
|
|
5. BONUS LECTURE More from Excel Maven.html
|
HTML
|
2.5 KB
|
|
|
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp4
|
MP4
|
34.7 MB
|
|
|
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.vtt
|
VTT
|
11.8 KB
|
|
|
5. Calculated Columns.mp4
|
MP4
|
26.6 MB
|
|
|
5. Calculated Columns.vtt
|
VTT
|
10.4 KB
|
|
|
5. Data Tables vs. Lookup Tables.mp4
|
MP4
|
12.5 MB
|
|
|
5. Data Tables vs. Lookup Tables.vtt
|
VTT
|
6.7 KB
|
|
|
5. HOMEWORK Intro to Power Excel.html
|
HTML
|
819.2 B
|
|
|
5. IMPORTANT Regional Settings.html
|
HTML
|
2.7 KB
|
|
|
5. Setting Expectations.mp4
|
MP4
|
5.3 MB
|
|
|
5. Setting Expectations.vtt
|
VTT
|
3.2 KB
|
|
|
6. Basic Table Transformations.mp4
|
MP4
|
24 MB
|
|
|
6. Basic Table Transformations.vtt
|
VTT
|
10.2 KB
|
|
|
6. DAX Measures = Supercharged Calculated Fields.mp4
|
MP4
|
4.5 MB
|
|
|
6. DAX Measures = Supercharged Calculated Fields.vtt
|
VTT
|
2.8 KB
|
|
|
6. HOMEWORK Math & Stats Functions.html
|
HTML
|
3.8 KB
|
|
|
6. Relationships vs. Merged Tables.mp4
|
MP4
|
4.5 MB
|
|
|
6. Relationships vs. Merged Tables.vtt
|
VTT
|
2.6 KB
|
|
|
7. Creating Implicit Measures.mp4
|
MP4
|
3.9 MB
|
|
|
7. Creating Implicit Measures.vtt
|
VTT
|
2.4 KB
|
|
|
7. Creating Table Relationships.mp4
|
MP4
|
15.2 MB
|
|
|
7. Creating Table Relationships.vtt
|
VTT
|
8.8 KB
|
|
|
7. Logical Functions (IFANDOR).mp4
|
MP4
|
51.4 MB
|
|
|
7. Logical Functions (IFANDOR).vtt
|
VTT
|
19 KB
|
|
|
7. Text-Specific Tools.mp4
|
MP4
|
29.5 MB
|
|
|
7. Text-Specific Tools.vtt
|
VTT
|
12.5 KB
|
|
|
8. Creating Explicit Measures (AutoSum).mp4
|
MP4
|
16 MB
|
|
|
8. Creating Explicit Measures (AutoSum).vtt
|
VTT
|
9.1 KB
|
|
|
8. Modifying Table Relationships.mp4
|
MP4
|
6 MB
|
|
|
8. Modifying Table Relationships.vtt
|
VTT
|
2.6 KB
|
|
|
8. Number-Specific Tools.mp4
|
MP4
|
22.1 MB
|
|
|
8. Number-Specific Tools.vtt
|
VTT
|
9.2 KB
|
|
|
8. SWITCH & SWITCH(TRUE).mp4
|
MP4
|
25.3 MB
|
|
|
8. SWITCH & SWITCH(TRUE).vtt
|
VTT
|
11.4 KB
|
|
|
9. Active vs. Inactive Relationships.mp4
|
MP4
|
8.6 MB
|
|
|
9. Active vs. Inactive Relationships.vtt
|
VTT
|
4.7 KB
|
|
|
9. Creating Explicit Measures (Power Pivot).mp4
|
MP4
|
17.5 MB
|
|
|
9. Creating Explicit Measures (Power Pivot).vtt
|
VTT
|
9.9 KB
|
|
|
9. Date-Specific Tools.mp4
|
MP4
|
20.1 MB
|
|
|
9. Date-Specific Tools.vtt
|
VTT
|
9.1 KB
|
|
|
9. Text Functions.mp4
|
MP4
|
31.6 MB
|
|
|
9. Text Functions.vtt
|
VTT
|
12.8 KB
|
|
|
[FreeCourseLab.com].url
|
URL
|
102.4 B
|
