Project Title: Analyzing Streaming Service Conversions and Dashboarding Using BI Tools

MyBundle

Details
Project Title Analyzing Streaming Service Conversions and Dashboarding Using BI Tools
Project Topics Data Management
Skills & Expertise
Project Synopsis: Challenge/Opportunity
Acquiring and retaining new customers is a perennial problem in streaming services. To that end, MyBundle's crown jewel - Find My Bundle - is a recommendation tool that offers users their ideal services based on a handful of questions that assess their preferences.

This tool has over four years' worth of data and over a million submissions, but it has never been analyzed to uncover potential patterns between users' responses and their conversions (streaming service sign-ups). Furthermore, there is no centralized dashboard to view this data.

Therefore, this project seeks to conduct advanced analytical techniques on a rich dataset and view some of its findings on a BI tool (e.g., Power BI) to increase conversions while offering transparency to the company into this tool's performance.
Project Synopsis: Activities/Actions Required
The main activities would involve working with an extensive - albeit messy - dataset (an online survey with over a million submissions).
  • Exploratory data analysis
    • This includes answering questions such as: How does the response distribution look? Are there months when the survey was more popular than others? When did some questions stop being asked?
  • Predictive or correlation analysis
    • This includes answering questions such as: Do some responses make people more likely to convert? Is it the time of the day they complete it? Is it something else? 
  • Dashboarding using a BI tool
    • This includes visualizing some of the results on a BI tool based on the student's preference (preferably Power BI or Tableau).
Project Synopsis: Expected Results
This project would be considered successful if the student could visualize results in an interactive and user-friendly dashboard. The cherry on top would be uncovering patterns in user behavior that make them more likely to sign up for a given streaming service. 

A dashboard would give the company transparency into its performance while providing an MVP for alternative dashboarding procedures. The analytics portion of the project would help decipher whether there are better ways in which we can recommend users their best streaming service.

Project Timeline

Touchpoints & Assignments Date Type

Program Kickoff

Aug 15 2024 Event

Student Pre-Kick-off Self-Assessment Form

Aug 26 2024 Evaluation

Deep-dive on the Organization

Sep 09 2024 Project Milestone

Student Temperature Check

Sep 18 2024 Evaluation

Design prototype dashboard and data-stream

Oct 07 2024 Project Milestone

Temperature Check #2

Oct 23 2024 Evaluation

Define Needs & Select KPI’s

Nov 04 2024 Project Milestone

Create KPI Dashboard Template & Map of Dataflow Logistics

Dec 06 2024 Project Milestone

Student Post-Engagement Self-Assessment Form

Dec 06 2024 Evaluation

Student Post-Engagement Peer Assessment Form

Dec 06 2024 Evaluation

Program Managers

Name Organization
Uma Gupta University of South Carolina - Upstate

Teams

Team Name  Project Name  Team Members 
No Teams Available