Case Study: The Swiss Colony


The Swiss Colony, one of the largest and most successful catalog companies, experienced tremendous growth in its e-commerce sector and turned to Inquidia 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 Inquidia for the implementation.

The Results

Inquidia 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.


  • 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.
  • Inquidia and Pentaho provided responsive, fast and ongoing customer support.

Contact us today to find out how Inquidia can show you how to collect, integrate and enrich your data. We do data. You can, too.

Would you like to know more?

Sign up for our fascinating (albeit infrequent) emails. Get the latest news, tips, tricks and other cool info from Inquidia.