Visualising SharePoint online structure

[Blue407]

I am using Odata to Microsoft Graph to import all sites and subsites from SharePoint Online.

There is a column for ID, which consists of Hostname Id, Site Id and Collection Id. I duplicate this, then split the duplicated column into the 3 separate ID's.

Hostname Id - the Domain

Site Id - The unique Id for the individual site (also have name fields)

Collection Id - The unique Id, within the Site Id, for the collection

What I want to do next is visualise this, creating a sitemap/tree with the Hostname Id on the left, then each Site Id in the middle and then Collection ID's off from that.

For each one, I'd like to shop some additional information, such as last used, name, created date etc. All columns I already have.

Any suggestions how I can do this?

I did see some things using Visio to visualise things, but it seemed more aimed at static data, rather than everything being dynamic.

[lbendlin · Accepted solution]

look into decomposition tree, or some of the network graph visuals.

[christinepayton · Accepted solution]

Honestly the matrix visual is the most readable core visual for hierarchical data - everything else truncates text after not-very-many characters in the visualization (eg the tree/decomp). You might drop some metrics in there to make it a bit more interesting if you have any, like pageview counts or last modified date or something. 

[lbendlin]

Have you considered using tools that were designed for this, like Purview or Collibra?

[Blue407]

Yes, but we are centralising all our reporting into PowerBi, it would be a shame to have to use a different tool just for this.

My need seems quite simple, the data is there and structured, just need a way to display it.

[lbendlin · Accepted solution]

look into decomposition tree, or some of the network graph visuals.