Dynamic & Interactive Org chart with Smartsheet data as backend - Using Python and d3.js

Smaller teams and organizations at times struggles when it comes to building a customized dynamic organization / team chart / structure. There are a lot of tools and plugins which provide a good visualization but they lack the data management aspects. Some of them need quite a lot of manual efforts.

Here is my attempt to address some of these issues and making it easy for smaller teams to build their own organization chart.

Key Features of this solution

Profile image
Multilevel hierarchy
Integration with smartsheet to dynamically pull data and profile images
Detailed profile view
Tags for managing skills tagging
Search / Locate feature
Full Screen feature
Expand / Collapse feature
Scalable - Ability to include more fields / tags
Customization feasibility - UI and color scheme can be customized
Maintainability - Data can be managed easily in smartsheet. Team Leads can collaborate to maintain their teams data easily using smartsheet's collaboration features
Extensibility - Can be extended to leverage other data sources e.g. json, flat file, structured databases, spreadsheet

Smartsheets are really awesome when it comes to managing data and collaborating across different teams. It comes very handy when you need to manage data in spreadsheet format and at the same time want multiple contributors to add / update to it simultaneously. However when it comes to visualizations, smartsheet lacks a bit. They have a good card view, but its not very intuitive and do not produce a very good visualization.

Smartsheets provides API to programmatically access and manage smartsheet data. There is smartsheet python SDK which can be used to connect to smartsheets using your python applications.

This way teams and HRs can manage their team details and changes in smartsheet at their convenience in spreadsheet format including their profile photos and not to worry about the visualization.