/IMDB-Data-Processing-Analysis-and-Visualization

A full-fleged data processing, analysis and visualization project to collect data from various sources, load them in appropriate databases using ETL tools like Alteryx and Talend and finally visualising the end data using Tableau and PowerBI

IMDB Data Processing Analysis and Visualization

A full-fledged data processing, analysis, and visualization project to collect data from various sources load them into appropriate databases using ETL tools like Alteryx and Talend, and finally visualize the end data using Tableau and PowerBI.

Collected data from sources like SQL Server, MySQL, PostgreSQL, CSV/TSV files. Initially, created Staging Schema dumping all the data from these sources in it. Further, preprocessed, cleansed, prepared, and dumped data in the form of dimensions and facts in the database to create the Integration Schema and further created BI Schema for the purpose of visualization. Eventually, visualized the data from BI schema using tools like Tableau and PowerBI.