One of the hidden benefits of using ClusterSeven to monitor spreadsheet activity is that the database stores a full history of every cell value as they evolve from one version to the next (such as JanP&L.xlsx going to FebP&L.xlsx to MarP&L.xlsx etc). This means that, on demand, users can visualize and compare historic trends of any important business parameter that would otherwise be hidden across multiple old spreadsheets. Without this many financiers will continue to have to laboriously copy and paste each piece of data to yet another spreadsheet – a process with which most will be frustratingly familiar.
At ClusterSeven we have to admit, however, that we are not the leading dashboard company in the world. So it makes great sense for us to make all this historic business data available to BI consumers. We are therefore extremely excited to see the work done by a leading QlikView partner to present this information in QlikView dashboards. To explore the capabilities of this ClusterSeven Reporter for QlikView visit the QlikMarket.
The benefits do not stop there. Even more exciting is that QlikView users can now combine their traditional analysis of structured data with this new source of unstructured historical financial data being fed from their spreadsheets. So, if your business process combines robust structured data sources and spreadsheets (e.g. multi-office reporting) you only have to go to one location to see everything. No need for yet more spreadsheets and no more cut-and-paste!