Database analytics, mapping and visualization

Contract type:Freelancer
Client:Distribution system operator / Energy provider
Task:Implementation of ETL processes to transform PostgreSQL/PostGIS data into an ArangoDB, creation of tools (e.g. visualisation, validation and anonymisation) and dashboards with Python.
Time period:07/2021 to 06/2022
Technologies:Python, Pandas, Numpy, Matplotlib, Networkx, Plotly, Bokeh, SQL, PostgreSQL, PostGIS, Jupyter Lab, VS Code, DBeaver, Gitlab, Microsoft Azure Cloud

For a distribution system operator / energy provider, I analysed geospatial and structured datasets within a PostgreSQL database. I also implemented ETL processes to transform, validate and store Postgres/PostGIS datasets into a graph database (ArangoDB).
Furthermore, I developed recursive CTE queries with SQL and a corresponding dashboard with Python, which is used to visualise and validate power grids by user input. I have also implemented tools for validating and anonymising mapping datasets with SQL and Python.
Finally, all results/tools were uploaded to an internal Gitlab-Repo and supplemented with corresponding readme files (Markdown). Organizationally, the coding was structured by a Scrum process.

error: Dieser Inhalt ist geschützt!
Cookie Consent Banner by Real Cookie Banner