All responses must be entered in the answer boxes at the end of each question
For Questions 1, 2, and 3, you must take screenshots of the results from Power BI and paste them into the corresponding answer boxes.
Question 1 (10 marks)
Create a report page in Power BI Desktop that includes a slicer to filter episodes by the Director. When a Director is selected, the report should update to show only the episodes directed by that individual.
The report should be presented in a table format containing the following columns: Season, No. overall, No. in season, Title, Year, Sum of U.S. viewers (millions), and Written by. Explain the process of setting up this slicer and how to configure the table to display the specified columns.
Datasets Used:
· Episodes.xlsx
Overview of this dataset: The Episodes.xlsx dataset provides a comprehensive overview of a television series through two interconnected tables: Series and Episodes. The Series table offers a summary of each season, detailing the season number, total episodes, and the airing dates of the first and last episodes, giving a snapshot of the series’ progression. The Episodes table dives into the specifics of each episode, including the season number, overall and in-season episode numbers, title, director, writers, original air date, and U.S. viewership in millions. The Season column links the two tables, allowing for a cohesive analysis that connects season-level summaries with detailed episode information, providing a complete view of the series’ structure and evolution.)
ANSWER (box will enlarge as you enter your response)
Question 2 (10 marks)
Using the Episodes dataset, analyse the trend in viewership across all episodes. Create a report that visualizes this trend and identifies any significant changes in viewership. Discuss the insights gained from this analysis.
Datasets Used:
· Episodes.xlsx
ANSWER
Question 3 (10 marks)
Using the Episodes dataset, design a bar chart that highlights the 10 most popular episodes based on U.S. viewership.
Datasets Used:
· Episodes.xlsx
ANSWER:
Question 4 (10 marks)
What factors should be considered when determining the functionality of a report?