Case Study: The Swiss Colony

Harnessing Web Data for Business Intelligence with Pentaho's BI Suite

Overview
The Swiss Colony, one of the largest and most successful catalog companies, experienced tremendous growth in its e-commerce sector and turned to OpenBI and Pentaho for help in harnessing and integrating the vast amount of web and other customer data for BI use.

The Challenge
As e-commerce grew, a new series of analytical requirements emerged for The Swiss Colony. They needed a better way to integrate Web data with other customer data, and to perform analysis and produce actionable analytics data.

The Approach
After developing an extraction, transformation, and load application using Perl to parse Web logs, The Swiss Colony deployed Pentaho's BI Suite Enterprise Edition and Data Integration module to provide comprehensive reporting, OLAP analysis, dashboards, data integration, data mining, and a BI platform. The Swiss Colony partnered with the Pentaho experts at OpenBI for the implementation.

The Results
OpenBI was able to customize the product and successfully deploy Pentaho's BI Suite, giving The Swiss Colony a system that provided greater flexibility and more comprehensive data integration.

Benefits:

• The Swiss Colony integrated nearly 400 GB of data from its 12 e-commerce Web sites with the 1+ TB corporate data warehouse.
• The system provided flexible reporting with ability for users to generate their own reports.
• The system allows for the option for customizable use of additional Pentaho modules in the future.
• OpenBI and Pentaho provided responsive, fast and ongoing customer support.