Power BI Report for Episode Analysis by Director

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)

In this question, there is a need to create one report for a director to identify or filter out the episodes according to the name of the director. In other words choosing one director name the table list automatically filters the name of the episode or related data. The report is created by following steps first it takes the table from the visualization panel, then it takes the name of the name of relevant columns that are very useful in displaying all the details related to the episodes like, No. Of seasons, total no. of viewers date of launch, title, and many more. Second, it takes one slicer from the visualization panel and then it takes the Director column from the data panel and then puts it inside the slicer to filter out the episode detailed according to the director. After all, it displays the complete report for the director.

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

This trends report is created by using a Line chart, the main aim of this report is to display the ups and downs of particular episodes based on their assigned number (Bobbitt 2023). This line chart is created by using some columns that are present inside the top right corner take two columns for the x-axis which is the Original air date that shows the released years, No overall is used to display the episode number and the y-axis, it takes U.S reviewers and summarizes them sum to display the total number of U.S viewers. After setting up all the columns in their respective places, it shows that in the year 2015 on 41 no episodes, it shows the total no. of viewers was 8.0 million and the highest number of viewers is displayed in the year 2017 67 no episodes was 12.07 million.

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:

The bar chart is mainly used to make a comparison between two different categories. This question, aimed to show the top 10 most popular episodes based on the U.S. viewership. It is created by using only two columns that are present inside the data panel (DATA GOBLINS 2023). It takes the bar chart inside the visualization panel and puts it on the report page. This bar chart visualization shows that the highest number of viewers taken by “The Dragon and the Wolf” and the viewers marked by 12.07 million, The “Eastwatch” viewers are taken by 10.27 million and the third highest taken by “Beyond the Wall” viewers was 10.24.

Question 4 (10 marks)

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

ANSWER:

These are the specifications with these specifications, a report has the following functionality applicability on which its functionality depends. In its composition, the report is destined to meet the expectations of the users and the goals. It is essential to have accurate information, similarly, the application of the right images assures the right information is captured. It also interests the user’s comfort for instance the time taken to load a Website. Additional features, filters, and sizes allow users to proceed deeper by filtering separate parts of the data, while, in turn, they can hide some data to reduce the effect of people viewing it. A good format makes a document clear to the customer and the use of a link data option makes a report efficient.

Question 5 (10 marks)

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

ANSWER:

There are several reasons why such a move can be deemed necessary for creating a standard reporting system in any organization These include the following The process of doing aperture comparisons in cross sections is made easier based on the fact that the format in use in the various departments is the same. It also leads to improved efficiency since it will not be time to devise new forms of reports and in this way, one avoids the kind of errors that are nurtured by such courses. Also, it helps in response to any legal requirement and other requirements and guarantees that the reports are readable and are in a form prepared for an audit. In addition, other issues to do with scaling will also disappear by the way that standardized reporting through automation will also be improved. Lastly, it tracks and controls the branding and professionalism on issues regarding the treatment of either the local or the company’s clients.

References

1. ?Bobbitt, Z 2023, ‘Power BI: How to Plot Multiple Lines on Line Chart’, Statology, 9 October, viewed 9 October 2024, <https://www.statology.org/power-bi-line-chart-multiple-lines/>.

2. DATA GOBLINS 2023, ‘Bar Charts in Power BI’, DATA GOBLINS, 9 October, viewed 9 October 2024, <https://data-goblins.com/power-bi/bar-charts>.

?

?

END OF FINAL INDIVIDUAL ASSESSMENT