Dell Eyes $50 Million Savings On BI, Analytics - InformationWeek
Data Management // Big Data Analytics
11:00 AM
Connect Directly
How Upwork Cut Zero-Day File Attacks by 70%
Oct 05, 2017
Upwork has millions of clients and freelancers that have to upload and download many files to and ...Read More>>

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

1 of 2
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
User Rank: Ninja
6/16/2014 | 2:58:07 PM
Re: IT spend Vs. business-unit spend on BI, analytics
This just sounds like another example of a company consolidating technology internally to wring out more efficiencies. I wonder if the move to Dell being a private company will result in technological innovation inside of the company - and as a result products its enterprise customers will clamor over. 
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?
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Digital Transformation Myths & Truths
Transformation is on every IT organization's to-do list, but effectively transforming IT means a major shift in technology as well as business models and culture. In this IT Trend Report, we examine some of the misconceptions of digital transformation and look at steps you can take to succeed technically and culturally.
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll