This project examines the performance and strategic risks of high-budget Tamil films released between 2024 and 2025. Using advanced analytics (SQL, R, Tableau), the study reveals key insights into budget allocation, box office success, and financial impact for industry stakeholders.
Tableau Public Link: https://public.tableau.com/views/Book1_17576095394330/BudgetvsCollection?:language=en-US&:sid=&:redirect=auth&:display_count=n&:origin=viz_share_link
- Do high-budget Tamil films deliver better box office results?
- What is the relationship between budget and collection?
- Which films and genres faced the biggest financial risks?
- How does release timing influence success?
- How can studios optimize investment for better returns?
- Source:
tamil_movies_2024_2025_final.csv - Rows: Each record = a Tamil movie released in 2024–2025
- Columns: Budget (₹ Cr), Collection (₹ Cr), Genre, Release Date, Verdict (Box Office outcome), ROI, etc.
- SQL (BigQuery): Data cleaning and aggregation
- Tableau: Dashboard & story creation
- R & Python: Statistical analysis (scripts available on request)
- Budget vs Collection: Clusters of success and failure vs. budget size
- ROI by Budget Segment: Median ROI lowest in high-budget category
- Success Rate Comparison: Medium-budget films are safest bets
- High-Budget Failures: Four films resulted in ₹544.8 Cr losses
- Monthly & Genre Heatmaps: Timing and genre drive success probability
- High-budget films have only a 42.9% success rate (medium budget: 50%)
- Average ROI for high-budget: -14.88%
- Release in August = 67% success rate (February: worst)
- Crime/Thriller & Sports/Drama genres perform best across budgets
- Bigger budget ≠ higher success → strategic budgeting is essential
tamil_movies_2024_2025_final.csv– Clean datasetTamil_Cinema_Budget_Analysis_Report.pdf– Full project report*.jpg– Exported visuals (e.g., Budget-vs-Collection.jpg).pptx– Presentation slides (if applicable)/images/– All key dashboard chartsREADME.md– Project documentation
- Download or clone the repo.
- Review the report and visuals for business insights.
- Explore the dataset for your own modeling or extensions.
- Access Tableau workbook or code for reproducibility (if included).
- Author: Manoj Prabakaran
- Portfolio: [your-website-link]
- LinkedIn: linkedin.com/in/manoj-prabakaran-18b575259
- Email: manojprabakaran2040@gmail.com
This project demonstrates end-to-end data analytics skills, business storytelling, and actionable insights for the entertainment industry—ideal for entry-level and growth roles in data analytics, business intelligence, and strategy.