My latest approach is to visualize spreadsheets of data using mind map. I use spreadsheet because they are easier to work with and filter, and I either re-use columns or add new columns so I can visulize on a single page.
At this point in time this code only works with 4 fixed levels and format makes it easy to copy paste into Free Mind freeware.
In the future I will update the code to make it work with levels between 1 to 4 (so doesn't have to be 4) and probably do a separate version that works with texttomindmap.com website.
Add or use 4 columns from a spreadsheet and add an extra column with the formula below:
=IF(ROW(B3)=3," ","UNION ALL ") & "SELECT '"&B:B&"' as Level1, '" &C:C&"' AS Level2, '" &D:D&"' AS Level3, '"&E:E&"' AS Level4"
Note: Update columns reference for levels so correct order of columns is used.
Open SSMS and:
a) Paste the beginning of the code
CASE WHEN Level2 IS NULL
THEN ISNULL(Level1,'') ELSE '' END,
CASE WHEN Level3 IS NULL
THEN ISNULL(Level2,'') ELSE '' END,
CASE WHEN Level4 IS NULL
THEN ISNULL(Level3,'') ELSE '' END
SELECT Level1, level2, Level3, Level4
b) Copy paste spreadsheet data where we have the formula (second part of T-SQL Query.
c) Paste the code below at the end of the query that will complete the query
) as q
GROUP BY Level1, level2, Level3, Level4 WITH ROLLUP
) as t
WHERE Level1 IS NOT NULL
ORDER BY Level1, level2, Level3, Level4
a) Run the query
b) Select data and copy it
c) Paste into notepad
d) Using notepad, select all data (again, needed to avoid issues) and copy the data
e) Open FreeMind, create new file, right click middle object and paste data.
Hopefully that will create your mind map
Note: Maintenance is fairly easy, simply repeat the step which should take less than 5 minutes which makes it suitable for infrequent updates.
Hope that helps