Udemy - Microsoft Excel – Intro To Power Query, Power Pivot & DAX

seeders: 29
leechers: 7
updated:
Added by CourseClub in Other > Tutorials

Download Fast Safe Anonymous
movies, software, shows...

Files

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

Description

Microsoft Excel – Intro To Power Query, Power Pivot & DAX

Get up & running with Excel’s powerful data modeling & business intelligence tools, with a best-selling Excel instructor

For More Courses Visit: https://desirecourse.com



Download torrent
1.1 GB
seeders:29
leechers:7
Udemy - Microsoft Excel – Intro To Power Query, Power Pivot & DAX


Trackers

tracker name
udp://tracker.opentrackr.org:1337/announce
µTorrent compatible trackers list

Download torrent
1.1 GB
seeders:29
leechers:7
Udemy - Microsoft Excel – Intro To Power Query, Power Pivot & DAX


Torrent hash: 3AA36024B469B11EC44DA51E3FC528BE4D2162F6