Excel Power Query Tutorial - Add Conditional Column

[@DaveOnData]

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

[@andrewdove342]

working with data is like taking your brain to the gym, feels good!

[@DaveOnData]

Indeed! It's one of the reasons I enjoy analytics so much.

[@CzechCzar]

Incredibly useful. I am currently learning Excel PowerQuery for analytics at my job, and this provided a really great explanation

[@shanabenjamin8945]

Thanks! You clarified the issues I had!❤

[@DaveOnData]

Yay! I am happy to hear that you found the video useful.

[@CDDCDj]

Great video. Sorry for going out of topic, do you know how to make a desktop direct access icon for an app in r? Thanks for sharing your knowledge.

[@DaveOnData]

Could you elaborate by what you mean about "an app in R?" Do you mean, for example, a Shiny app or something else?

[@CDDCDj]

@@DaveOnData I've developed a ShinyApp. Nevertheless, I would like to share it like a .exe file.

[@statistikochspss-hjalpen8335]

11:00 Does the order matter? Why does the Alice Leader condition need to come first?

[@davebennett7550]

Nice video. I haven’t really bothered with power query as I didn’t know that it could do this stuff. I’ve been doing the same sort of categorisation by adding calculated columns in the power pivot model. If you build a separate lookup table in the power pivot model (in your example it would contain two columns: Value and Output) and then add a calculated column to your main table with a formula which uses the DAX CALCULATE(FIRSTNONBLANK…(FILTER sequence. This works like a Select statement in SQL with a join to another table, or explained in excel terms it’s a super lookup function which allows you to look up on as many criteria as you want. Advantages are that this is easy to understand what the criteria are by viewing the lookup table. Also, it’s easily expandable to more criteria and using multiple lookup tables. Dax is weird to learn (coming from either an excel or sql background) but very useful for this type of data manipulation when you want to keep everything in an excel environment.

[@DaveOnData]

Thank you for taking the time to provide such a thorough comment! Personally, I've never used DAX as PQ, SQL, and R have given me everything I need. However, I've been told by many that DAX is super useful.

[@joeltochukwu4199]

@@DaveOnData True, so many tools out there that there is a cap to what someone can learn.

[@jbj926]

Is this video along the lines of data mining in the sense that titles with similar characteristics are grouped together?

[@ickorling7328]

Dude, nice! The relation to higher level structure and planning of the data base filtering anomolies-- that part. Helped me realize there's more... flexible method of outputting even simple data charts in lieu of shoddy pivots and manual lookup formulas. Can that power query thing compile into SQL automatically with Table names used through out in excel?

[@garciarogerio6327]

So far very good. Looks similar to the Query editor of Power Bi

[@AlterAgs]

I love your tuts

[@AkshayA-kj4zk]

hi, actually i have a doubt while in conditional column i am not able to fetch the suitable column under column name. can u please provide solution for this.

[@paulfarmer7393]

Enjoying your content a lot . You should point out in video that you couldn’t use the age column to determine adultness because in prior video you commented age field has a lot of missing records . Age would have been more natural field to use and wouldn’t required complex conditional logic to group adultness and sex together and then you could have avoided logic required to deal with female doctor ( this complex conditional logic will also make queries run slower if you were dealing with massive dataset) but in this case would not have given as wide a statistical coverage in determining if that data dimension has explanatory power. Important to note i feel if you have just watched this video in isolation , you would be left wondering as to why you went this more complex way of using title to infer adultness.

[@DaveOnData]

Thank you for the feedback! I am happy to hear you are enjoying my videos.

[@ajinkyatrimukhe]

Thank you.

[@DaveOnData]

You are welcome and hope you found the content useful!

[@ajinkyatrimukhe]

@@DaveOnData Yes Sir, this is so useful, and your teaching makes it easily understandable.

[@DaveOnData]

@@ajinkyatrimukhe - Excellent!

[@learnwithrahul808]

Nice video

[@DaveOnData]

Thank you for the kind words, very much appreciated!