Power BI Practice Intro 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 fields together 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]
---------------------------------
😍 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