Skip to content

This is a Capstone Project which provides an in-depth analysis of the Shakila DVD Rental Store, utilizing Excel, SQL, and Power BI to deliver actionable insights and dynamic dashboard visualization for enhancing business operations and customer experiences in the movie rental industry.

Notifications You must be signed in to change notification settings

DA-Atharv/Movie_Rental_Analysis

Repository files navigation

Shakila_DVD_Store_Rental_Analytics:

Overview:

The Movie Rental Analytics capstone project delves deep into the Sakila DVD Store Data, offering a thorough exploration of the DVD rental store domain. Through meticulous data analysis and visualization techniques, we uncover valuable insights into customer behavior, film inventory management, staff productivity, and revenue trends. Our goal is to equip rental store owners with actionable insights for strategic decision-making and operational excellence. By focusing on enhancing customer satisfaction and operational efficiency, our findings serve as a blueprint for informed business strategies and increased profitability, ultimately empowering rental store owners to achieve success in their ventures.

Dashboard:

Location Analysis Dashboard:

image

Customer Analysis Dashboard:

image

Film Analysis Dashboard:

image

Revenue Analysis Dashboard:

image

Rental Analysis Dashboard:

image

Actor Analysis Dashboard:

image

Key Insights:

  • Customer Insight for Tailored Marketing: Utilize analysis of customer preferences, rental behaviors, and demographics to craft targeted marketing campaigns and personalized content offerings, fostering heightened customer satisfaction and loyalty.

  • Film Revenue Optimization: Evaluate film inventory, rental rates, and popularity to identify high-performing titles that drive revenue and customer engagement, guiding strategic decisions on content acquisition and inventory management for sustained profitability.

  • Staff Performance Enhancement: Assess staff productivity metrics and tenure to refine workforce management strategies, ensuring streamlined store operations and elevated customer service standards.

  • Revenue Trend Forecasting: Recognize revenue fluctuations, seasonal patterns, and geographical variations to inform strategic decision-making aimed at maximizing revenue potential and driving business growth.

  • Market Expansion Insights: Identify lucrative markets, top-performing genres, and key customer segments to inform targeted market development initiatives, facilitating expansion into new territories and audience demographics.

  • Operational Efficiency Boost: Leverage data-driven insights to optimize operational processes, refine inventory management practices, and elevate customer service standards, resulting in cost savings and improved resource allocation.

  • Enhanced Customer Experiences: Implement strategies informed by customer behavior analysis to deliver personalized experiences, leading to enhanced satisfaction and loyalty.

  • Strategic Decision Empowerment: Equip rental store owners with actionable insights and a comprehensive strategic roadmap, enabling them to make informed decisions aligned with business objectives, mitigate risks, and seize growth opportunities in a dynamic market landscape.

About

This is a Capstone Project which provides an in-depth analysis of the Shakila DVD Rental Store, utilizing Excel, SQL, and Power BI to deliver actionable insights and dynamic dashboard visualization for enhancing business operations and customer experiences in the movie rental industry.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages