Actuate Corporation announced that the results of its recent survey of business end users and IT staff are now publicly available. The study revealed pent-up market demand for Web-enabled spreadsheet report creation and distribution products, which runs contrary to the goals of most data warehousing implementation projects undertaken by corporate IT departments. Such projects typically aim to have business users abandon their beloved spreadsheets in favor of more centralized data management. Interested parties can now directly download major findings of the survey as a PDF file from http://www.actuate.com/download/ActuateSurveyResults.pdf.

Wayne Eckerson, director of education and research at The Data Warehousing Institute, explains an anxiety commonly held by IT managers: “Spreadsheets make it too easy for groups to define their own metrics and to collect data from different sources at various levels of granularity at different times. Thus, each spreadsheet represents a unique view of the organization, an independent data mart or ‘spreadmart’ if you will whose data cannot be reconciled with other spreadmarts.”

Completed by Indigo Partners, the survey polled 518 respondents who use, develop or maintain numerical reports in companies with more than 500 employees. Among the more startling findings: fully 81 percent of IT managers surveyed admit that their end users continue to dump reports into desktop spreadsheets for easier manipulation.

It is the lack of server-side control over data access, data integrity and report manageability inherent in current spreadsheet creation tools that have made corporate IT departments reluctant to promote their use within the enterprise. However, Actuate’s survey revealed that if a spreadsheet reporting solution could provide a centralized managed service, IT could confidently embrace the huge installed base of enterprise Excel users, thereby fulfilling both sides’ needs. Spreadsheets could move beyond the realm of a personal productivity tools to become viable corporate reporting engines.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access