Forum Discussion

kormosb's avatar
kormosb
Helper III
4 years ago

Visual idea help

Hey Guys,

 

I would like to visualize the following.

I have different kind of trainings which have prerequisite trainings in the following table.

So we have training ID-s (every row different), and every training has a general training level (basic, intermediate, advanced, and so on - to 6 level). To be able to participate at an intermediate training you have to finish ALL the basic level trainings (third column - training prerequisite level), and for advanced trainings you have to finish all the basic and intermediate trainings. Furthermore - column 4: training prerequisite training - in some rare scenario you have to finish a special training to be able to participate (for example to start "Training ID 4" you need to finish "Training ID 3".

 

Training IDTraining levelTraining prerequisite levelTraining prerequisite training
1Basic- 
2Basic- 
3IntermediateBasic 
4IntermediateBasic3
5AdvancedIntermediate 

 

I would like to visualize the links between the trainings, to see which trainings I should finish to be able to start an advanced training in a graph chart or somewhere. Do you have any suggestions what chart I should use?

 

Thanks in advance!

 

Kind regards,

Benjamin

Need Help

6 Replies

  • kormosb's avatar
    kormosb
    Helper III
    4 years ago

    And how can I create more "columns" in the sankey chart for all the training levels?

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      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.

      • kormosb's avatar
        kormosb
        Helper III
        4 years ago

        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?