Data explorer would probably be the best approach here. You may need to create different queries for each task (e.g. the per user breakdown would be a different query)
The only thing data explorer can’t do is the ‘auto generated and emailed to me’ point. If this is a requirement, you could potentially do it by calling the data explorer API from some other system.