D2L Outcomes Data PivotTable to re-create Mastery View

Creating a PivotTable in Excel with text-only data is possible, but there are several extra steps. You must create a table from your data and add it to the Data Model, then add a Measure in the PivotTable. This is only possible with the Windows version of Excel.

This video shows how to pivot the data in a learning outcomes data set generated from the Insights Report Builder so that it matches the Mastery View table in D2L. Students are in rows, outcomes are in columns, and the mastery levels are the values. See the ETL data flow that can be used in Domo Analytics to generate this data.

Formula from video:  

=CONCATENATEX(Table1,Table1[MasteryLevel])

A Python script to pivot the data without using Excel can also be downloaded.