LEDCity Sales Map UI

header background

LEDCity Sales Map UI

Project by: Brilla Tomy Kollaramalil and Nico Gorbach
Nico Gorbach Brilla Tomy Kollaramalil  
Nico Gorbach Brilla Tomy Kollaramalil  


LEDCity was founded in 2017 with a vision to significantly reduce energy consumption in the lighting sector which is responsible for 12% of global electricity usage. LEDCity develops an autonomous plug and play lighting system that can reduce energy consumption by over 90%. The integrated sensor and control system allows the lighting to be regulated autonomously according to demand. This not only eliminates the need for any external control components during construction, but also allows data such as energy consumption and people movements to be collected in real time.

Our students partnered up with LEDCity to analyze sales data and to develop a visualization solution to have a better control over the sales and client contacts. The resulting application is called LEDCity Sales Map UI, a map based landing page as well as a KPI chart board. The two-page application shows sales location of the client on a geographical map and a graphical representation of sales data. On both pages it is possible to import data from Bexio excel and CSV files.

Tools and technologies used in this project

  • Python
  • Django
  • PostgreSQL
  • JavaScript
  • React - Redux 
  • Styled components
  • Docker
  • Digitalocean
  • Gitlab CI CD

Project details

The goal was to analyze and support the sales process of LEDCity in a specific city using a map dashboard. Before starting the project, there was no clear overview on the location of individual sales departments, client contact records, and outcomes. Also for sales meeting preparation in a dedicated region, it was not possible to get easy data access to where other projects in the surroundings of a company/sales region had already been done and where a potential sales re-visit could be combined.

With the help of the technologies mentioned above, our students were able to combine different data sources to retrieve an address, convert an address to Geolocations, visualize locations as pin-points in the map and import data from CSV or XLSX Loader for Bexio Data for the first iteration of the platform.

In a second step the filter function for the display (time frame / contact person / status / project size) was implemented as well as a map zooming functionality (+ / - / reset). Further features like hover information when pointing on a pin-point marker, right click support (e.g. get location), user login to save settings (e.g. color / style of pin-point markers or map background data source) were developed.


Our students designed and developed a Frontend for LEDCity AG including the following functionalities:
  • Visualization of Geolocation points on Geographical Map
  • Loader dialog for datasets (Contact list for address locations + sales process list (e.g. offers / orders / deliveries / invoices)
  • Convert address locations to geolocations
  • Filter to visualize only parts of the data (time span select / salesperson select / order,project volume)

For the next steps our students defined possible further extensions of the application such as integrating other data sources like GeoAdmin, Energy cities, 2000-Watt sites etc.



Florian Gärtner says:

Together with the team from Constructor Learning we have been able to set up an exciting project. The students were able to work independently on the development of our sales map, which we have now integrated into our everyday sales life.

Interested in reading more about the Final Student Projects? Then check out some other interesting Full-Stack and Data Science projects.

Read more
Project work