Explore the Power Query Group By feature and Table.Group function through five practical examples in this comprehensive tutorial video. Learn how to calculate total sales, standard deviation, join names, and rank sales using Group By. Discover the similarities between Power Query Group By and other data analysis methods like PivotTables, SUMIFS, and SQL. Master techniques such as creating custom columns based on grouped records, joining text items from unique lists, and ranking sales for each product. Gain insights into grouping by multiple columns and using placeholder functions for efficient data analysis. By the end of this tutorial, you'll be equipped to leverage Power Query's Group By feature for advanced data manipulation and analysis in Excel.
Overview
Syllabus
) Introduction.
) What Does Power Query Group By feature do?.
) Examples of PivotTable, SUMIFS, Data Model PivotTable and SQL Code to see that Power Query Group By is VERY Similar.
) Example of Simple Power Query Group By Command for Total Sales.
) First Look at Table.Group Power Query Function.
) Example of using Group by to get Tables of Grouped Records, or Matching Records.
) Standard Deviation Custom Column Based on Grouped Records Table.
) Joined Text Items from Unique List formula in Custom Column Based on Grouped Records Table.
) Detail look at Table.Group Function. Edit and create arguments in Third Argument to List Multiple New Columns with Formulas.
) Power Query Group By to Help Rank Sales for Each Product.
) Group By More Than One Column.
) Fast Trick for Group By: Placeholder Function.
) Add new data and see that everything updates..
) Summary.
Taught by
ExcelIsFun
