We use Microsoft Dynamics CRM for our complaints system, data management, and reports for all information that is related to external customer data. I spool the data from Microsoft Dynamics CRM and then I use Microsoft Excel to process, analyze, and get insight into the data. Microsoft Dynamics CRM has an analytics aspect, but we have not been using it because the data that has been fed in is not clean enough. The analytics aspect of Microsoft Dynamics CRM does not give us the results that we want. Most of the time I have to spool the data myself, clean it, by using Microsoft Excel, and then I have to process it before I can generate reports.
For internal workflow processes, we use ProcessMaker.