~Energy showcase Berlin-Brandenburg -~~

Energy showcase Berlin-Brandenburg -
A presentation application for the Brandenburg University of Technology Cottbus.

Our Task

Where, when and how do fluctuations between renewable electricity generation and electricity consumption occur in the Berlin/Brandenburg region? How do weather and other events affect the generation and load situation in the region?

These and other questions are addressed by the "SMART Capital Region" project of the BTU Cottbus and its project partners. With the interactive application "Energy Showcase Berlin-Brandenburg", it aims to illustrate the influencing factors, dependencies and effects of very different events and circumstances in the electricity grids for target groups with different qualifications.

In a dynamic web application, which can primarily be presented in the premises of the visitor centre of the BTU Cottbus, it should be possible to interactively present the changing "producer-load situation" in the electricity supply network of the Berlin/Brandenburg area.

Our Approach

The core element of the desired presentation application is an interactive map on which concrete moments of load and renewable generation in the region and its sub-regions can be displayed with the help of various view options, settings and filters. For this purpose, the map accesses the historical data of the grid operators, which are automatically fed into the system via a daily import.

  • Depending on the settings, it is possible to make visible on the map, for example:
  • Where how much is generated, where there is a high load, where there is a low load.
  • How various events and conditions affect generation and load. For example, the failure of one or more conventional power plants, high generation with low consumption at the weekend or also meteorological events such as storms, lulls or the "Bavarian sky" with a lot of sun and many clouds.
  • How renewable energies act on the different voltage levels in the distribution and transmission grid.
Load and power flow on the different network levels on a freely selectable day.
Impact of a stored meteorological event on load and power flow.
History view of the power flows of a selected region on a specific day at a specific time.

Selected features

  • Period selection: The application offers the possibility to play back all events and states over a freely selectable period of time. During playback, all data shown are updated in real time.
  • Chart view: An optional chart view shows - depending on the time - the curve progression of the measurement data.
  • Filter and view options: Various view settings (e.g. 2D/3D) and filter options (e.g. regional filtering by grid operator) can be used to illustrate possible correlations.
  • Scenarios: All settings can be saved as a scenario and are thus available during a presentation with one click.
  • Geodata: All map views (Berlin-Brandenburg, transmission grid, distribution grid, substations, etc.) are based on georeferenced data. This means that all data points have unique coordinates - an extension of the map views (e.g. to include further lines) is easily possible. In the application, the map views are displayed as SVG graphics.
  • Print function: Each view can be printed as a JPG using the print function. In this case, the current view is created on the server in a print-optimised format and then offered for download.  
  • For a first impression, we have summarised the functions of the application in a screencast here:


  • URL:
  • Kunde: Brandenburg University of Technology
  • Branche: Universität
  • Umsetzung: 4 months, 2016, extensions 2018
  • Technologie: D3.js Javascript library, responsive CSS framework "Amtrack" (in-house development), PHP framework Symfony, Qgis geoinformation system, Gulp and Sass as development standards
  • Leistungen: Concept, UI-design, frontend and backend programming, training