Dell Eyes $50 Million Savings On BI, Analytics - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Data Management // Big Data Analytics
11:00 AM
Connect Directly

Dell Eyes $50 Million Savings On BI, Analytics

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?'"

[Want the latest on BI and big data staffing? Read 2014 US IT Salary Survey: BI & Analytics.]

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 site navigation experience and reduce unnecessary support calls.
Machine learning analysis has helped optimize the 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

Next Page

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

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 2
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
D. Henschen
D. Henschen,
User Rank: Author
6/16/2014 | 1:56:17 PM
IT spend Vs. business-unit spend on BI, analytics
The level of IT spending vs. business-unit spending on BI and analytics revealed within Dell is telling. Do you think your organization would be surprised to learn that business spending it outstripping (and in many cases unnecessarily duplicating) what IT spends to support BI reporting and predictive analysis? Sprawling data marts are just one example of duplicative spending. Dell figures it's going to save on database licenses, BI licenses, and analytics licenses by centralizing. Instead of each business unit creating its own data fiefdom, they're learning to play nice and exploit what Schmidt says are better capabilities on shared platforms.

Would this approach make sense at your organization? Are the savings oversold?
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll