I'm in a bit of a pickle and don't really know if can solve my problem with SharePoint. My company wants to build an organizational chart (easy, right ?) that will allow us to know every job that we have and ultimately where we have open positions.
So we want to build a chart just like the one I link to this post, knowing it can be dynamic. By that, I mean that at any point, a regional manager for instance can add a new country organization, a manager can add a new employee position, etc... (we don't care - for now - about knowing who is filling the position, we just want to know the job titles we have)
So first, we want to know back at HQ the organizational structures of each region and country. After this, we want to be able to flag if a given position is filled or not and be able to collate the number of open positions globally (e.g. something like "3 manager positions available | 3 employees positions available" etc... and then go into details for which region, country, it's opened).
I'm in the process of gathering the data on an Excel file. I'm sort of struggling to see how I can then translate this to SharePoint. I checked what I can do with importing my Excel in Visio and then publishing to SharePoint, but it's just a frozen picture, so not really a solution.
So do you think this is even feasible with SharePoint and if so, do you have any tips at how I might tackle this challenge ? PS: We have SharePoint online. I don't know a lot about SharePoint designer, but I can always learn :)