Database Projects (SQL/MySQL/HQL)
RSVP Movies Global Growth Strategy: Success Factors
The IMDb Dataset Analysis project utilizes SQL to explore and analyze a comprehensive movie database, uncovering key trends in the film industry. By examining factors such as movie ratings, genre popularity, director influence, and revenue performance, this project provides valuable insights into what contributes to a movie's success. The analysis also identifies top-rated films, regional production trends, and revenue patterns over time. These findings help stakeholders understand audience preferences and industry dynamics, making data-driven decisions in film production and distribution.
Cosmetic Sales Click Stream Analysis
The Cosmetic Sales Click Stream Analysis project leverages HiveQL and SQL to extract valuable insights from e-commerce transaction and user behavior data. By analyzing sales performance, customer navigation patterns, and marketing impact, this project identifies key trends in product demand, revenue growth, and customer engagement. The study also evaluates the effectiveness of promotional campaigns, optimizes inventory management, and detects potential fraud. These insights help businesses enhance the online shopping experience, improve marketing strategies, and boost overall sales performance.