Скачать или смотреть Excel Power Query Tutorial - Transforming Nested Tables

Transforming nested tables with Excel Power Query is the focus of Part 6 of my Power Query tutorial series. In this video I demonstrate how to use power query nested tables to enhance the power of your data analyses by creating new group-based columns (i.e., "features").


☕ If you found this content useful and would like to support the channel, you can buy me a coffee: https://www.buymeacoffee.com/DaveOnData


★★★ My online data analysis courses ▶ https://school.daveondata.com


-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
Get the Excel workbook used in this video:
💻 https://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 Query AND Why it Matte...  

Excel Power Query - Add Column From Examples (Part 2):
📺    • Excel Power Query Tutorial - Add Column Fr...  

Excel Power Query - Add Custom Column 1 (Part 3):
📺    • Excel Power Query Tutorial - Add Custom Co...  

Excel Power Query - Add Conditional Column (Part 4):
📺    • Excel Power Query Tutorial - Add Condition...  

Excel Power Query - Grouping Tables of Data (Part 5):
📺    • Excel Power Query Tutorial - Grouping Tabl...  


-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺    • Introduction to Business Analysis with Exc...  


💥 Learning R programming is easy for Excel users! 💥
📺 Check out the video:    • Learning R Programming Is Easy! (Full Webi...  



Stay healthy and happy data sleuthing!

#ExcelPowerQuery #PowerQueryTutorial #PowerQuery #PowerQueryNestedTables