Data analytics pioneer Kognitio (kognitio.com) today announced the general release of version 1.0 of Pablo, Kognitio’s extension to its WX2 analytical database that allows ordinary users to perform “train of thought” analysis by building and querying virtual OLAP cubes on the fly. Pablo has been created to satisfy the market need for high performance analytics on high volumes of data, so called “extreme analytics”, and takes over from where poor performance issues mean other solutions cannot continue. The announcement was made today at Kognitio’s Pablo launch event in London’s Canary Wharf.
Pablo will ship with A La Carte, a solution that will add a host of new rich features to Microsoft Excel and allow users to adopt the widespread product as their standard Business Intelligence front-end application. With A La Carte and Pablo, Excel users will be able to create and investigate virtual OLAP cubes containing tens of Terabytes of data, thanks to the scalability, low latency and in-memory performance of the underlying Kognitio WX2 analytical database. Furthermore, Pablo will include support for XMLA, which allows other front-end BI tools such as IBM Cognos and SAP BusinessObjects to connect seamlessly to the virtual OLAP cubes.
“While powerful, the potential of OLAP cubes has always been constrained by the time, tools and expertise needed to build, populate and use them,” said Roger Llewellyn, CEO of Kognitio. “With Pablo, these constraints are eliminated: virtual cubes can be built, populated and queried on the fly, with the minimum of time before data is ready to be examined. At the same time, by allowing users to take advantage of the familiar environment of Microsoft Excel, there is no need for extensive training before organisations can take advantage of this data. While Pablo does not immediately mean the end of physical cubes, the ability to virtualise large and complex cubes is an important leap in the evolution of OLAP.”
With Pablo, organisations can discover insights from massive amounts of data in near real-time, allowing “train of thought” analysis: gaining the performance of OLAP cube databases without the costs, complexities and latency that have traditionally accompanied the technology. Possible uses across sectors include:
• Financial Services – analysing risks in vast, constantly fluctuating markets
• Retail – dynamically modifying pricing to cope with the latest trends and influences
• Manufacturing – managing supply chains for innumerable parts and resources
• Energy & Utilities – analysing consumption and pricing, particularly in the era of smart metering
• Telecommunications – optimising customer plans to ensure the maximum value for their needs
• Gaming & Hospitality – analysing player and customer behaviour to help encourage loyalty
• Logistics – analysing vehicle telemetry to ensure peak operation.
Pablo works with WX2 to create in-memory images of an organisation’s database or data warehouse. By combining these images with a metadata layer and MDX connector, ad-hoc virtual cubes can be created and queried as often as required.
“Technology doesn’t stand still, and Pablo is proof of this,” continued Roger Llewellyn. “Our aim is to provide the power of Pablo to users at all levels of an organisation in all markets, from everyday workers on Microsoft Excel to high-powered analysts on dedicated Business Intelligence tools. Regardless of your level of expertise and line of business, we believe that sophisticated, in-depth analysis can only ever be a benefit.”
Pablo is available immediately and ships with Kognitio’s WX2 analytical database, with licences available per user.
Kognitio (kognitio.com) is a long-standing innovator in the data warehousing, business intelligence and analytics markets. The company has pioneered many of the technologies now employed by state-of-the-art data warehouse/BI systems including the industry’s first in-memory analytic database, data warehouse appliance, MPP shared-nothing database, and Data warehousing as a Service (DaaS) cloud-based solution. Kognitio’s award-winning WX2 product is the industry’s fastest and most scalable analytic database, enabling firms to turn massive amounts of raw, complex data into valuable insight to solve their most urgent business problems. Its clients span many industries including market research, consumer packaged goods, retail, telecommunications, financial services, insurance, gaming, media and utilities. Kognitio is based in Bracknell, UK, with North American headquarters in Chicago and offices in New York, Raleigh, Minneapolis and other U.S. cities. More information is available on Twitter at @kognitio and on Facebook at facebook.com/kognitio