Pro+ Content/BI Trends + Strategies

Thank you for joining!
Access your Pro+ Content below.
Issue 6, June 2012

Riding herd on Excel BI use isn't easy, but it's necessary

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...

Access this Pro+ Content for Free!

By submitting you agree to recieve email from TechTarget and its partners. If you reside outside of the United States you consent to having your personal data transferred and processed in the United States. Privacy Policy

Features in this issue

News in this issue

SearchDataManagement

SearchAWS

SearchContentManagement

SearchCRM

SearchOracle

SearchSAP

SearchSQLServer

-ADS BY GOOGLE

Close