Introduction
Me and my family love sitting down and watching Christmas movies during the holiday season! In this challenge we are going to be breaking down the words used in Christmas movie titles. Check out the word cloud that we are going to be creating below!
Requirements
Power Query
In order to get this data in the correct format for analysis, you will need to use Power Query to shape the data.
- Use the movie_title field
- Use only Power Query native functions
- Get one row per each unique word
- First column should be unique word and second column should be count
Power BI Desktop
Now that your data is shaped appropriately, we need to display the data as a visual.
- Use the Microsoft Word Cloud visual found in the AppSource
- Show each word by count
- Feel free to add any ah-hoc analysis in!
Dataset
The dataset for this week can be found on Kaggle at this link. The dataset is entitled, IMDB Dataset of All Christmas Movies 2016-2022. Each row of data is a Christmas themed movie.
Share
After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd, @KerryKolosko, @NerdyWithData. 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.
Nice video!!
Although I understood everything, i was not able to install wordcloud.possibly due to powerBi requires work email, which i dont have (I’m student).
Could anyone please help, how to get these and other visuals in PowerBi.
OR
could anyone join me in in org to utilize and learn power BI.
thank you
Yours Sincerely
Ashlesh Khajbage
I cannot use app source without having a pro license. Not helpful if someone wants to learn PowerBI on their own. A big drawback compared to Tableau Public.
Hi Ashlesh! You can sign up for a free demo account by joining the Microsoft Developer program. It’s completely free and you don’t need a credit card to sign up! Check it out here: https://developer.microsoft.com/en-us/microsoft-365/dev-program
Hi Rachana – you can sign up for a developer account to access all pro features! It’s completely free and enables you to use all features. Check it out here: https://developer.microsoft.com/en-us/microsoft-365/dev-program