Hamburger Hamburger Hamburger
en_us

Centro Improves Decision-Making With Pentaho

Centro helps advertising agencies develop and execute comprehensive, local digital campaign solutions.

  • Challenge

    Replace spreadsheets with a complete business intelligence (BI) solution to improve insights into operations and help steer strategic decision-making.
  • Solution

    Pentaho platform delivers end-to-end BI capabilities, value-added software and services.
  • Outcome

    • Automates extraction, transformation and loading to create a data warehouse.
    • Delivers 50+ on-demand, user-prompted reports and interactive analysis views.
    • Provides greater visibility into customer, cost, and revenue trends.
    • Improves operational performance and reduces internal costs.
Customer Story Customer Story Customer Story

Challenge

Replace Spreadsheets With an End-to-End BI Solution

Centro enhances the success of advertising agencies by helping them develop and execute comprehensive local digital campaign solutions. Using its proprietary technology, Centro streamlines the complex process of buying and selling online advertising among hundreds of national and regional agencies and thousands of local online publishers.

Servicing more than 450 advertisers through their respective agencies, Centro quickly outgrew its Excel-based reporting system and sought a more complete business intelligence solution to drive better insight into operations and help steer strategic decision-making in today's challenging economic environment.

From Customer Testimonial
Customer Testimonial

Pentaho gave immediate benefit increasing efficiency, containing cost, and driving revenue.

Peter Schmidt

Director of Business Intelligence
Centro

Solution

Pentaho Data Integration and Pentaho Business Analytics

After evaluating offerings from different commercial open source BI vendors, Centro selected Pentaho for its complete end-to-end BI capabilities, functional equivalency with proprietary BI software, and the value-added software and services in Pentaho. Centro began using Pentaho Data Integration to integrate information from its custom media planning system to build a comprehensive data warehouse. The powerful, easy-to-use design environment of Pentaho Data Integration automated the extraction, transformation and loading (ETL) processes to create the data warehouse and currently updates information on a daily basis. With a solid information infrastructure in place, Centro expanded to use the capabilities of the Pentaho platform to add query and reporting functionalities, interactive analysis, and dashboard features.

Outcome

Improved Performance and Operational Efficiency, Reduced Costs

Centro is using Pentaho Data Integration and Pentaho Business Analytics to deliver over 50 on-demand, user-prompted reports and interactive analysis views across every level of the organization. Every department, from the executive team to sales managers and from finance to marketing and technology, has access to data. Pentaho gives Centro greater visibility into customer, cost, and revenue trends with the ability to conduct deeper analysis on historical data across all facets of their media service offerings. Additionally, Pentaho has improved operational performance. By creating more efficiency in the organization, the BI solution has added greater value to Centro's clients and has reduced internal costs. Pentaho is deployed on Dell servers running CentOS, Apache, the Tomcat application server and the PostgreSQL database.

Explore More

Pentaho Data Integration

Pentaho Data Integration

Data integration platform to ingest, blend, cleanse and prepare diverse data from any source in any environment without code.

Data Management and Analytics

Data Management and Analytics

Accelerate innovation and build your DataOps practice with data management products for analytics, AI and data integration.

{ "FirstName": "First Name", "LastName": "Last Name", "Email": "Business Email", "Title": "Job Title", "Company": "Company Name", "Address": "Address", "City": "City", "State":"State", "Country":"Country", "Phone": "Business Telephone", "LeadCommentsExtended": "Additional Information(optional)", "LblCustomField1": "What solution area are you wanting to discuss?", "ApplicationModern": "Application Modernization", "InfrastructureModern": "Infrastructure Modernization", "Other": "Other", "DataModern": "Data Modernization", "GlobalOption": "If you select 'Yes' below, you consent to receive commercial communications by email in relation to Hitachi Vantara's products and services.", "GlobalOptionYes": "Yes", "GlobalOptionNo": "No", "Submit": "Submit", "EmailError": "Must be valid email.", "RequiredFieldError": "This field is required." }
en