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 Earls
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 Earls
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
Building effective analytical models is a key facet of big data analytics applications -- though doing so is easier said than done.
This e-book ...
Predictive analytics employs statistical or machine-learning models to discover patterns and relationships in data, thereby enabling the prediction ...
Sensors capture large volumes of data about the operations of industrial equipment; similarly, log files gather huge amounts of information about ...