Here is a quick demonstration showing how to use slicers in Microsoft Excel 2010. In this particular example we are analyzing margins by office, salesperson, business unit, etc. This is made easy for our 1Staff Back Office (PAM) customers as we have built staffing business intelligence into the system.
If you want to skip the initial discussion around the staffing company specific items you can jump a minute into the video.
This is using Excel for analytics. There are other advanced reporting options we can provide such as QlikView or see how you can build inline dashboards in our 1Staff Front Office using Microsoft CRM 2011.
Because we have a fully integrated staffing back office pay/bill system including General Ledger and Accounts Payable you can include more transactions for tighter margin reporting.