Does BCP support analytics?
All updates to the BCP data can be accessed through a query and used to support analytics. For example, you can compare the data now with a change last week by a particular user. Within a browser window, you can compare any slice of data against any other slide of data and do absolute, percent and side-by-side analytics. The change data can then be taken back into the Excel environment for more robust report presentations & analytics. Within Excel, you can import a set of changes into the active data range and BCP will update the changed values (including formulas) and use the comments feature in Excel is used to indicate the change.