Compliance pressures prod IT to limit use of spreadsheets
Business intelligence vendors offer tools to eliminate input errors
Computerworld - In the face of tighter regulatory controls for reporting financial data, many IT departments are wrestling to eliminate or control the widespread use of spreadsheets. But many end users are likely to rebel if the ubiquitous tool is taken away from them.
Business intelligence vendors are maneuvering to offer solutions to the problem in the form of new software that can eliminate the errors often produced when data is entered into spreadsheets.
Actuate Corp. this week will unveil a new version of its e.Spreadsheet reporting software that can provide auditable and repeatable processes to spreadsheets. And last week, Oracle Corp. rolled out a new stand-alone business intelligence product featuring an Excel plug-in to ensure that data is obtained directly from corporate databases.
Actuate added a "cell locking" feature to allow report designers to password-protect specific cells in a spreadsheet. Data can be distributed to users for controlled analysis without compromising operational data and business logic, said Mike Thoma, vice president of marketing at South San Francisco-based Actuate.
"Politically, it's devastating to take away the spreadsheets from the end user," Thoma said. "But on the other hand, you don't want to go to jail."
CheckFree Corp., a Norcross, Ga.-based electronic bill payment and banking services company, began using the e.Spreadsheet tool this year.
"The finance department was trying to get data ready to publish [for Wall Street], manually querying sources and pulling data together in spreadsheets," said Kevin McDearis, CheckFree's vice president of data and delivery. "They were quite nervous about that."
But e.Spreadsheet applied consistent business rules to the data to avoid compliance problems, he said.
Odom's Tennessee Pride Sausage Inc. in Madison, Tenn., will use Actuate's cell-locking capabilities to provide sales and marketing employees with access to sales data that can be shared with customers and brokers, said Michael Hader, Odom's IT manager. "Re-entering data into Excel means they could get the wrong data for the wrong product in the wrong spot," he said.
- Best iPhone, iPad Business Apps for 2014
- 14 Tech Conventions You Should Attend in 2014
- 10 Desktop Apps to Power Your Windows PC
- How to Add New Job Skills Without Going Back to School
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Analyst Report-Mixed All Flash Arrays Delivers Safer Higher Performance What is the impact of an all-flash array with enterprise features and reliability on the mainstream data center? In the mainstream environment, storage...
- Four Myths of High-Productivity App Dev Debunked Debunk the main myths surrounding high-productivity application development and how both platforms have overcome them.
- Six Ways Your Small Business Can Save with Internet Phone Service Traditional phone systems present two main problems for businesses: limited features and high costs. As a result, small businesses are migrating to Internet...
- The value of smarter oil and gas fields With global energy requirements continuing to rise, the exploration, development and production of new oil and gas resources are shifting to increasingly challenging...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
On-Demand Webcast: 7 Reasons to Choose VoIP
Thinking about a new phone system for your business?
Be sure to watch this informative webcast. Steve Strauss, small business columnist for USA...
- Top 8 Communications Tools for Small Businesses Powerful technology is available to help your small business improve its communications with customers, employees and suppliers. View this free On-Demand Webcast produced... All Business Intelligence/Analytics White Papers | Webcasts
By Rob F. Walker, Ph.D.
In the previous installment, we looked at and discussed strategies for business simulation and the infrastructure needed to make such initiatives successful. Now, we¿re ready to discuss some practical examples of business simulation. Imagine a mail order company selling products together with the necessary financing. more