IMDb Data Warehousing & Business Intelligence

• Designed and implemented an Analytical Data Architecture (ADA) for data profiling, cleansing and ETL operations from multiple data sources such as CSV files and SQL databases
• Implemented data profiling and staging in Alteryx Designer and integrated data into DI schema (dimensional data model) using Talend Open Studio to create a single source of truth
• Generated insights using data visualization tools for total revenue generated and top-grossing movies of all time

Architecture diagram

Entity Relationship Diagrams

Data Staging

Data Integration

Technologies Used

• Talend Open Studio
• Alteryx Designer
• SQL (MySQL, SQL Server, PostgreSQL)
• BI Tools (Tableau, Power BI)

BI Dashboard (Tableau)