National Memorial Maintains Operational Excellence

Case Study

Challenge: Assess and track daily operations including visitor reservations, e-commerce, admissions screening, and site capacity management.

Solution: Pentaho delivers an end-to-end platform that includes data integration and analysis, and reporting capabilities.

Outcomes

  • Maximizes revenues by providing visibility into all systems and data.
  • Improves all aspects of daily operations, including compliance.
  • Provides on-demand reporting through streamlined processes.
  • Enables employees and management to maintain operational excellence.

The National 9/11 Memorial & Museum, located in New York City, commemorates the 1993 and 2001 terrorist attacks.

The Challenge: Assess and Track Daily Operations

Before the 9/11 Memorial opened in September 2011, CTO Sean Anderson was tasked with finding a business analytics solution to assess and track specific aspects of the memorial’s daily operations, including free visitor pass reservations, e-commerce and admissions screening.

The National 9/11 Memorial & Museum

The National 9/11 Memorial & Museum

INDUSTRY

Not-For-Profit

The organization needed a business tool to create reports and provide in-depth analysis and visualization. For this nonprofit organization, cost was also an important factor in selecting a business analytics tool.

Pentaho Services understood how best for us to help improve aspects of our operations.
– Sean Anderson, Chief Technical Officer, National 9/11 Memorial & Museum

The Solution: End-to-End Data Integration and Business Analytics Platform

Pentaho Business Analytics was selected because it met the Memorial's requirements. They had been looking for an end-to-end business analytics platform that included data integration to facilitate Extract, Transform, Load (ETL) from systems including retail, e-commerce, visitor pass reservation and admissions screening into a data warehouse. The organization also sought analysis and reporting capabilities.

Pentaho connects to a data warehouse using MySQL to process ETL nightly and populate data into internal reports. The system is installed on a virtual server that runs the Linux operating system.

The Outcome: Maximize Revenues and Maintain Operational Excellence

Maximize revenues – Pentaho automatically loads data overnight from operations into the data warehouse to generate daily operations reports. With this insight, the organization can better manage daily operations, such as security allocation and museum ticketing.

Maintain compliance – The Memorial has deployed Pentaho alerts to automatically inform security personnel whenever the crowd starts to reach maximum capacity. This ensures that the Memorial is always in compliance since it accommodates up to 1,500 visitors at any time.

Power online merchandise sales – Supporters and visitors are now able to make purchases of keepsakes and mementos online, at the 9/11 Memorial preview site or at the 9/11 Memorial visitor center.

Achieve management buy-in – Management has become more reliant on data analysis and is asking for Pentaho to do even more.

Rely on professional services – Pentaho consultants came on site to help deploy the initial solution in just a few days, and the analytics team has also participated in both onsite and online training from Pentaho.

Accomplish operational excellence – Pentaho streamlined the two- or three-day task of piecing together the operations report; the report is now created automatically, available at the click of a mouse, and easily viewed on one screen.

EXPLORE MORE

Big Data Integration and Analytics

Access, blend and analyze all types of data, visualize data across multiple dimensions, and embed analytics into existing applications.

You’re in the Right Place!

Hitachi Data Systems, Pentaho and Hitachi Insight Group have merged into one company: Hitachi Vantara.

The result? More data-driven solutions and innovation from the partner you can trust.