Data Prep

ADVIZOR makes working with data easy, like no other tool anywhere near its price range!

The reality is...

Most companies have data scattered in a variety of places in a variety of formats, making it virtually impossible to get quick answers to the kinds of complex questions that will drive competitive advantage.

Up to now business intelligence solutions have fallen into two categories: (1) heavy-duty back-end data crunchers and processors and (2) front-end visualization and charting tools.  The back-end solutions are typically expensive, require an IT team to manage, sit behind a traditional reporting platform like IBM Cognos or SAP and, frankly, can be overkill for small to medium-sized businesses.  The front-end data visualization and charting tools are a cheaper and faster implementation, but only IF your data is highly formatted or in a nice, tidy data warehouse.  Without the resources of time, money, and talent to invest in a big data warehouse and reporting project, the majority of companies are leaving important and strategic information hidden, untapped and buried in IT land.

What makes ADVIZOR different from other tools on the market?

ADVIZOR fills the gap between traditional, full-stack tools that are expensive and cumbersome, and the modern visualization and charting tools that are business user friendly but lack the powerful technology on the back-end to handle large, complex data sets residing in multiple, disparate data systems.  

The ADVIZOR Data Blender

The ADVIZOR Data Blender provides an easy to use visual interface to merge, sort, transform, and append data from diverse formats that may originate from a variety of sources and systems. The Data Blender creates a repeatable process without the need for complex coding or programming. It enables you to:

The Data Blender is designed for “heavy duty data blending and prep” in front of the other ADVIZOR products.

In-Memory Data Synthesis

ADVIZOR data discovery projects typically load anywhere from 1 table, to over 150 tables, into memory. Those tables can be mixed and merged from a variety of sources, including the Data Blender. Once in memory ADVIZOR provides a series of data prep and synthesis tools so that raw data can be quickly and easily transformed for business analysis and decision making, without requiring changes to the source system data tables. This provides for a truly flexible “analytical sandbox” environment. ADVIZOR In-memory data synthesis includes the following capabilities: data can be quickly and easily transformed for business analysis and decision making, without requiring changes to the source system data tables. This provides for a truly flexible “analytical sandbox” environment. ADVIZOR In-memory data synthesis includes the following capabilities:

 

The ADVIZOR Data Blender Supports the following data sources:

 

Plus Odata with standard out of the box 3rd party drivers
Plus EBCDIC and Comp-3 encoding
Plus any ODBC compliant database (Greenplum, Pervasive, etc.)