Excel Power Query Tutorial - Add Column From Examples

Подписаться 75 тыс.

Просмотров 19 тыс.

50% 1

The Excel Power Query "Add Column From Examples" feature is wildly useful for ANY professional looking to clean and wrangle their data. In Part 2 of my Excel Power Query tutorial, I will teach you how to use "Add Column From Examples" to transform and extract data to enable powerful 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 Tutorial - 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 - Grouping Tables of Data (Part 5):
📺 • 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 #PowerQueryAddColumnFromExamples

Наука

Опубликовано:

1 авг 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@DaveOnData 3 года назад

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html

@ChatGPT1111 2 года назад

Wow this stuff is pure gold. I worked with Excel for 20 years and never knew about this!

@lloydfernandes2535 2 года назад

This series is a goldmine of information. Thank You Dave. Much love for you and your family from India

@joeltochukwu4199 2 года назад

Thank you Dave. I never knew Power Query was an ETL tool.

@vijayarjunwadkar 3 года назад

Wonderful video David! Like the way you explain and present, which makes it very easy to follow and understand the concepts clearly! Looking forward for the next video in series! Keep up the great work! 😊👍

@DaveOnData 3 года назад

Thank you for the feedback, much appreciated! The next video will be up Thursday morning US time. 😁

@andrewdove342 3 месяца назад

absolute fun ! thanks

@DaveOnData 3 месяца назад

You are welcome! Glad you enjoyed the video!

@venugopal-nc3nz 3 года назад

Hey David I am from India liking your every video. Please teach analytics using python

@DaveOnData 3 года назад

Thank you so much for the feedback and so glad you are finding the content useful. With respect to Python, I haven't used Python in my hands-on analytics work in years. Also, I've found that R is far easier for professionals without coding background to learn and use to analyze data. 📺 Check out the following video for more info: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MNpsyjSuR20.html

@venugopal-nc3nz 3 года назад

Yeah R is useful but In India most of company prefer SAS or python for analytics. I don't see too much job posting in R in India

@DaveOnData 3 года назад

Interesting. When I research analytics jobs, R is a very popular skill. Not as popular as Python, but still very popular.

@user-sn5jk1wo8q 4 месяца назад

thank you so much for classes but can you use the mouse slowly for beginners it would more help

@DaveOnData 4 месяца назад

I am glad you are enjoying the content. If I'm moving the mouse too fast, you can rewind the video and also slow down the playback speed.

@Data_Mom 3 года назад

Super liked the content David. 'Add Column from Examples' is awesome PQ feature - you explained this concept so nicely. I had one question. When I load my connection(MainETL) as a table, it creates a new worksheet. will the worksheet be automatically renamed as MainETL or I need to rename it explicitly.

@DaveOnData 3 года назад

As always, thank you for the feedback, Pooja! To my knowledge, this is the default behavior of Power Query. However, as I demonstrate in the new tutorial video today, I typically load tables from Power Query into existing worksheets: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iMX8yZtupzg.html

@Data_Mom 3 года назад

@@DaveOnData I will have a look at the new video, thank you for replying.

@DaveOnData 3 года назад

My pleasure!

@atkinsj24 2 года назад

Question: the example in the video concerning the Pclass and Survived fields using the "add column from examples" technique in PowerQuery, can also be achieved using the IF function in a table (you have a video on this in your clean data playlist). My question is, when cleaning data is it best practice to use the techniques in your clean data playlist or rather to use the techniques in your Power Query playlist? Or is it just a matter of preference?

@71sephiroth 2 года назад

Good observation! Think of it this way: Would you rather scratch your head to design complicated nested IF statements, test to see if everything works, scratch your head if you've missed some 'edge cases', or give few examples to the 'Add Column From Examples' so that it learns the rule automatically? I would do the second one. :D

@wormholecowboy Год назад

Did they get rid of the 'add from example' feature? I have the newest version and I only see Custom, Invoke, and Conditional as the 3 main buttons there.