Excel Power Query Tutorial - Grouping Tables of Data

Рет қаралды 13,848

2 жыл бұрын

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.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
Get the Excel workbook used in this video:
💻 github.com/DaveOnData/ExcelPo...
-----------------------------------------------------------------------------------------------------------------------
Additional Power Query Tutorial Videos
-----------------------------------------------------------------------------------------------------------------------
What is Excel Power Query AND Why it Matters to You! (Part 1):
📺 • What is Excel Power Qu...
Excel Power Query - Add Column From Examples (Part 2):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Custom Column 1 (Part 3):
📺 • Excel Power Query Tuto...
Excel Power Query - Add Conditional Column (Part 4):
📺 • Excel Power Query Tuto...
Excel Power Query - Transforming Nested Tables (Part 6):
📺 • Excel Power Query Tuto...
-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 • Introduction to Busine...
💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video: • Learning R Programming...
Stay healthy and happy data sleuthing!
#ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryGroupingTables

Пікірлер: 24

@DaveOnData 2 жыл бұрын

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzfaq.info/get/bejne/rq-IrNCSx9-qeYE.html

@myrthalita 3 ай бұрын

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

@DaveOnData 3 ай бұрын

You are welcome! I am happy to hear you found my content useful.

@tomdarling-fernley3178 3 ай бұрын

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

@DaveOnData 3 ай бұрын

I am happy to hear that you found my content useful!

@Juan-Hdez 5 ай бұрын

Useful. Thank you.

@DaveOnData 5 ай бұрын

Glad you liked the content!

@Data_Mom 2 жыл бұрын

Thank you so much David Langer for these awesome PQ videos

@DaveOnData 2 жыл бұрын

My pleasure, Pooja! Glad you are finding the content useful.

@Sommenofatobox 2 жыл бұрын

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

@DaveOnData 2 жыл бұрын

Thank you so much for the feedback and so glad you are finding the video useful! New videos will be out next Monday and Thursday morning US time. 😁

@shivsharma9153 2 жыл бұрын

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

@DaveOnData 2 жыл бұрын

Thank you! Early in my career I was a software engineer and software architect. As much as I love software engineering, I love analytics more. I guess that love shows through in how excited I get. 🤣

@nicholaspkelly 2 жыл бұрын

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

@DaveOnData 2 жыл бұрын

My pleasure! Glad you liked the content.

@debbybosman2095 Жыл бұрын

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

@andrewdove342 2 ай бұрын

Sick !

@DaveOnData 2 ай бұрын

Yes! Glad you enjoyed the video.

@ebenasare8661 2 жыл бұрын

You are absolutely awesome

@zzzzzzzzzzzzzzzz9 2 жыл бұрын

Nice thank you. Subbed

@71sephiroth 2 жыл бұрын

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

@Bydr-ei5nw 2 жыл бұрын

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?