re: Make Peace In The BI-Versus-Excel Battle
Great Commentary. I'm going to put in a curve ball here and introduce you and your readers to a novel self-service BI solution that runs from Excel. It can connect to any data source, be it DBG侵s, DWG侵s, CRMG侵s, ERPG侵s, Spreadsheets, unstructured data, etcG仟
This is a unique proprietary solution that allows business users to easily create BI reports using just Microsoft Excel. This is the first time that Excel (the most widely and effective tool for this purpose and the professionals choice tool) is actually being used for this purpose. All previous shortcomings and issues that prevented Excel to be able to be used have been overcome using unique IP and development. These include:
G求Untrusted Data now becomes trusted data
G求Proliferation of thousand of disparate spreadsheets are now centrally stored
G求Historical Data can now be quickly refreshed with current data
G求No Backup / Recovery is overcome with a server architecture
G求Lack of Version Control is replaced by full versioning control
G求Lack of Entitlements is replaced with fine grained authorisation
G求Data volume limitations are now overcome.
This means that reports and intelligence needed by businesses is available much quicker than that which is currently available through existing BI tools such as Cognos, Hyperion, Business Objects, Tableau, Spotfire, etc. All of these require significant overhead to setup, training, management, support, change control, etc. The delivery lifecycle is reduced from weeks to minutes with Clear Analytics!
Coupling Clear Query with Clear Analytics means that for the first time business users are able to efficiently use heterogeneous data sources and work on them together within one reporting tool (in fact within one sheet of Excel) to create value business intelligence and reports.
The solution has been rolled out at International Investment & Retail Banks, Hedge Funds, Asset Management Firms, and throughout the Financial sector.
I welcome feedback and your opinion on this solution.