The attached ZIP file has 4 SQL views that your database administrator could run fairly quickly to add them to your Aeries Experience if you wish.
Program and Authorization Status (PGMS) - One flat row for their program involvement and authorizations.
Contacts On One Line (Pivoted) (CONP) - Yes it does just that when you query it.
Gradebook Analysis (GBKA) - Many rich details about how students are performing in a gradebook in aggregate
Attendance Percentage by Period (APBP)
Video walk throughs coming soon!