README.md

Oil pipeline Accidents: Data integration & visualization

• Developed data integration workflow in Talend Open Studio and created dashboards using Power BI for trend analysis and generating insights.
• Designed dimensional model in MySQL for Oil Pipeline Accidents, 2010-2017.

Technologies

• Talend Open Studio
• MySQL

Dashboards

• Pipeline accidents on Map
• Trend charts for number of accidents by date

Data Source

the used data is the oil pipeline accident reports that were collected and published by the DOT’s Pipeline and Hazardous Materials Safety Administration, 2017. Find in the link below: https://www.kaggle.com/datasets/usdot/pipeline-accidents