Description to Attributes with Power Query - Advanced Power Query tutorial
This is a Power Query tutorial that has its origin in real life. It's how to turn a product description into a list of attributes by modifying the filter step to find specific words or word combinations in a larger text with the list of attributes and all synonyms that attribute has in the descriptions. This method utilizes the fact that a filter step in Power Query is a function that is run on every value of the column.
This tutorial was made using Excel 365, but the techniques shown apply to all Excel versions from 2010 onwards.
Blog Post on the Topic: https://bit.ly/2WIRiOb
Chapters:
0:00 Excel Olympics Animation
0:08 Introduction
4:05 Loading to Power Query
5:05 Unpivoting the Translation Table
5:40 Main Formula and its Explanation
9:22 Final Steps to get the right form of data
11:12 Fuzzy Matching
14:12 Outro
Gear Used:
US Links
Camera: Canon EOS R6 - https://amzn.to/3e9zxML
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/3tYd37w
Audio converter: Zoom UAC-2 - https://amzn.to/3dgM8wS
Laptop: Dell XPS 15 - https://amzn.to/3w8CyoK
Lights: Elgato Key Light - https://amzn.to/3rurte7
EU Links
Camera: Canon EOS R6 - https://amzn.to/3tubwGy
Microphone: AKG C3000 (Analog Mic) - https://amzn.to/32pi2m0
Audio converter: Zoom UAC-2 - https://amzn.to/3amDRXP
Laptop: Dell XPS 15 - https://amzn.to/3effMmT
Lights: Elgato Key Light - https://amzn.to/3vcs6v9
Green Screen (visible in bloopers): https://amzn.to/3ajUm6Y
Recorded With: Camtasia - https://www.techsmith.com/video-edito...
Subscribe for more Excel tutorials on the Excel Olympics YouTube Channel: http://bit.ly/EOYTsub
Subscribe for the Excel Olympics Newsletter: https://bit.ly/3w3rkjK
Disclaimer: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide, I may receive a small commission with NO additional charge to you! I appreciate your support!
#Excel #ExcelOlympics #gasperkamensek