The Opportunity

Photogenic, a photography service provider division of Cherry Hills Programs, Inc. that operates in 60+ attractions and venues across the United States and Canada, was looking for ways to streamline and consolidate data reporting for attendance, sales, and financial performance in the field.

After discussing their current process with stakeholders, reviewing pain points, and looking for opportunities for improving their reporting workflow and capabilities Bitprism crafted a custom software solution tailored to their process and needs and transformed a process that was previously entirely manually managed via spreadsheets, Access databases and emails to a streamlined set of web applications.

How we helped

We started by looking at the existing data and data collection, which was entirely managed via numerous Excel and Access files of varying complexity. From there we turned to the stakeholders to examine pain points, opportunities for improvement, and desired features that would take hold in the new paradigm. Collaboratively with the client, we formed the requirements for the new process, for the applications and solidified the plan for the architecture.

The new process included a field reporting application and a back-office application for long-term archival and analytics. The field reporting application would allow field staff to create detailed daily reports based on the venue's specificity and needs, which then would go through a review and approval process before being able to be finally processed. The applications would also integrate and provide data flows to and from payment and cash processors, ERPs, and third-party data warehousing BI solutions.

Business Outcome

The solution revitalized and streamlined the process of collecting and reporting sales data in the field across all venues managed by Photogenic. It also ultimately automated and brought cost savings in other areas, including analytics and accounting.