A Comprehensive Analysis of a Television Series Dashboard

Final Individual Assessment

Unit Details	Name	Business Analytics Fundamentals
	Code	HI6037
	Year, Trimester	Trimester 2, 2024

Assessment Details	Name	Final Individual Assessment
	Due Date & Time	10 October, 2024 10.59 pm – Gold Coast students 11.59 pm – Melbourne & Sydney students

Student Details	Student Number
	First Name
	Family Name

Submission Declaration	Integrity Declaration	I have read and understand academic integrity policies and practices and my assessment does not violate these.
	Full Name
	Submission Date

ALL SUBMISSIONS MUST INCLUDE YOUR STUDENT DETAILS AND SUBMISSION DECLARATION.

IF THESE DETAILS ARE NOT COMPLETED YOU RISK BEING PENALISED

Instructions

Academic Integrity Information	Holmes Institute is committed to ensuring and upholding academic integrity. All assessment must comply with academic integrity guidelines. Important academic integrity breaches include plagiarism, collusion, copying, impersonation, contract cheating, data fabrication and falsification. Please learn about academic integrity and consult your teachers with any questions. Violating academic integrity is serious and punishable by penalties that range from deduction of marks, failure of the assessment task or unit involved, suspension of course enrolment, or cancellation of course enrolment.
Format & submission instructions	All answers must be entered in the answer boxes provided after each question. Your assessment must be in MS Word format only. You must name your file with the Unit Code and Student ID example: HI6037 – EMV45678 Check that you submit the correct document as special consideration is not granted if you make a mistake. Your student ID & name must be entered on the first page. Submission declaration must be completed on the first page. All work must be submitted on Blackboard by the due date and time. Late submissions are not accepted. You have two attempts to submit. The final submission will be marked only.
Penalties	Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using Holmes Institute Adapted Harvard Referencing. Penalties are associated with incorrect citation and referencing. For all other penalties, please refer to the Final Assessment Instructions section on Blackboard.

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)

Figure 1: Episode by the Director

In this dashboard, date and episode statistics are provided in an easy-to-read manner so that people can go to a series of episodes based on the director. One of the handy features of this interactive slicer is the ability to choose a director and have the table automatically show only the episodes of that director. For each episode, the following data is given in the table including, season, season number, episode number, title, year, viewership in the U.S., and writers. With the aid of this information, one can work out the effects which different directors have had on the series, commonly preferred episodes, trends about different seasons, and the input of different writers.

In this dashboard one slicer is configured as Director which contains the names of all the directors, this slicer is added by dragging it from the visual tab on Power BI to the Canvas.

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

Figure 2: Trend in Viewership

The trend in the Viewership chart shows the U.S. viewers for each of the episodes in terms of millions for different seasons of the Television series. Based on the column chart, as the No. As the season goes up, the impressions start to decline which is evidence of a fading interest towards the series. Many conditions may have led to this reduced performance including, the audience viewpoint, which describes changes in taste, shifts in competition, or creative control (Gupta & Jiwani, 2021 pp.31-46). Individual episodes with a few more viewers might be due to this or that guest, a twist in the story arc, or a promotion. It also states some other factors like dates, competition level, transition in the show format, etc, should also be added to know a more general picture of the views.

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:

Figure 3: Top 10 Episodes by Viewership

The bars on this chart represent the top episodes of the television series concerning the U.S. viewership. According to this bar chart, the majority of people watched the episode “The Dragon and the Wolf” as the most favourite offering the viewers must have appreciated its plot or guests. As for the other nine episodes in the list, the viewership is virtually identical, which means that the overall show quality is high, it seems reasonable to try to understand what makes these episodes so popular, as such knowledge can be useful for predicting tendencies in viewers’ preferences (Wang et al., 2022 pp.1222-1232). Structural features are obvious components to look at to understand the type of factors that may cause attraction, for example, using plot events or climaxes. Therefore, this chart is a useful tool in determining which of the series episodes are the most watched, allowing for building up its potential audience even further.

Question 4 (10 marks)

What factors should be considered when determining the functionality of a report?

ANSWER:

Understanding the role of a designed report is also crucial when designing it to serve its purpose of delivering its objectives within the intended. First, define the specific goals of the report and the typical users and their level of understanding of the subject matter and method of presentation. Subsequently, a flow check through the identification of data sources is required and data quality checks to determine the datasets’ accuracy and completeness (Richardson et al., 2020 pp.1-40). Identifying appropriate key metrics or KPIs must be done carefully. These must correspond to what is to be achieved in the report and need to be expressed in business terms. It is equally important to use visuals to support the message; ease of understanding and relevance of the chosen visuals reflect the type of data. Also, filter interactive functionality added to the application enables users to interact with and drill deeper into a specific element or data visualization. Another consideration is accessibility; the report must conform to guidelines for people with disability while at the same time, remaining easy to navigate.

Question 5 (10 marks)

Why is it crucial to implement a standardised approach to reporting within a company?

ANSWER:

There are several reasons for adopting the standardisation of reporting within a company. It helps to make comparisons easier with other statistics because it eliminates variability. It helps to increase efficiency since making reports according to this structure is easy and time-efficient (De Villiers & Sharma, 2020 pp.2-25). Also, it assists in data quality since everyone is using the same information and fosters better communication since everyone is on the same page. If done properly, following a definite approach, it provides more efficiency and an environment based on data-driven.

Here are some specific benefits of standardized reporting:

Improved data quality: Check and compare the format of the evidence Implemented to standardize the format of the data collected, and processed and the format of the reports produced. This means that the risk of making some wrong or ambiguous result is minimized which makes all the reports produced more credible.

Enhanced communication and collaboration: When an organization complies with the standards of reporting, it facilitates extraordinaire communication within the entity. It is possible to improve communication as well as improve decisions because everyone develops a common language and structure when dealing with data.

Better decision-making: Standardized reporting helps in better decision-making with its evidence. When information is collected systematically and can be compared across different units/branches, the organisation can easily filter the leading indicators, discover inefficiencies and make better strategic decisions.

END OF FINAL INDIVIDUAL ASSESSMENT

References

1. De Villiers, C. & Sharma, U., 2020. A critical reflection on the future of financial, intellectual capital, sustainability and integrated reporting. Critical Perspectives on Accounting, 70, p.101999. <https://researchcommons.waikato.ac.nz/bitstream/handle/10289/15984/CPA%20IC-IR%20paper%2015%20August%202023.pdf?sequence=4>

2. Gupta, K. & Jiwani, N., 2021. A systematic Overview of Fundamentals and Methods of Business Intelligence. International Journal of Sustainable Development in Computing Science, 3(3), pp.31-46. <https://www.ijsdcs.com/index.php/ijsdcs/article/download/118/97>

3. Richardson, J., Sallam, R., Schlegel, K., Kronz, A. & Sun, J., 2020. Magic quadrant for analytics and business intelligence platforms. Gartner ID G00386610. <https://b2bsalescafe.wordpress.com/wp-content/uploads/2021/11/gartner-magic-quadrant-for-analytics-and-business-intelligence-platforms-feb-2021.pdf>

4. Wang, Y., Hou, Z., Shen, L., Wu, T., Wang, J., Huang, H., Zhang, H. & Zhang, D., 2022. Towards natural language-based visualization authoring. IEEE Transactions on Visualization and Computer Graphics, 29(1), pp.1222-1232. <https://arxiv.org/pdf/2208.10947>