Dell standardizes data platforms and business intelligence tools to improve self-service, expand use of predictive analytics.
Sometimes less is more. Dell is counting on this formula in a business intelligence and analytics makeover aimed at reducing spending on redundant technology by consolidating data platforms and standardizing on BI tools while giving business users more options for self-service and deep analytics.
Dell's BI plan was hatched two years ago, long before the $57-billion-plus annual-revenue hardware giant went private. The company assessed its IT and business intelligence capabilities and agility by surveying more than 130 business executives, and it didn't like what it saw. IT was spending some $50 million annually on data warehousing, business intelligence, and analytics. But Dell learned that business units were spending another $70 million, collectively, on independent data-management, BI, and analytics initiatives.
"When we looked at that $70 million BI spend in the business, 70% of it -- or about $50 million -- was spent taking data out of the IT environment and putting it back together in their own databases and customer-support systems," said Rob Schmidt, Dell's executive director for IT, analytics, and business intelligence. "We looked at that and asked, 'how can we reduce that big, $70 million chunk?'"
The answer was to build a developer-friendly architecture around centralized resources including the company's 200-plus-terabyte Teradata enterprise data warehouse (EDW) and centralized SAS analytics environment. The idea was to give the business better access to data, more development and analysis capabilities, and more autonomy on an IT-provisioned, centralized framework.
Work got underway 18 months ago on a three-tier architecture that lets business units (each of which has its own DBAs and BI developers) access data and add and drop tables as it sees fit.
Machine learning analysis has helped optimize the Dell.com site navigation experience and reduce unnecessary support calls.
"We're moving to a platform where the business develops its own applications, but they migrate them up into our second tier, where we automate and put processes around the applications," Schmidt explains. "The third tier is our production data warehouse, which the business can't touch."
The technologies in use haven't changed dramatically through the initiative. Teradata and SAS were already in use, as were MicroStrategy and Tableau Software, Dell's standardized choices for production reporting and ad-hoc data exploration, respectively. The real challenge was process change, as business units signing on to take part would no longer be able to extract data and go their own way.
"We're teaching and certifying each business unit to develop against our data platforms," said Schmidt. "And there's a formal agreement between myself and a VP in each business that lays out what you can and can't do on the platform."
"Thou shalt not" rules include limits on extracting data from the data warehouse and writing queries against certain tables that will bring the database to its knees. Schmidt said the certified DBAs and developers within each business unit know he'll "take away access in a heartbeat" if something starts to impact the production environment.
In exchange for giving up their silos, the business units get access to more data and better capabilities than they ever had in their independent reporting and analytical environments, according to Schmidt. New capabilities include a Hadoop cluster for high-scale, low-cost storage and a Teradata Aster
Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio
6 Tools to Protect Big DataMost IT teams have their conventional databases covered in terms of security and business continuity. But as we enter the era of big data, Hadoop, and NoSQL, protection schemes need to evolve. In fact, big data could drive the next big security strategy shift.
Big Data Brings Big Security ProblemsWhy should big data be more difficult to secure? In a word, variety. But the business won’t wait to use it to predict customer behavior, find correlations across disparate data sources, predict fraud or financial risk, and more.