I have to display many-to-many relationships between offices and sub-offices for a client. Each office manages many sub-offices, each sub-office can be managed by many offices. The client is requesting the work to be done in CartoDB's online platform so they can easily make changes to it if necessary.
What I'd like to do is create a boundary line, with each office's coordinates as the centrum point, and the line to go around each sub-office. I'll use this to show overlaps.
It's been a few years since I've used any GIS software, and when I did it was QGIS or ArcGIS, mostly through the GUI. Conceptually I'm not sure where to get started. At the moment I have two data files, offices with coordinates, name, and sub-offices covered, and sub-offices with coordinates and names.