© PIXIP.NET GmbH 2002 - 2010

Extended Analysis is a combined product, which utilizes different technologies and tools to achieve its goals.

Extended Analysis goals are:

• Collecting data from various data sources
• Extract data, Transfer data and load it into new databases (ETL)
• Preparing data for the usage in a Business Intelligence environment
• Changing the data on the fly (e.g. Date and time formats, etc.)
• Pre-calculating KPIs out of measurements if needed
• Data Clearing
• Data normalization
• Feeding the built-in Data Warehouse

Using Extended Analysis and the built-in Data Warehouse ensures highest performance in Reporting and Monitoring, especially when dealing with huge amount of data and large operational databases.

Although Extended Analysis is an optional and additional product in EMQP, there are many reasons to use it:

• Integrated ETL Tool
• Billing Data Integration
• SS7 Trace Integration
• Further Integrations using XML, SQL, ASCII, Syslog, SNMP, CORBA
• Ready to use DWH
• Data correlation between different data sources
• Highest performance for long term Reporting
• Disburdening operational databases by using analytical databases for reporting
• Improving reporting capabilities (trend tracking, data mining, etc.)
• Data security
• Slimming the data storage by pre-calculating KPIs
• etc.