IMDB Movie Analysis

The aim of the project is to integrate and analyse data coming from the multiple sources such as IMDB, MoviesLens, The Numbers and BoxOffice Mojo.com based on movies/cast/box office revenues, movie brands and franchises. We utilized multiple features of the Talend and SQL server to optimize the complete ETL process. We then visualized the integrated data on tableau and Power BI to provide valuable insights like revenue share, ratings, geographical contribution to worldwide gross of movies etc.
Technologies Used: ER/ Studio,SQL server Developer Edition(On-Premise), Microsoft SQL server Management Studio, Talend Real-Time Data Platform 7.1, Tableau Desktop, Microsoft PowerBI