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