Reference no: EM133775354
Business Analytics Fundamentals
Question 1
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:
(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.)
Question 2 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.
Question 3
Using the Episodes dataset, design a bar chart that highlights the 10 most popular episodes based on U.S. viewership.
Question 4
What factors should be considered when determining the functionality of a report?
Question 5
Why is it crucial to implement a standardised approach to reporting within a company?
Attachment:- Episodes.rar
|
What is the estate that is most complete form of ownership
: What is a Freehold Estate? What is the estate that is the most complete form of ownership? What is an estate in remainder? Be specific.
|
|
Think about time when you were in leadership role
: Think about a time when you were in a leadership role. This could be a leadership role within a place of employment, military service, a place you volunteer
|
|
Laying the foundation for self-designing organizations
: Laying the foundation for self-designing organizations requires diagnosis, knowledge, and valuing. diagnosis, change, and evaluation.
|
|
Comprehensive overview of a television series
: 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
|
|
Identifies any significant changes in viewership
: What factors should be considered when determining the functionality of a report and Why is it crucial to implement a standardised approach to reporting
|
|
Employee to help him improve his delegation skills
: As you're coaching an employee to help him improve his delegation skills, you encounter challenges.
|
|
Determining the functionality of a report
: Analyse the trend in viewership across all episodes. Create a report that visualizes this trend and identifies any significant changes in viewership
|
|
Effective ways to initiate coaching relationship
: You're starting to coach an employee. Which actions illustrate effective ways to initiate the coaching relationship?
|
|
Leadership in transformational change are envisioning
: The key roles of leadership in transformational change are envisioning, energizing, enabling, and engaging. diagnosis, change, enabling,
|