Excel Power Query Tutorial - Grouping Tables of Data

Grouping tables of data with Excel Power Query is the focus of Part 5 of my Power Query tutorial series. In this video I demonstrate how to characterize groups of data to enhance the power of your data analyses.

-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
Get the Excel workbook used in this video:

-----------------------------------------------------------------------------------------------------------------------
Additional Power Query Tutorial Videos
-----------------------------------------------------------------------------------------------------------------------
What is Excel Power Query AND Why it Matters to You! (Part 1):

Excel Power Query - Add Column From Examples (Part 2):

Excel Power Query - Add Custom Column 1 (Part 3):

Excel Power Query - Add Conditional Column (Part 4):

Excel Power Query - Transforming Nested Tables (Part 6):

-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------

💥 Learning R programming is easy for Excel users! 💥

Stay healthy and happy data sleuthing!

#ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryGroupingTables

[DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

[Data_Mom]

Thank you so much David Langer for these awesome PQ videos

[tomdarling-fernley]

Really useful. Thanks! Also my problem was far away from Titanic passenger data but your examples were easily translated across.

[Sommenofatobox]

David, got to say I really enjoy your videos and can't wait to see the next one!

[shivsharma]

i love the way you show the enthusiasm while doing the analysis. great series

[myrthalita]

This helped me get unstuck on a problem I'd been trying to solve (on and off) for a couple of weeks. Thank you!

[nicholaspkelly]

Love these videos, thank you so much for sharing your knowledge!

[debbybosman]

Thank you Dave :) I am a great Titanic groupie (?) and loved this innovative dataset you have used here. Well done!

[Bydr-einw]

Thanks for the teaching David. I have a question though. How do you know that the fare amount of every person with ticket size greater than 1 is the total amount of fare and not the fare amount for each person?

[sephiroth]

dave, I can't somehow intuit why call it 'average' ticket fare? :D in my head I have a concept of like since all fares are same then average fare should be equal to fare that describes to group.