Prime Video Membership Monitor

Inspiration 💡

The inspiration for creating the Amazon Prime Membership Monitor stemmed from a desire to empower Prime Video creators with actionable insights into their audience engagement. I wanted to develop a tool that would provide administrators with comprehensive visibility into customer watch habits and preferences which can make an impact in data-driven decisions from the management perspective and help in overall product growth. As a daily user of amazon prime video, I was able to relate the context of data and I was aware how well this visualization can help in improving the product. So this idea emerged from my lifestyle routines.

What it does ✨

It is specifically tailored for administrators of Prime Video creators, aiming to provide insights into customer watch habits and engagement. Key features include tracking total membership , identifying members expiring within a week or month, tracking monthly new joiners, issuing membership renewal reminders, analyzing device usage by customers, determining frequency of usage, exploring popular genres, and uncovering customer support insights.

How I built it 🛠️

Since I wanted to create a dashboard, I had few tools(Google Charts, Tableau, Power BI) in my mind. Considering the timeline, ease of use and ease of integration of the Power BI I decided to go with it. I began by finding the right dataset freely available. After lot of researching I found my dataset in Kaggle. Then I imported and cleansed the dataset and transformed it into star schema for the optimum performance. After lot of thought works on how best I can showcase the data so that it would be the best tool for Prime Video administrators I decided the KPI's and Visuals. Utilizing Power BI's interactive capabilities, I implemented dynamic filters and drill-down functionalities to enhance user interactivity and facilitate deeper exploration of the data.

Finally I published the Dashboard in a new workspace. Voila 🎉 the application is ready.

Challenges I ran into 😵‍💫

Finding the right dataset with required features was a challenging task. While browsing the datasets, I imagined myself as a Prime Video administrator and what is the final product and user experience I want.

Since I don't have much idea on designing perspective of things, I did spent a lot of time on how user experience and modern design can be collated together along with the functionalities required for the visualization.

Adding the membership renew reminder feature was no joke. Power BI didn't have features out of the box for this. After lot of research finally figured a workaround.

Accomplishments that I'm proud of 😎

One accomplishment that I am particularly proud of is the implementation of the dashboard's membership renewal reminder feature. Recognizing the importance of membership retention for Prime Video creators, I devised a solution that automatically identifies members whose subscriptions are expiring soon and sends timely reminders to administrators. This feature not only enhances user engagement but also contributes to the long-term sustainability of the platform.

What I learned 💻

Working with this project provided me with an immersive learning experience in the art of crafting dashboards and UI/UX design principles.

Built With

• microsoftfabrics
• opendataset
• powerbi