Valore Voices

Data

Harkins Theatres

Enterprise Data Warehouse & Reporting

Seamless integration of large amounts of revenue data from 34 movie theatres– enabling real-time data driven decision making at the 5th largest movie theatre chain in North America.

Data

Harkins Theatres

Enterprise Data Warehouse & Reporting

Seamless integration of large amounts of revenue data from 34 movie theatres– enabling real-time data driven decision making at the 5th largest movie theatre chain in North America.

Challenge

Harkins Theatres was looking for an efficient way to analyze revenue across their various movie theatres. With separate databases at each movie theatre, a centralized view into all sales, and the ability to segment the data and drill down as needed, was near impossible. Harkins needed a custom, well-designed data warehouse to provide a single source of truth for data-driven decision making.

Due to the large amounts of data generated from concession sales and customer transactions, data organization and retention was less than optimal. Historical data issues hampered long-term analysis/reporting. Management wanted reporting capabilities taken to the next level with regard to providing value to the business.

Solution

Valore Partners implemented a solution in a single environment and centralized all of Harkins’ data in the cloud. The entire ETL process and analysis/reporting services were developed and deployed in the Azure Cloud environment. To achieve a seamless synchronization of the data from the back offices into the Azure Cloud managed instance, a transactional replication was implemented.

By designing a custom data warehouse, we were able to eliminate the dependence on summarized data, and enabled analysis at the deepest levels. The warehouse was also able to store older data, so that historical data could be extracted and analyzed.

Prior to this solution, Harkins’ analytics team primarily used Microsoft Excel and Tableau for reporting. Comparing the cost of a Tableau license to a Microsoft Power BI license, along with the extra features in Power BI, the management decided to make the switch to the Power BI Platform.

Outcome

  • Full View of Revenue: Centralizing the data provided Harkins with a view into all revenue, enabling deep analysis of all sales including older data
  • Avoided Additional Costs: Migrating all the data to the Cloud eliminated the need for additional hardware/software or system maintenance
  • Reduced Costs, BI Software: By switching from Tableau to Power BI, Harkins was able to save tens of thousands of dollars each year. Furthermore, since the analytics team was already well-versed in Excel, ramp up to Power BI was quick and easy due to similarities between the applications
  • Self-Service Reporting: With the dataset made available to the users, individual users were provided with the ability to create rich, interactive reports without assistance from IT, but under the governance of IT-maintained Active Directory Security

Building Trust Through Project Success

 

SOUTHWEST - 398 South Mill Avenue Suite 201 – Tempe, AZ 85281
Phone: (602) 340-8500
NORTHWEST - 218 Main Street Suite 952 – Kirkland, WA 98033
Phone: (425) 296-0800

© Valore Partners 2020.   Privacy Policy   Contact