Application which uses data from the norwegian Reservoir Statistics api endpoints.
The data goes through the processes:
- Extracted from the Reservoir Statistics API
- Transformed to fit the PostgreSQL schemas in database with Pandas
- Loaded into the database
- Further transformed with SQL queries and DBT
- Visualization with Power BI or Looker studio
- Python (Pandas, SQLAlchemy, Pydantic, requests, logging)
- PostgreSQL
- DBT
- Docker
- Power BI / Google Looker studio
