When HP aquired Vertica, the intention has been to tap the fast-growing market for big data analytics and business intelligence. Now Vertica is gearing up for demanding business intelligence and analytic workloads.

With the latest release of the Vertica Analytics Platform, HP has focused on performance, manageability and extensibility. Vertica’s vision of Analytics Everywhere, allowing customers to leverage all of their business-critical data from various structured, semi-structured and unstructured sources.

BI and Visualization Go Hand in Hand

From a customer challenge perspective, visualization is really about getting to the size of data, all the sources of data, all the scale of things and making it manageable for individuals at a glance. For developers and data scientists, visualization strategy is to combine all data sources quickly, helping customers make more data decisions at a detailed level something that’s consumable for business users.

When HP says Vertica platform is the pillar to its big data initiatives, the statement is well supported by its clients. Bruce Yen, Director of Business Intelligence for Guess in the HP Vertica Big Data Conference video series says they have chosen Vertica on top of Oracle because when it comes to the speed at which users can run queries, data compression and disk space usage, Yen believes Vertica has been the superior solution.

For Guess, who is in fashion retailer, and others in related field, visual presentation is very important. Visual appeal has to be consistent, and it has to enhance customer experience. Business intelligence solutions like HP Vertica has given a platform for developers to enhance customer experience both online and in physical stores.

For Yammer, the leading enterprise social network used by more than 200000 companies worldwide, business intelligence is all about pulling in data from CRM platforms, data from marketing platforms and other platforms and uses it for analytics solutions.  Developers should figure out what your customers are actually doing, and don’t fantasize about it. Figure out how they are using your product, what features are working or not within your product.

Pete Fishman, Director of Analytics at Yammer said HP Vertica has provided the solid platform where data is flowing in from a number of different sources across the company within the Vertica platform for Yammer’s data analysts and scientists to work with it, acting as data architects.

Developer-Level Access

An SDK is an essential feature of a business intelligence analytic platform. In order to perform complex analysis, the data must be moved out of the database and into a data warehouse. With the SDK, programmers can have their programs probe the data directly within the database itself. Vertica has a number of expanded set of SQL analytic functions, including the abilities to execute basic geospatial queries, event-series pattern matching, event-series joins, and advanced aggregate statistical and regression algorithms.

So how does it help developers and data scientist?  Developers and data scientists are called in to crunch numbers and produce actionable results. Vertica provides the core code base to run faster subqueries, database statistics and other routine database operations.

Infinity Insurance Companies in Birmingham is using the platform for longest-running queries from the Exadata implementation of insurance data. Data scientists are using analytic store-type databases of Vertica to present actionable visualization results. Take for example, if you had a record for an insured, you might have the insured’s name, the date the policy went into effect, the date the policy next shows a payment, etc. All those attributes were written all at the same time in series to a row, which is combined into a block.