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
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 · 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. · 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)
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?
ANSWER:
Question 5 (10 marks)
Why is it crucial to implement a standardised approach to reporting within a company?
ANSWER:
END OF FINAL INDIVIDUAL ASSESSMENT
Get original papers written according to your instructions and save time for what matters most.
