FreeCourseLab com Udemy Microsoft Excel Intro to Power Query Power Pivot DAX

FreeCourseLab com Udemy Microsoft Excel Intro to Power Query Power Pivot DAX

Name	[FreeCourseLab.com] Udemy - Microsoft Excel - Intro to Power Query, Power Pivot & DAX	DOWNLOAD Copy Link
Total Size	1.2 GB
Total Files	178
Last Seen	2024-11-14 23:47
Hash	402481D3425202411F0FAC98812B10A931974134

/1. Getting Started/
1. Course Structure & Outline.mp4	16.0 MB
1. Course Structure & Outline.vtt	2.3 KB
1.1 PowerQuery_PowerPivot_DAX.pdf.pdf	7.7 MB
2. IMPORTANT Versions & Compatibility.mp4	10.4 MB
2. IMPORTANT Versions & Compatibility.vtt	4.2 KB
3. Important Notes for New Students.html	3.9 KB
4. Downloading the Course Project Files.mp4	5.8 MB
4. Downloading the Course Project Files.vtt	3.8 KB
4.1 FoodMart_Transactions_1997.csv.csv	3.0 MB
4.2 Product_Lookup.csv.csv	104.3 KB
4.3 FoodMart_Transactions_1998.csv.csv	6.4 MB
4.4 FoodMart_Returns_1997-1998.csv.csv	141.5 KB
4.5 Region_Lookup.csv.csv	2.9 KB
4.6 Calendar_Lookup.csv.csv	8.0 KB
4.7 FoodMart_Data_Model_COMPLETE.xlsx.xlsx	4.5 MB
4.8 Customer_Lookup.csv.csv	1.6 MB
4.9 Store_Lookup.csv.csv	2.9 KB
5. Setting Expectations.mp4	5.5 MB
5. Setting Expectations.vtt	3.3 KB
/2. Intro to “Power Excel/
1. The “Power Excel” Workflow.mp4	7.7 MB
1. The “Power Excel” Workflow.vtt	5.0 KB
2. The Best Thing to Happen to Excel in 20 Years.mp4	22.9 MB
2. The Best Thing to Happen to Excel in 20 Years.vtt	10.8 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.2 MB
1. Introduction.vtt	0.7 KB
10. PRO TIP Creating a Rolling Calendar.mp4	11.6 MB
10. PRO TIP Creating a Rolling Calendar.vtt	6.5 KB
11. Adding Index & Conditional Columns.mp4	20.1 MB
11. Adding Index & Conditional Columns.vtt	9.3 KB
12. Grouping & Aggregating data.mp4	17.8 MB
12. Grouping & Aggregating data.vtt	8.4 KB
13. Pivoting & Unpivoting.mp4	19.9 MB
13. Pivoting & Unpivoting.vtt	10.7 KB
14. Modifying Workbook Queries.mp4	11.5 MB
14. Modifying Workbook Queries.vtt	5.8 KB
15. Merging Queries.mp4	20.1 MB
15. Merging Queries.vtt	9.7 KB
16. Appending Queries.mp4	15.3 MB
16. Appending Queries.vtt	6.9 KB
17. Connecting to a Folder of Files.mp4	26.3 MB
17. Connecting to a Folder of Files.vtt	12.0 KB
18. Power Query Best Practices.mp4	5.7 MB
18. Power Query Best Practices.vtt	3.6 KB
19. QUIZ Power Query.html	0.1 KB
2. Meet Power Query (aka “Get & Transform”).mp4	5.6 MB
2. Meet Power Query (aka “Get & Transform”).vtt	3.4 KB
20. HOMEWORK Power Query.html	3.9 KB
3. The Query Editor.mp4	7.4 MB
3. The Query Editor.vtt	4.2 KB
4. Data Loading Options.mp4	3.2 MB
4. Data Loading Options.vtt	2.2 KB
5. IMPORTANT Regional Settings.html	2.8 KB
6. Basic Table Transformations.mp4	25.2 MB
6. Basic Table Transformations.vtt	10.4 KB
7. Text-Specific Tools.mp4	30.9 MB
7. Text-Specific Tools.vtt	12.8 KB
8. Number-Specific Tools.mp4	23.1 MB
8. Number-Specific Tools.vtt	9.4 KB
9. Date-Specific Tools.mp4	21.1 MB
9. Date-Specific Tools.vtt	9.3 KB
/4. Data Modeling 101/
1. Introduction.mp4	3.3 MB
1. Introduction.vtt	0.6 KB
10. Relationship Cardinality.mp4	12.1 MB
10. Relationship Cardinality.vtt	7.0 KB
11. Connecting Multiple Data Tables.mp4	13.8 MB
11. Connecting Multiple Data Tables.vtt	7.3 KB
12. Filter Direction.mp4	10.7 MB
12. Filter Direction.vtt	6.1 KB
13. Hiding Fields from Client Tools.mp4	10.9 MB
13. Hiding Fields from Client Tools.vtt	5.9 KB
14. Defining Hierarchies.mp4	8.1 MB
14. Defining Hierarchies.vtt	4.7 KB
15. Data Model Best Practices.mp4	3.1 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.2 KB
2. Meet Excel's Data Model.mp4	11.0 MB
2. Meet Excel's Data Model.vtt	4.8 KB
3. Data vs. Diagram View.mp4	7.2 MB
3. Data vs. Diagram View.vtt	3.2 KB
4. Database Normalization.mp4	9.2 MB
4. Database Normalization.vtt	5.1 KB
5. Data Tables vs. Lookup Tables.mp4	13.1 MB
5. Data Tables vs. Lookup Tables.vtt	6.9 KB
6. Relationships vs. Merged Tables.mp4	4.7 MB
6. Relationships vs. Merged Tables.vtt	2.7 KB
7. Creating Table Relationships.mp4	16.0 MB
7. Creating Table Relationships.vtt	9.0 KB
8. Modifying Table Relationships.mp4	6.3 MB
8. Modifying Table Relationships.vtt	2.7 KB
9. Active vs. Inactive Relationships.mp4	9.1 MB
9. Active vs. Inactive Relationships.vtt	4.9 KB
/5. Power Pivot & DAX 101/
1. Introduction.mp4	3.8 MB
1. Introduction.vtt	0.6 KB
10. Understanding Filter Context.mp4	21.3 MB
10. Understanding Filter Context.vtt	11.3 KB
11. Step-by-Step Measure Calculation.mp4	30.9 MB
11. Step-by-Step Measure Calculation.vtt	14.0 KB
12. Recap Calculated Columns vs. Measures.mp4	4.9 MB
12. Recap Calculated Columns vs. Measures.vtt	3.1 KB
13. Power Pivot Best Practices.mp4	3.7 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.5 KB
2. Creating a Power PivotTable.mp4	12.5 MB
2. Creating a Power PivotTable.vtt	6.9 KB
3. Power Pivots vs. “Normal” Pivots.mp4	6.0 MB
3. Power Pivots vs. “Normal” Pivots.vtt	3.7 KB
4. Intro to Data Analysis Expressions (DAX).mp4	2.6 MB
4. Intro to Data Analysis Expressions (DAX).vtt	1.5 KB
5. Calculated Columns.mp4	27.9 MB
5. Calculated Columns.vtt	10.6 KB
6. DAX Measures = Supercharged Calculated Fields.mp4	4.8 MB
6. DAX Measures = Supercharged Calculated Fields.vtt	2.9 KB
7. Creating Implicit Measures.mp4	4.1 MB
7. Creating Implicit Measures.vtt	2.5 KB
8. Creating Explicit Measures (AutoSum).mp4	16.8 MB
8. Creating Explicit Measures (AutoSum).vtt	9.4 KB
9. Creating Explicit Measures (Power Pivot).mp4	18.4 MB
9. Creating Explicit Measures (Power Pivot).vtt	10.2 KB
/6. Common DAX Functions/
1. Introduction.mp4	3.0 MB
1. Introduction.vtt	0.6 KB
10. HOMEWORK Logical & Text Functions.html	3.8 KB
11. The CALCULATE Function.mp4	34.5 MB
11. The CALCULATE Function.vtt	16.7 KB
12. Adding Filter Context with FILTER (Part 1).mp4	22.3 MB
12. Adding Filter Context with FILTER (Part 1).vtt	10.9 KB
13. Adding Filter Context with FILTER (Part 2).mp4	38.9 MB
13. Adding Filter Context with FILTER (Part 2).vtt	16.8 KB
14. Removing Filter Context with ALL.mp4	25.2 MB
14. Removing Filter Context with ALL.vtt	10.5 KB
15. HOMEWORK CALCULATE, FILTER & ALL.html	3.7 KB
16. Joining Data with RELATED.mp4	8.7 MB
16. Joining Data with RELATED.vtt	4.2 KB
17. Iterator (X) Functions SUMX.mp4	40.2 MB
17. Iterator (X) Functions SUMX.vtt	13.5 KB
18. Iterator (X) Functions RANKX.mp4	28.0 MB
18. Iterator (X) Functions RANKX.vtt	6.2 KB
19. HOMEWORK Iterator Functions.html	3.1 KB
2. DAX Formula Syntax & Operators.mp4	8.4 MB
2. DAX Formula Syntax & Operators.vtt	5.3 KB
20. Basic Date & Time Functions.mp4	16.5 MB
20. Basic Date & Time Functions.vtt	5.7 KB
21. Time Intelligence Formulas.mp4	65.4 MB
21. Time Intelligence Formulas.vtt	18.0 KB
22. HOMEWORK Time Intelligence.html	2.3 KB
23. Speed & Performance Considerations.mp4	6.4 MB
23. Speed & Performance Considerations.vtt	3.9 KB
24. DAX Best Practices.mp4	4.0 MB
24. DAX Best Practices.vtt	2.6 KB
25. QUIZ Common DAX Functions.html	0.1 KB
3. Common DAX Function Categories.mp4	7.8 MB
3. Common DAX Function Categories.vtt	5.2 KB
4. Basic Math & Stats Functions.mp4	38.7 MB
4. Basic Math & Stats Functions.vtt	15.7 KB
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.mp4	36.4 MB
5. COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS.vtt	12.1 KB
6. HOMEWORK Math & Stats Functions.html	3.9 KB
7. Logical Functions (IFANDOR).mp4	53.9 MB
7. Logical Functions (IFANDOR).vtt	19.5 KB
8. SWITCH & SWITCH(TRUE).mp4	26.5 MB
8. SWITCH & SWITCH(TRUE).vtt	11.7 KB
9. Text Functions.mp4	33.1 MB
9. Text Functions.vtt	13.1 KB
/7. Wrapping Up/
1. Introduction.mp4	6.3 MB
1. Introduction.vtt	1.1 KB
2. Data Visualization Options.mp4	8.7 MB
2. Data Visualization Options.vtt	6.1 KB
3. Sneak Peek PowerBI.mp4	12.4 MB
3. Sneak Peek PowerBI.vtt	7.5 KB
4. Resources & Next Steps.mp4	7.6 MB
4. Resources & Next Steps.vtt	3.2 KB
5. BONUS LECTURE More from Excel Maven.html	2.6 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 178