Gartner warns of data warehouse user mutiny

LAS VEGAS – The relationship between IT and the business is changing says a Gartner analyst, and if IT doesn’t let the business work how it wants the workers will only take matters into their own hands.

Driving innovation through effective service management

A service-oriented governance framework can help ensure that IT decisions are consistent with business vision, values and strategies—and that IT delivers maximum value to the business. Download this white paper to learn how. Complimentary with registration.

Speaking at Partners, the annual user conference of data warehousing vendor Teradata, Donald Feinberg said companies are going to have to start paying closer attention to their data warehouses. Feinberg, a vice-president and distinguished analyst with the research firm, said if your data warehouse is more than 10 years old it’s going to need to be replaced to be able do the things people are now expecting them to be able to do.

Even clients with data warehouses just five years ago are telling him they’re not working anymore, said Feinberg. They can no longer handle the loads and do the job needed. It’s a matter of changing expectations, said Feinberg, and what the systems were originally designed to do.

“We just didn’t know 10 years ago what we’d be doing with data warehouses today,” said Feinberg. “We barely even called them data warehouses then.”

We also weren’t talking about terms such as high availability, 24 by 7 or mission critical disaster recovery in relation to data warehouses either, said Feinberg. But that has changed. By the close of 2009, he said, 90 per cent of Global 2000 companies will have at least one mission critical business application reliant on the data warehouse. And that, in turn, makes the data warehouse itself mission critical.

“The bottom line is data warehouses are mission critical, it’s that simple,” said Feinberg, “If you don’t build them as integrated mission critical systems they will become a point of failure.”

And while the mission of re-architecting and rebuilding the data warehouse will inevitably fall to IT, Feinberg said it needs to be a business-led initiative. Consulting with the business just won’t be enough.

“Talking doesn’t do anything,” said Feinberg. “You need to work with business, and business needs to run the project if it’s going to be successful.”

That’s because the game has changed. There was a time IT could give any old program to the business side and they’d have to use it, but not anymore. Noting Excel 2007 allows one million rows, he said people can get by without a database, and can even run SAS analytics against Excel spreadsheets.

“Bottom line, if you don’t do it correctly and with them they’re going to do it themselves,” said Feinberg. “Everything must now be designed around the worker.”

It’s a trend he only sees becoming more true. In five years the average person working on the business side will have grown-up in the information age, working with technology all their lives. They’ll be more tech savvy than ever before.

“Do you think you’re going to be able to tell someone like that use this program to do your job?” asked Feinberg. “It doesn’t work that way, because if they don’t like it they’re going to find some other way to do it on their own.”

Instead, he says in the future IT will need to create services based on business processes. The worker’s job will be to get from point A to point B, IT will provide a menu of services, and the worker will decide themselves how to get there.

“This makes it look like the industrial revolution never happened,” said Feinberg.

The revolution is already happening at The Hershey Company, where the chocolate business is more complicated than may first be thought. Hershey runs an SAP advance planning solution on top of a Teradata data warehouse and Herb Hockley, Hershey’s manager of customer planning, says the candy company’s road to demand planning has been particularly challenging. The company goes to market through many different channels, making planning difficult. The situation is complicated by chocolate being an impulse buy; it needs to catch the eye in the checkout aisle so marketing is key.

“We need to have new and exciting things happening with our products such as a new item, a seasonal item or a special promotional item available for a limited time,” said Hockley. “It does create complexity for us, and creates challenges from a planning perspective.”

With SAP, Teradata and a reporting solution from Ottawa-based Cognos, Hockley reports Hershey has been able to implement a demand planning solution that pulls in relevant data from across the business to accurately produce an operational forecast to drive manufacturing, marketing and financial projections.

Would you recommend this article?


Thanks for taking the time to let us know what you think of this article!
We'd love to hear your opinion about this or any other story you read in our publication.

Jim Love, Chief Content Officer, IT World Canada

Featured Download

Jeff Jedras
Jeff Jedras
As an assistant editor at IT World Canada, Jeff Jedras contributes primarily to CDN and, covering the reseller channel and the small and medium-sized business space.

Related Tech News

Tech Jobs

Our experienced team of journalists and bloggers bring you engaging in-depth interviews, videos and content targeted to IT professionals and line-of-business executives.

Tech Companies Hiring Right Now