MGS 8020 Business Intelligence

Case Study #4

 

Business Case:

Raheem DeVaughn is an American singer and songwriter. His debut album, The Love Experience (2005), reached no. 46 on the Billboard 200 album chart. Sony Entertainment Network is a digital media delivery service operated by Sony Corporation. Sony Entertainment Network provides access to services, including PlayStation Network for games, Video Unlimited for film and TV, Music Unlimited for music, and PlayMemories for sharing videos.

Sony Entertainment Network would like to understand the social media presence of Raheem DeVaughn from Twitter. They would like to know the background, demographic and anything you can tell from the followers on Twitter. Sony Entertainment Network also wants to create a Social Media Dashboard for Raheem DeVaughn to monitor the health of the business. However, the data file which Sony Entertainment Network received was not ideal for dashboard production.

 

Deliverable:

Part 1 Data Cleanings: You can use any BI applications (Microsoft Excel, Access or SQL Server) which you have been learning this semester to clean the data and make the data in a presentable format for Tableau. Depends on the BI applications you have been using, you need to provide the Microsoft Excel, Access or SQL Server file to demonstrate the data cleanings efforts.

Deliverable:

1a) Please provide a xls, xlsx, mdb, accdb, csv or txt file in a presentable format for Tableau (5%)

1b) Please provide the BI file (in Microsoft Excel, Access or SQL Server) you have been using for data cleanings (25%)

 

Part 2 Dashboard Development: A dashboard is a vital tool for monitoring the health of the business. From a single graphical user-interface, decision makers have access to different key performance indicators (KPIs) - actionable information that can be used to actively guide business performance. As a consultant for Sony Entertainment Network, you would like to develop a dashboard which provides actionable information. You're going to follow the best practices for creating effective dashboards.

The aim for this case study is to develop a dashboard which provides a visual display of the most important metrics needed to achieve one or more business objectives. The successful development of a dashboard needs to consider the followings:

2a) Plan

2b) Design

2c) Build

Deliverable: