Forum Discussion
Visual idea help
Sankey works on pairs of data. Basic to Intermediate, Intermediate to Advanced etc. For each possible combination provide the number of users who completed that path (for example) and the Sankey will do the rest.
Can you help me with your idea? I uploaded the sample excel and PBI file here: PBI community files
I think I should create 2 table, one for the training id-s and one for the prerequisite requirements, and should list all the prerequisite training id-s for 1 training. The structure of the data is wrong I reckon (that I have a prerequisite level for one training - which can mean 10-15 prerequisite trainings), I would need all the prerequisite training id-s for one training id. What do you think?
Thank you for providing the sample data. That helps a lot with proposing a potential solution.
Something like this?
or more aggregated like this?
Thank you for your advice!
I need similar design as the first pic you sent, but it would be important to visualize the connection between the trainings (so not just the levels). I mean I have to show what the prerequisite trainings of each training are (so what are the prerequisite trainings for the level 4 trainings). So, we need more „columns” to be shown.
My solution would be the below at the moment. But the problem with that is that I can’t see the prerequisite training IDs, if they are on the same training level.