Power BI Practice Solution ROUND #3 I GROUPING similar TEXT ITEMS and REMOVING TYPOS in Power BI

In this third Power BI Practice Round the challenge is grouping similar text items and removing typos, correcting for lower vs upper case, so that you have just one name for each single item. You are free to choose any approach, whether it is Power Query, DAX or any other method you can think of.

Requirements:
Key Visuals:
Match the information from the location mapping table to the wine review data set.
Create a map visualisation with:
country and province as a hierarchy on the location field
have the number of wineries determine the size of the bubbles
apply conditional formatting based on the average points field
Create a matrix visualisation with:
average points on values
country, province, winery, and wine as a hierarchy on rows

Download file here https://datatraining.io/powerbi-how-to

--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...

Power BI Essentials https://datatraining.io/powerbilearni...

Business User Training https://datatraining.io/powerbi-busin...

For Custom Trainings and Consulting email directly [email protected]

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
1:45 Data Groups
2:37 Merging in Power Query
4:25 Similarity treshold in Fuzzy Match
7:54 the number of matches in Fuzzy Match
10:19 Loading the data
11:11 Double check if merge has been successful
13:25 Using a transformation table in Fuzzy Match
15:58 Creating the visuals
18:45 End

---------------------------------
😍 JOIN 😍
----------------------------------
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta   / howtopowerbi  
LinkedIn   / basdohmen  
TikTok   / how.to.power.bi  
X   / howtopowerbi  
fb   / howtopowerbi  
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear https://amzn.to/47F21Yc
📚 Power BI books MUST READ! https://amzn.to/3tUfFcj
💡 General books I recommend https://amzn.to/48YNo33
🎶 Music for my videos https://www.epidemicsound.com/referra...
🚀 For growing on YouTube: https://www.tubebuddy.com/bas
🏄 Stuff I use daily https://amzn.to/3HqfMQ2

Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX