Access "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 Data warehouses must learn new tricks in Big Data era
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 reporting from Excel to a BI ... Access >>>
Premium Content for Free.
Riding herd on Excel BI use isn't easy, but it's necessary
by Alan R. Earls, Contributor
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.
- Riding herd on Excel BI use isn't easy, but it's necessary by Alan R. Earls, Contributor
Data warehouses must learn new tricks in 'big data' era
by Lou Agosta
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.”
Universities need push to develop analytical talent
by Richard Herschel
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.
- Data warehouses must learn new tricks in 'big data' era by Lou Agosta
More Premium Content Accessible For Free
Technological buzz, like that surrounding Hadoop, can easily blur the lines between software benefits and drawbacks. Hadoop clusters make it easier ...
With adoption of cloud BI services hovering at 33% for the past few years, this report examines the market trends for implementing cloud business ...
Location intelligence goes beyond finding a good restaurant. In business, location intelligence technologies can boost profits and decrease costs. ...