Through The Lens Of Power BI: Walt Disney Company

Imagine stepping into the magical kingdom of Walt Disney, where dreams come true and fantasies become reality. Picture yourself strolling down Main Street, USA, with the iconic Cinderella Castle in the distance, or joining Mickey, Minnie, Donald, and Goofy on their whimsical adventures. Feel the thrill of the Star Wars galaxy, the enchantment of the Disney Princesses, and the heartwarming tales of Pixar.

Now, what if I told you that we can do just that, not physically, but through the enchanting power of data. We can dive into the rich history, explore the beloved characters, and uncover the storytelling magic that is the essence of the Walt Disney Company.

This Dashboard is inspired by a very similar dashboard made by Federico Pastor for Onyx Data Challenge.

The Approach

We’ll be using Excel for efficient data preprocessing and Power BI for dynamic dashboard creation providing a comprehensive analysis of our dataset.

1. Downloading the Dataset: The Dataset was a part of Onyx Data Challenge and can be downloaded from their website.
2. Loading Data into Excel: Downloaded dataset will be loaded into Excel for a more detailed view.
3. High-Level Data Overview: We’ll perform a high-level overview of the data to understand its structure and contents.
4. Data Preprocessing: This involves cleaning and preparing the data for further analysis. This step is crucial for accurate results.
5. PowerPoint for Dashboard Background: We’ll then move to PowerPoint to create an engaging background for the dashboard.
6. Dashboarding with Power BI: Finally, we’ll import our preprocessed data and the created background into Power BI to create a dynamic, interactive dashboard.

Data Preprocessing

On first glance through this dataset, I observed that we’ll need two more columns for our analysis and that would be an year column and an month column. So for creating an year and month column from DateReleased column I used the following functions in Excel.

1. To get the month

=MONTH(A1)

2. To get the year

=YEAR(A1)

That is all that we’ll require for this project. If you want you can come with more columns or features either by manipulating the existing columns or through web scraping data form popular sites like IMDB.

PowerPoint Background

To create the background we’ll use PowerPoint . The background is sort of inspired by many other similar dashboards. I have also used some icons of famous Disney characters.

Now the background looks something like this:

To create this background we’ll follow these steps:

1. We create a gradient effect of colors blue and white while making sure that we leave the upper portion of the template white and the lower portion of the template in blue.
2. Next the upper portion is divided into two half’s, one half is for the title and the second half is to display some metrics like number of seasons ,episodes in total etc.
3. The second half of the upper portion is the place where we’ll place our icons. The icons would be placed in such a manner that all the key metrics end up between each of them.

Now we have created the dashboard background we’ll now move towards creating the dashboard in Power BI, and for that you need to upload your updated dataset to Power BI.

Building the Dashboard

For dashboard building I will use the template made in PowerPoint. The design is made so as to incorporate key metrics ,graphs and charts required for presenting the data.

Now the key metrics that I have identified are listed below. Below are the DAX formulas for each one of them .

1. Total Movies

Total Movies=COUNT('Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)'['Movie Title'])

2. Total Gross

Total Gross=SUM('Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)'['Total Gross'])

3. Real Gross

Real Gross = 'Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)'[Total Gross] / (1 + 'Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)'[Inflation Adjusted Gross])

4. Inflation Adjusted Gross

Inflation Adjusted Gross = SUM('Onyx Data - DataDNA Dataset Challenge - Disney Movies Total Gross (2)'['Inflation Adjusted Gross'])

The Graphs

The graphs that I have chosen for this dashboard are a pie chart ,two bar charts and a table showing split by total gross and inflation adjusted gross. The pie chart shows the average total gross by MPAA rating, while the bar chart is used for depicting total gross by rating and by movie title. The color resembles a snowy-white palette, although you are free to experiment with other color palette’s as well.

Once all of this is done we’ll then arrange them into their blocks. Now the dashboard looks something like this.

This is the final dashboard

The Power BI dashboard created for Disney provides a comprehensive and interactive view of the data, enabling valuable insights. However, there are always opportunities for further exploration and improvement. For instance, we could consider building a similar dashboard using some Python frameworks. These Python libraries offer a different set of functionalities and could provide a more customized and interactive user experience.

Additionally, they could potentially offer more flexibility in terms of data manipulation and visualization. Exploring these options could lead to new insights and further enhance the value of your data analysis.

As Arthur C. Clarke once said, ‘The only way to discover the limits of the possible is to go beyond them into the impossible.’ So, let’s continue exploring, learning, and pushing the boundaries of data analysis together.