BI applications are at the leading edge of the battle between thick desktop and thin Web clients. We track the trends between thick and thin in the world of BI.
BI vendors have been courting the Web browser for the last ten years -- or is it the other way around? A Web browser can deliver BI Reports and output to any machine with an Internet connection. With just HTML formatting using tables, colors, and simple font control, the styling can still be quite a few steps ahead of what can be delivered on even most black and white laser printers. Yet those same HTML reports bypass printing (or allow printing on a few required pages), saving reams of output and speeding up access to data through text search in the browser. BI report output to the Web has seen many advances.
From the late 1980's to the early 1990's, when developing major reporting applications in Information Builders' Focus or in Oracle, it was easy to enhance the output-to-file capability. Thus, in the mid 1990's, the transition to Web output with the appropriate HTML headers and internal tags was trivial. Developers even added logos and background images with light watermark gray dates, "SEP 11TH 1996," for example, in bold across the page. At the same time, BI vendors like Crystal Reports and R&R Reportwriter were delivering charts and graphics to the Web. BI vendors then added sub-report blocks; first in the footers and headers, then embedded right on the page with the major report items. That was quickly followed by output to Excel files and then Adobe PDF -- and it was all automated.
Reports to Excel set a new standard because Excel allowed savvy users to hide columns and rows either by manually clicking with a mouse or with filters. Also the data could be easily cut and pasted into another spreadsheet table for further analysis or graphing/charting. On the high end, PDF output became popular because very high quality reports with embedded fonts and graphics could be shipped over the Web and then delivered by laptop or color inkjet output to decision-makers. The next real step up was customized reports, OLAP output and data mining views, again brought to your desktop in HTML format often as special pivot table applets or ActiveX-aided reports. More recently, Java report-writers like Actuate's new Business Intelligence Reporting Tools (BIRT) open source project are committed to the full set of HTML and Web-based output.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.