This project focuses on analyzing the MAVENMOVIES database to extract valuable insights that can enhance business operations, marketing strategies, and inventory management. SQL is extensively used to perform exploratory data analysis (EDA), understand the database schema, and answer critical business queries.
- mjshubham21
- 🐬 MySQL – For editing SQL code
- 📊 Maven Analytics – Source of the dataset
- 💻 Visual Studio Code – To push the project to GitHub
- 📈 Excel
- 🗃️ SQL
- 📊 Data Visualization
- 📊 Power BI
- 🐍 Python for Data Analytics
- 🛠️ Git
- Identify customer details (names, emails) to enhance targeted marketing campaigns
- Analyze rental behavior to improve customer engagement
- Evaluate rental inventory and categorize movies based on rental rates and availability
- Suggest recommendations for expanding the movie collection based on popularity and rental trends
- Examine rental pricing trends to identify profitable pricing strategies
- Determine the most rented movie categories and ratings to maximize earnings
- Track and manage movie inventory efficiently
- Identify inventory gaps and optimize stock levels
- 📢 Enhanced marketing strategies based on customer segmentation and preferences
- 🎬 Optimized inventory management with improved stock replenishment strategies
- 💵 Increased revenue generation through data-driven pricing and rental trends
- ⚙️ Operational efficiency with a structured approach to inventory tracking
