Excel Power Query Tutorial - Add Column From Examples

[@DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68

[@ChatGPT1111]

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

[@lloydfernandes2535]

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

[@joeltochukwu4199]

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

[@vijayarjunwadkar]

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]

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

[@venugopal-nc3nz]

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

[@DaveOnData]

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: kzbin.info/www/bejne/g3_TpKygiNqFaJI

[@venugopal-nc3nz]

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]

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

[@euroagency-n9p]

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

[@DaveOnData]

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.

[@andrewdove342]

absolute fun ! thanks

[@DaveOnData]

You are welcome! Glad you enjoyed the video!

[@Data_Mom]

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]

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: 📺 kzbin.info/www/bejne/n367aayQqdqjsMk

[@Data_Mom]

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

[@DaveOnData]

My pleasure!

[@atkinsj24]

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]

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

[@osoriomatucurane9511]

In Excel, you always have more than one way of doing and getting the same result. You also have alternative tools (Power Query, SQL, Python, R). Within Excel, in some case the if( ) can be replaced with switch( ), choose( ), vlookup( ) , index( ) & match( ). Even find() and replace () could replace the if( ). You need to weight on costs(effiency), readanility, flexibility/maintenance,.....

[@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.

[@theshortjune]

Does anybody know how to add columns from examples using mac? thnx