Data Integration
& Storage

Business Intelligence begins and ends with data. PROGNOZ understands that the quality of your output is dependent upon the quality of your inputs. Simply put: garbage in, garbage out. A carefully considered data strategy involves integrating your existing data without redundancy or error.

	PROGNOZ Data Warehouse The PROGNOZ data warehouse allows teh user to have complete control to create and manipulate data cubes.
	Master Data Management Items Drill down into data dictionaries, in order to view and modify data series and data points.
	Edit Dictionary Properties Edit dictionary properties and maintain data integrity.

Designing of Multidimensional Data Warehouses

Create data warehouses using either a top down or bottom up approach. Essentially this flexibility allows both our developers and our clients to begin or end with either the physical or the logical model. This provides tremendous benefits, in terms of understanding the data, client expectations, in addition to the associated benefits to cost and speed to market.

Data Integration

Data extraction, transformation and loading, via the PROGNOZ ETL toolkit, enables each and every client to leverage the full PROGNOZ 5 platform without disturbing existing infrastructure and supports nearly all data and file formats including: ODBC or OLE DB-compatible DBMS (Oracle, Microsoft SQL Server, Informix, etc.) on the data side, in addition to XML, EDIFACT, DBF, TXT, XLS, etc. on the file side. PROGNOZ also supports all multi-dimensional data warehouses, which adhere to OLE DB or OLAP specifications.

Reference Data Management

Once again, PROGNOZ utilizes either a top down or bottom up approach, when creating the reference data structure. It is critical at this stage to seamlessly integrate disparate databases into a unified repository, in order to guarantee data integrity. The PROGNOZ approach is uniquely equipped to deliver just that by maintaining hierarchical and parameterized dictionaries (including time dependencies), supporting an unlimited number of dictionary attributes, in addition to various data types and relations between dictionaries.

Metadata Management

The very descriptive elements associated with your data have the ability to wreak havoc down-stream with analysis, forecasting and ultimately the reports used to make important business decisions. Metadata management begins with integrating each and every descriptive element into a single unified structure. This process prevents missing characters, redundancy and ensures that the appropriate associations are in place for each and every data item. Further, PROGNOZ Metadata Management is built with the user in mind and may be changed over time to suit your changing business needs.