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.