/Data-Warehouse-and-Business-Intelligence-for-IMDb

Talend Real-Time Data Platform 7.1 SQL Server Developer Edition Microsoft SQL server Management Studio Tableau Microsoft PowerBI

ETL-Pipelines-and-Business-Intelligence-on-IMDB-dataset

To setup this project install the following softwares

Talend Real-Time Data Platform 7.1 SQL Server Developer Edition Microsoft SQL server Management Studio Tableau Microsoft PowerBI

  1. Run the following scripts in SSMS to setup the staging database

The Number - stage tables.sql stg imdb tables - core tables.sql stg imdb tables expanded part 2.sql stg_ml_tables.sql

  1. Open Talend and setup your database connections and input file connections

  2. When the connections are successfull run the final job (Runtime 75 mins)

Data Warehouse using ER Studio

Talend Jobs Sample

PowerBI Jobs Sample

Tableau Jobs Sample