Data Modelling for Likert Scale from Sharepoint Survey Import

[Anonymous]

Hi everyone!

I have the following problem:

My data source is a sharepoint survey that includes likert scales. In the initial table I get in Power BI, all the answers from the likert scale are in one cell as a 'List' (see screenshot). In the list is a record and in the record is the parameter (here: DevOps) and the selected value (here: 2).

I would like to create a new table in which ProjectName and the five parameters (DevOps, etc.) from the likert scale are columns and the values are rows, as shown in the excel screenshot below. ProjectName I would like to connect back to the table from the data source.

Can anyone tell me how to transform the data in way described above?

Thanks a lot in advance!

Best,

Jonas

[AllisonKennedy]

You have the right idea - i recommend doing this in a separate table, so right click on the query in the left hand side and reference the 'raw data' query.

Then click the double arrow at the column heading for the likert scale question to expand the parameter and answer columns from the list of records.

Finally, select the two new columns and Pivot them (put the answer as values, and choose don't aggregate under advanced options).

Hope that all makes sense?