Visualising SharePoint online sites and subsites

[Blue407]

I am using Odata link to Microsoft Graph to import all sites and subsites from SharePoint Online. This bit works okay.

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

My understanding is that there is only one Hostname (our Tenant/Domain), so this can be ignored.

Next, Site Id is unique within our Tenant, subsites will share the same Site Id, but each have their own Collection Id.

Here's some of the data, you can see multiple Site Id's that match, but with different Collection Id's:

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

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

I would like it to look something like this, either horizontaly, or verticaly. 

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.

[christinepayton]

You need data about the "parent" of each item to visualize the hierarchy, do you have that? Usually you can get it by splitting the path for the site, since it'll go root site/subsite1/subsite2/subsite3 down the tree. Then when you split, you can use each of those columns as a "level" in visuals (I like the matrix because it's easier to read, but there are others).