IS6140 Business Intelligence and Analytics
Assignment 1: Individual Report (65 marks)
The IS6140 assignment is divided into two parts:
1. Report including Tableau Dashboard: 2,000 words
. Marks: 45
2. Recorded Video Presentation (max 10 slides): 10 mins
. Marks: 20
(1) Report Description
“Salt Productions” is the largest television production company in the Northern Hemisphere. This is primarily due to their recent acquisition of HBO, Netflix, Comedy Central and other major television producers. As a result of such heavy investment, the Stakeholders are anxious to identify new opportunities for future projects. They also need to integrate their data across all new acquisitions and require a data analytics strategy to create a roadmap for future insights. They have hired you, as apart of a team from BIA Consultants, to draft a detailed report (MAX 2000 words) to stakeholders with the following requirements and guidelines.
1. Propose an analytics strategy for Salt Productions.
a. You will need to define Business Intelligence and outline the key elements of BI using relevant academic and practitioner material.
b. You will need to conduct a preliminary investigation into the streaming platform. industry and identify current trends for getting business insights. Present potential challenges relevant to the context of the case.
c. Identify appropriate tools and techniques that can be used in future analyses with a “wish list” of data that would help us understand the business case further. What are the data requirements for Salt Productions? How would you advise Salt Productions in terms of further developing their Business Intelligence and Analytics strategy? Please provide a comprehensive justification for your recommendations.
2. As apart of your report, you must conduct an analysis on “Dataset 1: Streaming Platforms” to portray our current understanding of movie/TV streaming and to inform your analytic strategy and recommendations to stakeholders.
a. Using an appropriate BI tool (e.g. Tableau, MS Excel) create a dashboard and visualize the streaming platforms dataset. This tabular dataset consists of listings of all the movies and tv shows available on four streaming platforms (Disney+, Netflix, Hulu, and Amazon Prime), along with details such as - cast, directors, ratings, release year, duration, etc.
b. Select appropriate data points for comparison and visualize the salient information for discussion in your report. Document any assumptions you make and justify the approach you have taken.
c. Based on your analysis of the data, present your key findings, and give recommendations to the stakeholders as apart of your proposed analytics strategy.
(2) Presentation Description
Prepare a PowerPoint Presentation (.ppt) and voice over (10 slides excluding a title slide and slide for your references). Your presentation should be no more than 10 minutes and should highlight the key information from your report.
Please include the following in your presentation:
• Title, name, student number
• Your proposed analytics strategy (include a screenshot of your Dashboard and any relevant visualizations of Dataset 1)
• Discussion
• Conclusion
• References
Submission Procedure:
Submission to Canvas by 23:59, Tuesday March 19th, 2024
Please ensure you submit all project files, including:
• Dashboard and analysis file(s).
• Report in a single document saved as a pdf.
• Recorded presentation file.
• Ensure you have submitted the Assignment Submission form.
Penalties (for late submission of Course/Project Work etc.): Where work is submitted up to and including 7 days late, 10% of the total marks available shall be deducted from the mark achieved. Where work is submitted up to and including 14 days late, 20% of the total marks available shall be deducted from the mark achieved. Work submitted 15 days late or more shall not be accepted.