Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
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.
