Filename | Size |
| 1. Getting Started/1. Course Structure & Outline.mp4 | 15.2 MB |
| 1. Getting Started/1. Course Structure & Outline.vtt | 2.3 KB |
| 1. Getting Started/1.1 PowerQuery_PowerPivot_DAX.pdf.pdf | 7.3 MB |
| 1. Getting Started/2. IMPORTANT Versions & Compatibility.mp4 | 10 MB |
| 1. Getting Started/2. IMPORTANT Versions & Compatibility.vtt | 4.1 KB |
| 1. Getting Started/3. Important Notes for New Students.html | 3.8 KB |
| 1. Getting Started/4. Downloading the Course Project Files.mp4 | 5.6 MB |
| 1. Getting Started/4. Downloading the Course Project Files.vtt | 3.7 KB |
| 1. Getting Started/4.1 FoodMart_Transactions_1997.csv.csv | 2.9 MB |
| 1. Getting Started/4.2 Product_Lookup.csv.csv | 101.8 KB |
| 1. Getting Started/4.3 FoodMart_Transactions_1998.csv.csv | 6.1 MB |
| 1. Getting Started/4.4 FoodMart_Returns_1997-1998.csv.csv | 138.2 KB |
| 1. Getting Started/4.5 Region_Lookup.csv.csv | 2.8 KB |
| 1. Getting Started/4.6 Calendar_Lookup.csv.csv | 7.8 KB |
| 1. Getting Started/4.7 FoodMart_Data_Model_COMPLETE.xlsx.xlsx | 4.3 MB |
| 1. Getting Started/4.8 Customer_Lookup.csv.csv | 1.5 MB |
| 1. Getting Started/4.9 Store_Lookup.csv.csv | 2.8 KB |
| 1. Getting Started/5. Setting Expectations.mp4 | 5.3 MB |
| 1. Getting Started/5. Setting Expectations.vtt | 3.2 KB |
| 2. Intro to “Power Excel/1. The “Power Excel” Workflow.mp4 | 7.4 MB |
| 2. Intro to “Power Excel/1. The “Power Excel” Workflow.vtt | 4.8 KB |
| 2. Intro to “Power Excel/2. The Best Thing to Happen to Excel in 20 Years.mp4 | 21.9 MB |
| 2. Intro to “Power Excel/2. The Best Thing to Happen to Excel in 20 Years.vtt | 10.6 KB |
| 2. Intro to “Power Excel/3. When to use Power Query & Power Pivot.mp4 | 1.5 MB |
| 2. Intro to “Power Excel/3. When to use Power Query & Power Pivot.vtt | 887 B |
| 2. Intro to “Power Excel/4. QUIZ Intro to Power Excel.html | 149 B |
| 2. Intro to “Power Excel/5. HOMEWORK Intro to Power Excel.html | 783 B |
| 3. Power Query/1. Introduction.mp4 | 3 MB |
| 3. Power Query/1. Introduction.vtt | 739 B |
| 3. Power Query/10. PRO TIP Creating a Rolling Calendar.mp4 | 11.1 MB |
| 3. Power Query/10. PRO TIP Creating a Rolling Calendar.vtt | 6.3 KB |
| 3. Power Query/11. Adding Index & Conditional Columns.mp4 | 19.2 MB |
| 3. Power Query/11. Adding Index & Conditional Columns.vtt | 9.1 KB |
| 3. Power Query/12. Grouping & Aggregating data.mp4 | 17 MB |
| 3. Power Query/12. Grouping & Aggregating data.vtt | 8.2 KB |
| 3. Power Query/13. Pivoting & Unpivoting.mp4 | 19 MB |
| 3. Power Query/13. Pivoting & Unpivoting.vtt | 10.5 KB |
| 3. Power Query/14. Modifying Workbook Queries.mp4 | 11 MB |
| 3. Power Query/14. Modifying Workbook Queries.vtt | 5.7 KB |
| 3. Power Query/15. Merging Queries.mp4 | 19.1 MB |
| 3. Power Query/15. Merging Queries.vtt | 9.5 KB |
| 3. Power Query/16. Appending Queries.mp4 | 14.6 MB |
| 3. Power Query/16. Appending Queries.vtt | 6.7 KB |
| 3. Power Query/17. Connecting to a Folder of Files.mp4 | 25.1 MB |
| 3. Power Query/17. Connecting to a Folder of Files.vtt | 11.7 KB |
| 3. Power Query/18. Power Query Best Practices.mp4 | 5.4 MB |
| 3. Power Query/18. Power Query Best Practices.vtt | 3.5 KB |
| 3. Power Query/19. QUIZ Power Query.html | 149 B |
| 3. Power Query/2. Meet Power Query (aka “Get & Transform”).mp4 | 5.4 MB |
| 3. Power Query/2. Meet Power Query (aka “Get & Transform”).vtt | 3.3 KB |
| 3. Power Query/20. HOMEWORK Power Query.html | 3.8 KB |
| 3. Power Query/3. The Query Editor.mp4 | 7.1 MB |
| 3. Power Query/3. The Query Editor.vtt | 4.1 KB |
| 3. Power Query/4. Data Loading Options.mp4 | 3 MB |
| 3. Power Query/4. Data Loading Options.vtt | 2.1 KB |
| 3. Power Query/5. IMPORTANT Regional Settings.html | 2.7 KB |
| 3. Power Query/6. Basic Table Transformations.mp4 | 24 MB |
| 3. Power Query/6. Basic Table Transformations.vtt | 10.2 KB |
| 3. Power Query/7. Text-Specific Tools.mp4 | 29.5 MB |
| 3. Power Query/7. Text-Specific Tools.vtt | 12.5 KB |
| 3. Power Query/8. Number-Specific Tools.mp4 | 22.1 MB |
| 3. Power Query/8. Number-Specific Tools.vtt | 9.2 KB |
| 3. Power Query/9. Date-Specific Tools.mp4 | 20.1 MB |
| 3. Power Query/9. Date-Specific Tools.vtt | 9.1 KB |
| 4. Data Modeling 101/1. Introduction.mp4 | 3.2 MB |
| 4. Data Modeling 101/1. Introduction.vtt | 621 B |
| 4. Data Modeling 101/10. Relationship Cardinality.mp4 | 11.6 MB |
| 4. Data Modeling 101/10. Relationship Cardinality.vtt | 6.8 KB |
| 4. Data Modeling 101/11. Connecting Multiple Data Tables.mp4 | 13.1 MB |
| 4. Data Modeling 101/11. Connecting Multiple Data Tables.vtt | 7.1 KB |
| 4. Data Modeling 101/12. Filter Direction.mp4 | 10.2 MB |
| 4. Data Modeling 101/12. Filter Direction.vtt | 6 KB |
| 4. Data Modeling 101/13. Hiding Fields from Client Tools.mp4 | 10.4 MB |
| 4. Data Modeling 101/13. Hiding Fields from Client Tools.vtt | 5.8 KB |
| 4. Data Modeling 101/14. Defining Hierarchies.mp4 | 7.7 MB |
| 4. Data Modeling 101/14. Defining Hierarchies.vtt | 4.5 KB |
| 4. Data Modeling 101/15. Data Model Best Practices.mp4 | 3 MB |
| 4. Data Modeling 101/15. Data Model Best Practices.vtt | 2.1 KB |
| 4. Data Modeling 101/16. QUIZ Data Modeling 101.html | 149 B |
| 4. Data Modeling 101/17. HOMEWORK Data Modeling 101.html | 3.1 KB |
| 4. Data Modeling 101/2. Meet Excel's Data Model.mp4 | 10.5 MB |
| 4. Data Modeling 101/2. Meet Excel's Data Model.vtt | 4.7 KB |
| 4. Data Modeling 101/3. Data vs. Diagram View.mp4 | 6.9 MB |
| 4. Data Modeling 101/3. Data vs. Diagram View.vtt | 3.2 KB |
| 4. Data Modeling 101/4. Database Normalization.mp4 | 8.8 MB |
| 4. Data Modeling 101/4. Database Normalization.vtt | 5 KB |
| 4. Data Modeling 101/5. Data Tables vs. Lookup Tables.mp4 | 12.5 MB |
| 4. Data Modeling 101/5. Data Tables vs. Lookup Tables.vtt | 6.7 KB |
| 4. Data Modeling 101/6. Relationships vs. Merged Tables.mp4 | 4.5 MB |
| 4. Data Modeling 101/6. Relationships vs. Merged Tables.vtt | 2.6 KB |
| 4. Data Modeling 101/7. Creating Table Relationships.mp4 | 15.2 MB |
| 4. Data Modeling 101/7. Creating Table Relationships.vtt | 8.8 KB |
| 4. Data Modeling 101/8. Modifying Table Relationships.mp4 | 6 MB |
| 4. Data Modeling 101/8. Modifying Table Relationships.vtt | 2.6 KB |
| 4. Data Modeling 101/9. Active vs. Inactive Relationships.mp4 | 8.6 MB |
| 4. Data Modeling 101/9. Active vs. Inactive Relationships.vtt | 4.7 KB |
| 5. Power Pivot & DAX 101/1. Introduction.mp4 | 3.6 MB |
| 5. Power Pivot & DAX 101/1. Introduction.vtt | 631 B |
| 5. Power Pivot & DAX 101/10. Understanding Filter Context.mp4 | 20.3 MB |