Customer: Spreadshirt

""Pentaho enables us to keep an eye on our entire business. The self-service aspect allows our employees to measure the effectiveness of marketing campaigns, identify trends and create capacity and product forecasts. Our developers are freed up to focus on core development""

Deployment Overview

Key Challenges

• End-to-end analytics solution: Spreadshirt needed a fully functional analytics system that would fit into Spreadshirt’s open source IT landscape
• Real-time analysis and self-service BI: the fast-moving internet business needed a tool that could support real-time, ad-hoc analysis for the business users and ease the burden on IT
• Integration, scalability and performance: the data generated from different systems in the warehouse required an ETL tool that could cope with many different types and high volume

Pentaho Solution

• Pentaho software runs on a Glassfish Application Server with MySQL database and Ubuntu Operating System
• Pentaho Business Analytics as self-service BI delivering ad-hoc analysis and reporting in real time.
• Pentaho Data Integration as ETL tool

Results

• Huge data volume and high performance: The data generated from the platform includes 6.5 million global orders amounting to about 250 GB. Query performance has improved significantly during the 2.5 years Pentaho has been in production during a time of high data volume growth.
• Partner management: sales uses Pentaho to help retail partners optimize store layouts, improve promotions and increase sales.
• Product optimization: product managers use Pentaho to improve existing products and to plan the introduction of new products.
• Marketing campaigns and promotions: marketing uses Pentaho to analyze the effectiveness of its campaigns and promotions.
• Reporting and operational BI: the financial team uses Pentaho to reveal trends and develop forecasts for production control and capacity planning.

Why Pentaho

• Open source: low total cost of ownership, highly scalable and easy to integrate
• Complete end-to-end solution
• Self-service BI and ad-hoc analysis in real-time