PRO+ Premium 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 your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Features in this issue

News in this issue