Access your Pro+ Content below.
Riding herd on Excel BI use isn't easy, but it's necessary
This article is part of the Issue 6, June 2012 issue of BI Trends + Strategies
Business intelligence managers once talked longingly about weaning end users off their Excel addictions to help ensure that BI data remained consistent and secure. Yeah, right: In most cases, efforts to eradicate Excel from BI processes went nowhere, forcing BI teams to shift to a strategy of accommodating rather than eliminating it. “We have fought the war for 20 years and we have lost,” said Boris Evelson, an analyst at Forrester Research Inc. in Cambridge, Mass. What BI managers need to do now, he added, is work to control and manage Excel BI use as best they can. For example, Evelson recommended that Excel be integrated with BI software that can export data to spreadsheets, enabling Excel to function more as a user interface and data presentation layer than as a data manipulation tool itself. More on mixing Excel and business intelligence Find out why consultant Rick Sherman has called Excel “the king of BI” Get tips on how to deal with data integrity issues in Excel BI applications Read about a retailer that is shifting its...
Features in this issue
Eradicating the use of Excel in business intelligence applications turned out to be a pipe dream in most organizations. Now the focus is on controlling it -- as best you can.
News in this issue
These databases, mammoth by definition, are evolving to accommodate the influx of new data types, technical innovations and increasing volumes brought on by the rise of “big data.”
A shortage of workers with analytical skills threatens to derail efforts to derive business value from “big data.” It’s time for colleges to do more on BI and analytics education.