BI Vendors Finally Embrace the Spreadsheet
Like the cockroach, spreadsheets are hard to kill. That's why BI vendors are welcoming the beloved business app.
Spreadsheets are the technological equivalent of cockroaches: They've been in existence for decades, they can spread like wildfire, and no one has quite figured out how to stop their proliferation—even if they really, really want to.
Print
For years, software vendors of all stripes (excluding Microsoft, of course) have offered their own high-tech versions of "integrated pest management" solutions to rid their customers' environments of spreadsheets—to cease the flow of human-introduced errors into corporate information and achieve that desired "one version of the truth" view. One spreadsheet investigation, for instance, found that 80 percent of spreadsheets contain significant errors.
Myriad, mistake-filled spreadsheets can lead to discrepancies in key financial reporting data that can put companies in legal jeopardy. (Just ask any CFO.) Several CIOs have told me about executive-level strategic sessions that have been derailed by the game of "Who's Excel Numbers Are Right?" It's not a fun game.
The thing is, though, many business users don't view Excel as an accomplice in committing crimes against the company; they consider it one of their most trusted technological friends. That user affinity has made mitigating spreadsheet use similar to using a cheap "bug spray" to wipe out cockroach infestations: The roaches always return.
In turn, vendors—especially those with business intelligence plays—have finally shifted to a "Live and Let Live" strategy for spreadsheets. New technologies aim to integrate spreadsheet data into sanctioned corporate information streams and depositories. The transition hasn't been easy, but it's finally catching on.
At the enterprise end of the vendor spectrum, there is SAP's partnership with Microsoft on Duet, which is a notable effort: Duet allows "information workers to easily and quickly participate in SAP business processes and share SAP business data via the familiar Office environment," according to SAP and Microsoft.
Smaller vendors, such as Cambridge Semantics, offer products that attempt to unlock and aggregate the data trapped in spreadsheets. "It's no secret that despite the proliferation of BI applications, the use of Excel spreadsheets for most information and reporting needs still dominates," stated Sean Martin, co-founder and CTO of Cambridge Semantics, on its website. "If anything, usage of Excel has become even more prevalent over the last decade." (There are many other vendors out there attacking this problem, so please go easy on me, PR friends.)
That sentiment is backed up in a recent blog post by Forrester Research principal analyst Boris Evelson. He offers several insightful practices for "controlling and managing (not getting rid of!) spreadsheets as a BI tool." For instance, Evelson's first suggestion is this: "Create a spreadsheet governance policy. Make it flexible—if it's not, people will fight it."
It's a worthy thought to consider: Before BI was a multibillion-dollar apps, development and database market with analytic packages and fancy dashboards, the spreadsheet was the de facto BI app. People know and love their spreadsheets.
Previous Post: A Fistfight in the Cloud: Can't We All Just Get Along?Next Post: What Is Business Intelligence?
Most Discussed Posts
Cloud computing has emerged as one of the most significant game changers to hit the technology landscape in the past 20 years. With this massive expansion of the cloud, the perception of the IT organization is shifting from a utility player to a change agent. This eBook breaks down five ways progressive organizations are using cloud-based IT Management solutions to help drive innovation and become more strategic, including: adding visibility and analytics, speeding up time-to-value, lowering costs, improving prioritization, and providing a blueprint for future cloud deployments.
Read the white paper to see how IBM helped Citigroup deliver new services and enhancements to their 200 million customers faster.
There are 3 ways to modernize legacy applications: rewrite completely, acquire packaged solutions or migrate existing code. This paper explains why it's best to migrate and how IBM® Rational® software can help.
Accommodating specific lines of business can result in a hybrid ecosystem of applications and servers. The resulting complexity of this architecture makes for an environment that is costly to maintain and difficult to change when addressing new challenges.
This whitepaper will help you to define a mobile device passcode policy. Security managers must attempt to reconcile two opposing goals. They must: 1) create a passcode policy that is strong enough to protect the device if it is lost or stolen, while: 2) not annoying users with needless length or complexity.
This whitepaper, authored by The Radicati Group, looks at the key reasons organizations should consider moving to a cloud-based archiving solution. Email archiving solutions enable organizations to store, monitor, and collect electronic data exchanged by their users to comply with internal policies and regulations.
ATERNITY will showcase a 30-minute demo on how Fortune 500 companies are leveraging its award-winning FPI Platform to deliver a user-centric approach to Proactive IT Management.
For businesses to move forward and tap into the ever-expanding universe of Internet users and network-enabled devices, it's critical to learn how to make the transition to IPv6. Learn the critical steps your organization must take to make a seamless transition-and keep your business world connected.
Learn how IT teams can protect against spear phishing tactics. Harry Sverdlove, chief technology officer of Bit9 offers a frank discussion about spear phishing - the most common technique used in today's advanced attacks.
Learn how to build a solid business case for your migration to Red Hat Enterprise Linux so you can run leaner, innovate faster, be more flexible and own the New Now.
Social media isn't about you; it's about everything around you. As you consider how your customers want to communicate with you, social media is something that can't be ignored. But what should your strategy be? Is social media "just another channel?" What kind of a plan makes sense for your contact center and for your customers? Join our experts as they share their insight and research results.
Hardware tokens were a popular method of strong authentication in past years but the cumbersome provisioning and distribution tasks, high support requirements and replacement costs have limited their growth. The additional log-in steps that hardware tokens require and the resulting user frustrations have limited adoption and make them impractical for larger scale partner and customer applications.
Sponsored Links
