Spreadsheets And BI
by Boris Evelson.
I predict that for the foreseeable future, spreadsheets will remain the most widely used enterprise application. The widespread adoption isn't hard to understand — spreadsheets are powerful and flexible, yet intuitive and easy to use and learn. Plus, ad hoc applications and spreadsheet models isolate users from constant reliance on IT and incur low costs. Since the early days of BI, spreadsheets have played a natural and major role in the BI process/architecture, including:
- Data sources
- Transformation mechanisms
- Operational applications
- Reporting and analysis mechanisms
I recently published a report on spreadsheets and BI, http://www.forrester.com/Research/Document/0,7211,41687,00.html, and would love to solicit everyone’s comments on the future of spreadsheets in BI.