Language Flags

Translation Disclaimer

HPCwire Enterprise Tech HPCwire Japan

June 04, 2012

The Endangered Spreadsheet Culture

An increasing number of businesses are looking to big data visualization tools to spot and further analyze business trends, but for some, the move away from the spreadsheet behind the gatekeeper’s watch hasn’t been smooth transition.

Nearly all of the visualization tools that have emerged (and evolved) over the last few years have emphasized a “power to the user” approach. The goal is to enable departmental executives to create their own simple to understand visual reports on complex data sets using intuitive BI interfaces, removing the middleman and eliminating what’s been the steady culture of the mighty spreadsheet.

According to Ron Van Zanten, vice president of data quality at Great Western Bank, despite the wide range of visualization tools available to data-driven companies, there is a reluctance to shift from raw data to a more fluid representation of that information.

As Van Zanten stated, “The adjustment to data visualization tools has been a difficult one, both operationally and culturally. Business users trust their spreadsheets and don’t want to give them up.”

Van Zanten told us today that access (and resistance to) discoveries via big data visualization is causing a big shakeup within an industry like his that has changing data requirements but a slow-to-adopt culture, even if the benefits of such a transition are clear.

As he stated:

“At Great Western Bank, it’s been an adjustment for us to having a centralized data store. Every group in the bank has had an information silo at one level or another. In finance, they have been masters as bringing totals from GL and manipulating it in Excel and creating new insights. These tiny analytics systems contain many spreadsheets with Vlookups. This happens in the branches as well, the creation of B-day lists, follow-up lists, the power and flexibility of Excel gives the users the feeling of control and trust. They can see the data and are very willing to manually validate numbers.”

Van Zanten claims that developing a system that centralizes disparate systems, and provides a tool that allows for the manipulation of larger data sets represents a significant cultural change.

He notes that for example, “users still would like to access the DW via Excel, which since we are based on the Microsoft BI stack is tolerated. Even though we have a better self-service tool (MS PowerPivot) that allows for data interaction.”

In Van Zanten’s view, people no longer are the stewards of small silos of information. “Before incentives was synonymous to a particular expert….Access to data is more universal. And that has been unsettling to certain persons who build cottage industries based on certain accesses.”

While visualization companies, including Tableau, are aiming to change this culture by emphasizing the ease of use and sense that anyone can become a data scientist with enough data, this could be an uphill battle for the spreadsheet culture.

Outside of visualization-specific companies, nearly all business analytics platform vendors are implementing an ease-of-use optimized set of tools for heavy-duty data visualization. These tools  remove the silo and put the power in the hands of the users and endanger that spreadsheet culture Van Zanten references ---bad news for the IT professionals and business ecosystems that have thrived off limited access and usability of data.

Related Stories

Snapshots from the Edge of Big Visualization

How 8 Small Companies are Retooling Big Data

GPUs Tackle Massive Data of the Hive Mind

Share Options


» Subscribe to our weekly e-newsletter


There are 0 discussion items posted.


Most Read Features

Most Read News

Most Read This Just In

Cray Supercomputer

Sponsored Whitepapers

Planning Your Dashboard Project

02/01/2014 | iDashboards

Achieve your dashboard initiative goals by paving a path for success. A strategic plan helps you focus on the right key performance indicators and ensures your dashboards are effective. Learn how your organization can excel by planning out your dashboard project with our proven step-by-step process. This informational whitepaper will outline the benefits of well-thought dashboards, simplify the dashboard planning process, help avoid implementation challenges, and assist in a establishing a post deployment strategy.

Download this Whitepaper...

Slicing the Big Data Analytics Stack

11/26/2013 | HP, Mellanox, Revolution Analytics, SAS, Teradata

This special report provides an in-depth view into a series of technical tools and capabilities that are powering the next generation of big data analytics. Used properly, these tools provide increased insight, the possibility for new discoveries, and the ability to make quantitative decisions based on actual operational intelligence.

Download this Whitepaper...

View the White Paper Library

Sponsored Multimedia

Webinar: Powering Research with Knowledge Discovery & Data Mining (KDD)

Watch this webinar and learn how to develop “future-proof” advanced computing/storage technology solutions to easily manage large, shared compute resources and very large volumes of data. Focus on the research and the application results, not system and data management.

View Multimedia

Video: Using Eureqa to Uncover Mathematical Patterns Hidden in Your Data

Eureqa is like having an army of scientists working to unravel the fundamental equations hidden deep within your data. Eureqa’s algorithms identify what’s important and what’s not, enabling you to model, predict, and optimize what you care about like never before. Watch the video and learn how Eureqa can help you discover the hidden equations in your data.

View Multimedia

More Multimedia


Job Bank

Datanami Conferences Ad

Featured Events

May 5-11, 2014
Big Data Week Atlanta
Atlanta, GA
United States

May 29-30, 2014
St. Louis, MO
United States

June 10-12, 2014
Big Data Expo
New York, NY
United States

June 18-18, 2014
Women in Advanced Computing Summit (WiAC ’14)
Philadelphia, PA
United States

June 22-26, 2014

» View/Search Events

» Post an Event