The best way (in my opinion) to do this is using the Meraki API. Once you extract the data, you can manipulate and display it using your preferred data analysis tool (PowerBI, for example), this is the way we extract this data to our customers today.