Intune Data Warehouse and user Groups

Hi

I'm looking for some pointers.  I want to create two reports from Intune Data Warehouse:

Report 1 - Iisting a Group with it's assigned users and if they've enrolled their Android device.  I can get users and devices from the data model but I cannot find a table containing Groups.

Report 2 : Showing a Group and the Android apps it is assigned to.  Ideally to assignment level (Required, available for enrolled etc.). 

In both cases I need the Group information.  Is there a table with this info in the data warehouse model or do I need to get it from Azure/csv?

Thanks in advance.