MS-Excel---IMDB-Pivot-Table

IMDB Movie Data presented in different Pivot Tables

Following are the Pivot Tables Created:

"Using the IMDb PivotTable, practice creating views to show:

1. Budget by Title
2. Budget and Revenue by Country, Genre, and Title
3. Revenue by Country, filtered only on Horror films
4. Revenue by Genre and Rating, filtered only on B&W films produced in the United States"
5. Set up a view to show Budget by Title (as rows), with filters for Country (set to Japan) and Language (set to English). How many Japanese movies in the database were produced in English?
6. Clear the Language filter, set the Country filter to Denmark, and pull in Gross Revenue as a second metric. How much gross revenue did "The Celebration" generate?
7. Use the "Clear All" command in the PivotTable Analyze options to remove all fields from the table, and create a new view showing Gross Revenue by Country (as rows) and Genre (as columns). How much revenue was generated by Comedy films in Finland?
8. Remove the Country field, move Genre to the row labels, and drag in Rating as secondary row labels. How much revenue was generated by PG-rated Family films? Double click on the cell to see the exact source data populating the value. Which title drove most of the revenue?
9. Show Budget and Gross Revenue by Title, and change the number format to currency, with a dollar sign. What was the budget for "A Passage to India"?
10. Remove Budget and Title, and show Gross Revenue by Genre (rows) and Rating (columns). Update the PivotTable options to show "$0" instead of blank values
11. Move Rating to the row labels (beneath Genre), change your table layout to Outline View, and Update your column headers from "Rating" to "Film Rating", and from "Sum of Gross Revenue" to "Gross Revenue" (hint: you may need a trailing space)
12. Remove Film Rating from the view, so that you're just viewing Gross Revenue by Genre. Turn Grand Totals off, select the Gross Revenue values, format as currency (if they aren't already) and add a Color Scale from Green (high) to Red (low). Which Genre produced the most Gross Revenue?
13. Add a second instance of Gross Revenue, and format the new column with Data Bars. Update the number format to make the text invisible, so that only the bars appear. Which Genre produced the second-highest Gross Revenue total in the sample?
14. Create a view showing Gross Revenue by Title, with a filter for Year to only include films released in 2005, 2006, 2007 or 2008, then sort the titles descending by Gross Revenue. What's the top-grossing film released during that 4-year sample?
15. Add a Label Filter to only include titles that end in "2". How many sequels were released during these years? Which earned the most Gross Revenue?
16. Clear your label filter, and add a Value Filter to only show titles that earned between $1,000,000 and $3,000,000 in Gross Revenue. How many titles fell into this range?
17. Adjust your PivotTable Options to allow multiple filters, then add a label filter to only show movies that start with the letter "M". How many titles are now listed?
18. Add a wildcard to your label filter to only show titles that start with the letter "M" and also contain the letter "s", separated by any number of characters. Which titles are returned?
19. No calculation (Sum of Budget); 2. % of Column Total
20. % of Parent Total (Base Field = Genre); 4. Difference From (Previous Year)
21. % Difference From (Previous Year); 6. Running Total In (Base Field = Years)
22. % Running Total In (Base Field = Years); 8. Rank (Large to Small)
23. Create a view to show IMDb Score by Title. What happens when you replace Title with Genre? How can you fix this issue?
24. Update your view to show Average IMDb Score by Genre (primary row labels) and Year (secondary row labels), for 2011-2014. Drag in a second instance of IMDb Score, change the summarization to Average, and show the values as a Rank (large to small) based on the year. Which year in the 4-year sample saw the highest-rated Biography films on average? The lowest?
25. Add in a column for Gross Revenue, and show the values as the % Difference From the previous year. By what percentage did Action movie revenue grow in 2014?
26. Create two new calculated fields named "Profit" (Gross Revenue - Budget), and "Profit Margin" (Profit / Gross Revenue). Update the view to show both new fields by Title. Which Title generated the strongest Profit Margin in the entire sample?
27. Create a new calculated field for "Cast + Director Likes" (Cast FB Likes + Director FB Likes), and update the view to show Cast + Director Likes by Genre. If you wanted to show this field as an average across titles, rather than a sum, how could you accomplish this?
28. Create a view to show # of Titles by Country, excluding the USA, for the entire sample. Name the PivotTable "Titles by Country", then use a PivotChart to visualize this view as a Clustered Column Chart.
29. Hide the Field Buttons from the PivotChart, then apply a value filter to only show the top 10 countries by # of Titles. Which country is #2?
30. Change the chart type to a Clustered Bar, and change the PivotTable sorting to ascending by # of Titles.
31. Pull in IMDb Score as a second series, and summarize values by Average. Change your PivotChart type to Combo, with # of Titles as a Clustered Column and IMDb Score as a Line with Markers, on the Secondary Axis. Which of the 10 countries generated the lowest average IMDb scores? (Bonus: Format the IMDb series in the chart to only show the markers, with no line)
32. Copy the existing pivot and create a second view below the combo chart to show Budget by Genre, with a Top 5 filter applied. Name the table "Budget by Genre", then visualize this view with a Pie chart, with hidden field buttons.
33. Insert a Slicer for Genre, enable multi-select, then connect it to both PivotTables.