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