Analyze large amounts of data. Organize into a spreadsheet or spreadsheet with dashboard.
Can create dashboard to be automatically updating.
My preferred method is creating pivot tables with are great for automatic automation. This also allows for end user to be able to manipulate certain variables on dashboard (if desired).
Attached is a screenshot of a dashboard I created for revenue and leads.