2022 Week 51 | Titles of Christmas Movies

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.
  1. Use the movie_title field
  2. Use only Power Query native functions
  3. Get one row per each unique word
  4. 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. 
  1. Use the Microsoft Word Cloud visual found in the AppSource
  2. Show each word by count
  3. 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.

Solution

4 thoughts on “2022 Week 51 | Titles of Christmas Movies”

  1. 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

  2. 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.

Comments are closed.

Scroll to Top