Introduction
This week’s challenge is inspired by recent Twitter activities. We are creating a word cloud containing common misspellings in the US.
Requirements
Power Query
- Obtain the dataset from
https://www.dailymail.co.uk/femail/article-11357183/Google-search-data-reveals-commonly-misspelled-words-spell-correctly.html
OR
https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings
- Transform and load data
- HINT : Add Index column, create modulo column, unpivot data
Power BI Desktop
- Obtain Word Cloud custom visual from AppSource
- Create words from the misspellings
- Size the words by number of misspellings
- EXTRA : Add some more of your own infographics and data about misspellings to tell an interesting story
Dataset
The dataset this week can be viewed
https://github.com/kolky001/Workout-Wednesday-2023/blob/main/Misspellings
Share
After you finish your workout, share on Twitter using the hashtags #WOW2023 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.
Solution
Solution File available for download via Data Stories Gallery