Data Warehouse & Business Intelligence

A data warehouse allows users to see statistics about important business data (such as markets, customers, costs, ...) in a simple and intuitive way. A DW is similar to a collection of reports, but allows in addition to "play" with the data interactively, modifying the axis of the reports in real-time etc.

]project-open[ offers Data Warehouse implementations based on open-source (Mondrian) and commercial OLAP (MS-SQL-Server) servers.

Available Cubes

Translation Invoicing

This cube takes invoiced translation projects and allows you to browse the information according to:

• Source Language
• Target Language
• Quality level
• Customer (country, customer type)
• Time (year, quarter, month, week, day)

Translation Quality

Allows you to analyze the quality of translators and editors according to:

• Translator/Editor
• Time (year, quarter, month, week, day)
• Translation/Editing rate

This Cube is only available together with the Translation Quality Extension.

Hour Dedication

Allows you to analyze logged hour dedications according to:

• User
• Project (project, subprojects, project tasks)
• Cost Type (project phase, cost type)

Projects Profit & Loss

Allows you to browse project management information. The cube shows profit & loss on a per-project base, incorporating information from costs, hour dedication and invoicing according to:

• Project
• Time (year, quarter, month, week, day)
• Project Type

Available Implementations

The data warehouse functionality is currently available in three variants:

Data Warehouse "Light"

This implementation is available free of charge as part of the base ]project-open[ product series. The DW functionality is implemented using Microsoft Excel and its "Pivot Table" functionality. There are no limitations in terms of functionality etc. However, the size of the Cubes is limited to 65.000 records due to limitations of Microsoft Excel.

Data Warehouse "Mondrian"

This module is suitable for small and medium companies. The implementation is based on the open-source Mondrian OLAP server, the JPivot reporting client and the OpenI solution. This implementation provides the full DW functionality, but is limited to the data handling capacity of the Mondrian server.

We are offering this option together with Loyalty Matrix. Please contact us for implementation details.

Data Warehouse "SQL-Server"

This implementation is based on the Microsoft SQL-Server OLAP server and the Microsoft MDAC or Excel Pivot Table reporting clients. functionality. SQL-Server is known to be able to deal with large sized DW Cubes.

Please contact us for implementation details.

Loyalty Matrix Business Intelligence

Loyalty Matrix and ]project-open[ together are offering a Business Intelligence solution with a special focus on customer value and behavior. This solution includes tailored MatrixOptimizer® analytical models for ]project-open[.

Please contact us or contact Loyalty Matrix for more information. Analytical models for other business sectors are available on request.

About Loyalty Matrix

Loyalty Matrix helps companies transform customer data into insights and marketing recommendations. We combine a professional services practice with an on-demand product that allows clients to view and explore their data through an on-demand, ASP portal. We've built our business on a foundation of engagements with more than 25 Fortune 1000 clients in the areas of retail, hospitality, subscription services, and member-based programs. We're
currently working with direct clients like Apple Computer, 24 Hour Fitness (worldwide fitness chain), and Dave & Busters (US restaurant chain) as well as partners who are leaders in the advertising, direct marketing, email marketing, and call center space.

Loyalty Matrix' flagship product, the MatrixOptimizer(r), is based on an open source platform that dramatically lowers the cost of deployment for a powerful, flexible business intelligence platform. We have integrated best-of-breed open source technologies that include: database, statistics/data mining, OLAP, and data visualization. On top of this open source platform, Loyalty Matrix has developed proprietary components that include: (1) a customer-centric data schema, (2) Analytical models, metrics, and algorithms, and (3) a Marketing Action Map that guides the selection of the most appropriate marketing programs for a specific situation.