Skip to content

Created a dimensional star model, conducted data profiling and preparation, carried out ETL processes for staging and data integration, and developed BI reporting to analyze trends and generate valuable insights.

Notifications You must be signed in to change notification settings

AkilaBouazzaa/Oil-pipeline-accidents-data-integration-visualization

Repository files navigation

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

About

Created a dimensional star model, conducted data profiling and preparation, carried out ETL processes for staging and data integration, and developed BI reporting to analyze trends and generate valuable insights.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages