All work
Business Intelligence / Data Engineering
Earthquake Analytics Pipeline
An end-to-end pipeline from PHIVOLCS earthquake data to a Power BI report.
Business problem
Public earthquake records were not in a form that supported analysis or reporting.
Solution
- Cleaned and transformed PHIVOLCS data, loaded it into PostgreSQL and reported on it in Power BI.
Measurable impact
End-to-end
Source-to-dashboard pipeline
Technical implementation
- Python cleaning and transformation.
- PostgreSQL storage.
- Power BI reporting.
- Python
- PostgreSQL
- Power BI
Source
Have a data problem that's taking too much time?
Whether it's a manual reporting process, disconnected data or an analytics bottleneck, I build systems that turn that complexity into something useful.