Oracle Business Intelligence Foundation Suite and Endeca upgrades offer new ways for business users to integrate, visualize and analyze data.
10 Social Networks For Special Interests
(click image for larger view and for slideshow)
Structured or unstructured, big or small, data needs to be analyzed to be of use to a business. Oracle on Monday announced that the latest releases of its Business Intelligence Foundation Suite and Endeca Information Discovery server give untrained business users more self-service analysis options extending to unstructured information and big data.
Oracle BI Foundation Suite 18.104.22.168 is the company's first major business intelligence (BI) software upgrade in 10 months, and it packs a long list of new features. Oracle continues to expand its data visualization repertoire, as it did in June 2012 by introducing trellis charts. With the latest release those trellis charts can spin off spark lines and spark charts, and other new visualizations include performance tiles -- a type of key performance indicator -- and waterfall graphs.
With all the data visualizations now available, business users might be confused about which charting approach to use. A new View Suggestions Engine makes the choice easier by examining the data and number of dimensions being analyzed and then guiding users to the most appropriate visualization.
"The system helps the user decide whether they should use, say, a stacked bar chart, a waterfall chart or a funnel diagram based on whether they're trying to compare products, show performance over time or do some other analysis," said Paul Rodwick, Oracle's VP of product management, in an interview with InformationWeek.
To make BI Foundation Suite friendlier to Microsoft Office fans, Oracle has consolidated formerly separate add-ins for Oracle BI Enterprise Edition and Oracle Essbase, the two core components of the suite. The new, unified Smart View add-in for Office lets users bring complete BI dashboards and reports or Oracle Hyperion performance-management analyses into Microsoft Excel or PowerPoint, for example, if that is the user's preferred analysis or presentation tool.
The BI Foundation Suite has gained a new connection to Hadoop through Hive, the data warehousing interface to Hadoop clusters, to improve access to big data. Hive is widely viewed as slow and limited -- drawbacks the Hadoop community is working on -- but it's the best established option for SQL-like access to Hadoop. The Hive connector will enable companies to query clusters and analyze subsets of information without having to move large-scale data sets. This brings the world of big data together with conventional enterprise data sources and analysis capabilities.
"You're not going to put a Hadoop source under an interactive dashboard where people would expect sub-second response time, but coupled with the Oracle Exalytics appliance, you could bring an important subset of hot data into memory to make that information accessible alongside other information," Rodwick said.
All the new data visualizations and upgrades of BI Foundation Suite 22.214.171.124 inherit Oracle's support for Mobile BI, which centers on Apple iOS and, most particularly, the iPad. Android and other platforms are being considered for future releases, according to Rodwick. By downloading the hybrid Oracle BI Mobile HD app, users get instant Web-based viewing of all Oracle BI content -- dashboards, reports and so-on -- without modifications or development work. They also get native-like, touch-enabled navigation capabilities including swiping, tapping, gestures and the option to save to the device, said Rodwick.
To enhance security, the latest BI Foundation Suite adds an Oracle BI Mobile Security Toolkit that lets customers integrate the mobile device management solution of their choice; this adds another layer of security and management control to mobile delivery, according to Oracle.
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.