Case Study

FirstService Brands: Orion Data Management Program

Summarize and streamline large quantities of information

FirstService Brands is the leading North American brand in the category of property services, which it delivers through its extensive franchise and contractor networks. Built over the last twenty years, the companies and management teams have produced exceptional value creation for their shareholders, partners, employees, and customers. Today, FirstService Brands includes Paul Davis Restoration, CertaPro Painters, California Closets, College Pro Painters, Pillar To Post Home Inspection, Floor Coverings International, BrandPoint Services and TLS.

The Mission

FirstService Brands approached AXIS for a solution to provide comprehensive business intelligence management and reporting. FirstService is one of the most progressive franchisors when it comes to brand development and data analysis. Their goal was to consolidate consumer and prospect data in one centralized online data visualization portal.

Report on tablet

Driving Home

AXIS builds a fully integrated system that consolidates consumer/prospect by brand by Franchisee, standardizes the data for the purposes of cross-matching within the brands, and populates a tiered user comprehensive business intelligence visualization tool using Tableau Software™.

Database Development: AXIS consolidates multiple data sources (8 brands) utilizing different file formats into one consolidated view with multiple analysis filters (by brand, region, consumer type, product type, and more.)

Data Processing: Centralized data is cleansed, duplicates found and merged and everything is standardized in a common format following business rules specific to each brand. This data then populates a “sandbox” database for customer manipulation and also populates a separate operational database that feeds the Tableau reporting system. Tableau reports are accessible by each Franchisee brand.

Key Continuity Management (KCM) procedures are implemented to govern ongoing data updates.

FirstService Brand Logos

Are you a marketer with a unique challenge of managing your data?

Let us help you solve it today.