[FreeCourseLab com] Udemy - Microsoft Excel - Intro to Power Query, Power Pivot & DAX
File List
| 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.1 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.9 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.5 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 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.02 MB |
| 3. Power Query/1. Introduction.vtt | 739 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.5 KB |
| 3. Power Query/19. QUIZ Power Query.html | 149 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.1 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 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.1 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.7 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 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.9 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.6 KB |
| 4. Data Modeling 101/7. Creating Table Relationships.mp4 | 15.22 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.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 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 |
Trackers
No trackers found.