How to create binary/dummy variables from text #PowerBI #containstrings #dummyvariable #onehotencode

The content is solely for educational purposes and is based on my personal experience.

Links:

Note: The PowerBI uploaded in my github is a truncated version of the wine data. Please go to kaggle to download the full dataset. Sample dataset y is provided if you want to use it.

See other links to sites that I used to hone my skills below. I may receive commission from them.
BE SURE TO CHECK THEM OUT!

Timestamp:
00:00 Introduction
00:25 Target state
01:57 Power BI containsstring() function
02:35 Power BI worksheet using wine dataset
03:08 Creating Berry flavor dummy variable
03:24 Creating Citrus flavor dummy variable
03:43 Summary of all 12 flavor dummy variables
04:17 Export data to excel

Thank you! :) #funwithdata #funwithdatabyMaddy