MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)
Download Excel START Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy-Start.xlsx
Download Excel FINISHED Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy-Finished.xlsx
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy.pdf
Assigned Homework:
Assigned Homework:
Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-Homework-Start.xlsx
Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-Homework-Finished.xlsx
Buy excelisfun products:
https://teespring.com/stores/excelisfun-store
In this Video learn all about Power Query’s Group By feature. See Four Examples of how to use Group By to Calculate Total Sales, Standard Deviation, Join Names and Rank Sales.
Topics:
1. (00:15) Introduction
2. (01:30) What Does Power Query Group By feature do?
3. (02:58) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar
4. (05:55) Example of Simple Power Query Group By Command for Total Sales
5. (08:50) First Look at Table.Group Power Query Function
6. (10:17) Example of using Group by to get Tables of Grouped Records, or Matching Records
7. (11:55) Standard Deviation Custom Column Based on Grouped Records Table
8. (14:41) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table
9. (16:23) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas
10. (21:32) Power Query Group By to Help Rank Sales for Each Product
11. (26:24) Group By More Than One Column
12. (27:11) Fast Trick for Group By: Placeholder Function
13. (28:51) Add new data and see that everything updates.
14. (29:38) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples) канала ExcelIsFun
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy-Start.xlsx
Download Excel FINISHED Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy-Finished.xlsx
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-GroupBy.pdf
Assigned Homework:
Assigned Homework:
Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-Homework-Start.xlsx
Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/008-MSPTDA-Homework-Finished.xlsx
Buy excelisfun products:
https://teespring.com/stores/excelisfun-store
In this Video learn all about Power Query’s Group By feature. See Four Examples of how to use Group By to Calculate Total Sales, Standard Deviation, Join Names and Rank Sales.
Topics:
1. (00:15) Introduction
2. (01:30) What Does Power Query Group By feature do?
3. (02:58) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar
4. (05:55) Example of Simple Power Query Group By Command for Total Sales
5. (08:50) First Look at Table.Group Power Query Function
6. (10:17) Example of using Group by to get Tables of Grouped Records, or Matching Records
7. (11:55) Standard Deviation Custom Column Based on Grouped Records Table
8. (14:41) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table
9. (16:23) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas
10. (21:32) Power Query Group By to Help Rank Sales for Each Product
11. (26:24) Group By More Than One Column
12. (27:11) Fast Trick for Group By: Placeholder Function
13. (28:51) Add new data and see that everything updates.
14. (29:38) Summary
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Видео MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples) канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, MoreMSPTDA 08.5: Power Query Group By Unique List or Consecutive OccurrencesAdd index to subgroups in Power QueryUnleash The Potential of Group By With All Rows5 Tricks to Reduce Steps in Power QueryPower Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]How to use Microsoft Power QueryMSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data SetMSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 ExamplesMSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI DesktopMSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important TransformationsExcel Magic Trick 1347: Power Query Function: Split Master Table into Sub Tables for Each ProductMagic of Lists in Power QueryTwo-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 155425 Amazing Power Query Tips and TricksExcel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!Power BI Group By - Using Query Editor, DAX, and Some Magic!✨MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column