Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

1
How to: Excel data set up so it can enable a dependency tree in Power Bi?
Post Flair (click to view more posts with a particular flair)
Post Body

Hey all, Would appreciate your wisdom. I have a basic excel table: Column A acts as a parent, Column B as the category and column C as subcategory. Example of data: Column A. Column B. Column C Software name. component. Sub component

Effectively it’s a simple chain of hierarchy. I would like to visualise it, perhaps in a decomposition tree or network relationship type diagram. I assume PowerBi is the best way to do that. However I am struggling to model the data in excel in su CJ a way that I can then import into PowerBi and for it to them make sense visually. Think of it like a CMDB type of a visual, each component links to another. Any help is much appreciated.

Author
Account Strength
80%
Account Age
4 years
Verified Email
Yes
Verified Flair
No
Total Karma
55
Link Karma
21
Comment Karma
34
Profile updated: 5 days ago
Posts updated: 5 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
6 months ago