Logo-black

Boosting sales by 15% through marketing optimization for a spa franchise

  • Travel & Hospitality

Boosting sales by 15% through marketing optimization for a spa franchise

OneSix helped a luxury spa franchise optimize its marketing investments using data-driven analytics, leading to a 15% increase in prospect sales. By implementing a marketing data warehouse, marketing mix modeling (MMM), and automated budget optimization, the client gained real-time visibility into performance.
Data Science
AI & Machine Learning
AI-Driven Marketing
Power BI

Overview

Lack of visibility and ineffective marketing spend hindered growth

For a luxury spa franchise with hundreds of locations, ensuring marketing investments drive real value across national, regional, and franchise levels was a growing challenge. Without clear visibility into spend and performance, it was difficult to optimize marketing strategies and allocate budgets effectively. The client faced two key issues:

  • Limited Visibility: Minimal and delayed reporting of channel spend at national, regional, and local (franchise) levels made it difficult to assess marketing performance.
  • Inability to Improve Marketing ROI: Due to the lack of an empirical impact measurement strategy, the client struggled to make strategic investment decisions across marketing channels.

Our Solution

Data-driven marketing optimization to enhance budget efficiency

To solve these challenges, OneSix implemented a data-driven marketing optimization framework, leveraging advanced analytics and automation. Our approach was specifically designed to support a franchise model by providing both high-level and location-specific insights. Key aspects of our solution included:

  • Implementing a structured approach that accounts for national-, regional-, and franchise-specific effects on media efficiency and non-media influences.
  • Customizing adstocking and saturation functions, with parameters adaptable to specific groups.
  • Handling missing data and uneven time series across different franchise locations.
  • Incorporating multiple methods for time-based effects analysis.
  • Developing an optimization model tailored to the client’s specific needs, including group-specific constraints and budget allocations.

To bring this strategy to life, OneSix deployed a comprehensive suite of solutions:

  • Marketing Data Warehouse: Centralized all marketing and adjacent data into a unified data warehouse. Power BI was used to enable real-time, customizable reporting across all franchise levels.
  • Marketing Mix Modeling (MMM) Pipeline: Implemented an advanced MMM framework to evaluate the impact of various marketing channels on key performance indicators (KPIs), such as sales and customer acquisition. The MMM pipeline provided:
  • A structured method to quantify the contribution of each marketing channel.
  • Predictive insights to optimize future budget allocations.
  • Actionable recommendations to shift spending to high-performing channels.
  • Automated Marketing Optimization: Our proprietary MMM tool facilitated continuous, real-time budget optimization by integrating historical performance data, market conditions, and client-specific constraints.

Results

Improved marketing efficiency and measurable sales impact

By implementing these solutions, the client gained the ability to make data-driven marketing decisions with confidence. Key outcomes included:

  • Full automation of marketing budget allocation and spend/impact reporting, eliminating manual data reconciliation efforts.
  • 15% increase in prospect sales as measured in an initial experiment, directly attributed to optimized marketing budget allocations across channels.
  • Enhanced strategic decision-making through real-time visibility into national-, regional-, and franchise-level marketing performance.

Through OneSix’s expertise in data-driven marketing optimization, the luxury spa franchise gained unprecedented control over its marketing investments. With real-time insights and predictive modeling, the client can now continuously refine their marketing strategies, ensuring maximum return on investment across all franchise levels.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Building a Customer 360 data solution for Leader Bank

  • Financial Services

Building a Customer 360 data solution for Leader Bank

By implementing a unified Customer 360 data solution, OneSix enabled Leader Bank to enhance customer service, drive data-driven marketing, improve data quality, and boost operational efficiency.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Overcoming data silos to gain a unified view of customers

To maintain a competitive edge, community banks need to have a deep understanding of customer behavior and preferences. Leader Bank, like many financial institutions, faced a common challenge: fragmented systems and data silos. They had separate platforms for commercial lending, residential lending, and core banking operations, with little interaction between them. This siloed approach made it incredibly difficult to establish a comprehensive view of their customers.

Back-office processes were cumbersome, and customer support teams found it challenging to provide efficient service due to a lack of unified customer data. To compound matters, data quality issues, including inconsistent naming conventions and formats, added complexity to the situation.

Our Solution

Implementing a Customer 360 platform with a cloud-based infrastructure

OneSix partnered with Leader Bank to tackle these issues head-on, devising a comprehensive solution that aimed to provide a holistic view of each customer. The key components of this solution included:

  • Master Data Management (MDM) Strategy: OneSix developed a robust MDM strategy to standardize data across the organization, ensuring consistent naming conventions and formats. This laid the foundation for accurate data integration.
  • Cloud-Based Data Infrastructure: To create a unified platform for customer data, OneSix implemented a cloud-based data lake and data warehouse. This allowed for the storage and processing of vast amounts of data from different systems in a scalable and cost-effective manner.
  • Rules Engine: A rules engine was introduced to automate data validation, cleansing, and transformation. This ensured that data was accurate, up-to-date, and adhered to the defined standards.

The goal of these components was to establish a common data platform where information from various systems could seamlessly integrate. This would enable Leader Bank to tie together customer interactions, track their history, and gain valuable insights for personalized marketing and improved customer service.

Technologies Implemented
  • Snowflake served as the host to collect data into the data lake across various systems. A C360 data warehouse served the BI and Customer information needs of this bank.
  • Fivetran was used to capture data across a variety of data sources to move data into the data lake. In addition, Snowflake Data Share provided access to raw data for a Snowflake-based system.
  • Matillion was used as the rules engine to cleanse data and provide match/merge rules for the customer record and transform that into the data warehouse.
  • PowerBI was used to drive analytics and display Customer 360 information across the institution.

Results

Enhanced customer service, data-driven marketing, and operational efficiency

The implementation of the Customer 360 solution brought about significant positive changes:

  • Improved Customer Service: With a unified view of customer data, the bank’s support teams could quickly identify callers and access their interaction history. This streamlined the support process, leading to improved service and reduced call handling time.
  • Data-Driven Marketing: To create a unified platform for customer data, OneSix implemented a cloud-based data lake and data warehouse. This allowed for the storage and processing of vast amounts of data from different systems in a scalable and cost-effective manner.
  • Enhanced Data Quality: The MDM strategy and rules engine led to improved data quality. Data inconsistencies were eliminated, resulting in more reliable and accurate information for decision-making.
  • Increased Efficiency by 2X: Back-office processes were streamlined, reducing operational inefficiencies. This led to cost savings and increased productivity across the organization.
  • Increased Customer Satisfaction: With improved service and personalized experiences, customers were more satisfied, leading to stronger customer loyalty and potential for business growth.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Unlocking global sales and customer insights with for a leading restaurant chain

  • Travel & Hospitality

Unlocking global sales and customer insights with for a leading restaurant chain

OneSix created a Power BI solution for a global restaurant chain, enabling interactive, on-demand insights into sales performance and customer sentiment across international markets.
Data Analytics
Microsoft Azure
Power BI

Overview

Achieving a view of global operations for a large restaurant chain

The larger a company grows, the more difficult it is to capture a comprehensive view of its operations. Once an organization’s footprint has reached across international borders, maintaining clear visibility into every market, department and customer segment becomes challenging.

This was precisely the problem that our client, a global restaurant chain, came to OneSix to help solve. Company leaders wanted to better understand global sales performance across their core products as well as customer sentiment around their largest brands.

Our Solution

Designing a proof of concept for scalable, interactive data insights

Given the scale of the business’s operations, a new solution couldn’t simply be swapped in for the previous data warehouse platform. OneSix worked with our client’s executive leadership to design and launch a viable proof of concept that could be piloted within select business units.

Our team created a rapid prototype using Microsoft’s Power BI platform – in particular, leveraging Power Query and Power Pivot features to build dashboards and reports. Excel-based data sources were cleansed via DAX functions in Power BI.

Technologies Implemented
  • Azure DAX and Power Query were leveraged to cleanse the data and consolidate multiple Excel data files into a single data store
  • Power BI enabled interactive dashboards and reports to executive leadership

Results

Enabling on-demand insights into global sales and customer sentiment

Our client is now able to provide end users with a more interactive and visually rich way to work with their global sales and customer sentiment data.

The ability to compare global sales performance and drill into individual markets and product performance was now available on demand. The team was able to understand the capability of the new platform and identify whether or not it could be leveraged for a much larger implementation down the road.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Uncovering insights into member engagement for a digital health company

  • Healthcare & Life Sciences

Uncovering insights into member engagement for a digital health company

OneSix implemented a scalable data warehouse solution for a digital health company, enabling efficient, accurate reporting and data-driven insights into member engagement across texting programs.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Streamlining insights into member behavior

A digital health company was looking to better handle its customers’ needs by providing insights into member behaviors within its texting programs.

Our client provides their customers with various metrics with regard to participation and engagement in their many texting program offerings. As requests come in for new information and/or slight variations in existing reports, our client needed a better way to meet these requests.

The existing process was very manual and prone to errors, sometimes delaying turnaround time in responding to customers’ data requests. This process impeded the client’s ability to create new reports or aggregate reports across multiple programs for each customer. The current reporting could represent a point in time but did not easily allow for trends over time.

Our Solution

Building a flexible data warehouse with automated ETL

OneSix designed and built a data warehouse that could handle the client’s current and future needs in both reporting and data analytics. We created a data model that could handle today’s reporting needs while allowing the flexibility to add on later. 

Using Fivetran, we brought their source data, SQL Server and DynamoDB, into a Snowflake database. Using Matillion, we built a fully automated ETL process with fewer steps and a faster turnaround time to provide up-to-date data. The reporting and analytics are now available in Power BI.

Technologies Implemented
  • Snowflake was utilized as the data warehouse to store engagement and messaging data.
  • Fivetran was leveraged to fully replicate data from AWS DynamoDB and SQL Server on RDS to a data warehouse.
  • Matillion was used to efficiently and quickly transform source data into an appropriate schema for reporting needs.
  • Power BI provided the internal and customer facing reports for actionable insights and trends.

Results

A single source of truth for decision-making and trend analysis

With this solution and knowledge transfer, the organization is able to leverage the analytics output from our project as a template for building future reporting. A single source of truth from the cloud data warehouse allows the business to look at the numbers with confidence for decision-making.

Key financial metrics are available to view by snapshot, trends, as well as drill-down to more granular components in a visual, easy-to-digest method. The labor reporting has already yielded insight into better management of overtime for the workforce.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Delivering timely financial and labor insights for a food manufacturer

  • Manufacturing

Delivering timely financial and labor insights for a food manufacturer

OneSix delivered a scalable cloud data platform for a fine food manufacturer, enabling reliable, timely insights into financial and labor metrics, streamlining reporting, and supporting data-driven decision-making across the organization.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Creating a reliable, scalable data platform for accurate, timely insights

A single source of truth with accurate and timely data insights across the company is critical for manufacturers. Our client, a fine food manufacturer that provides protein and meal solutions for customers ranging from national restaurants to food service providers was utilizing a legacy data platform that relied on a difficult-to-maintain database and business intelligence solutions requiring heavy technical coding skills.

The existing process was very manual and prone to errors, sometimes delaying turnaround time in responding to customers’ data requests. This process impeded the client’s ability to create new reports or aggregate reports across multiple programs for each customer. The current reporting could represent a point in time but did not easily allow for trending over time.

Our Solution

Implementing a modern cloud data architecture for reporting

OneSix presented a case for a modern cloud data architecture that would reduce maintenance overhead as well as the ability to scale in size and volume as their data needs continue to grow. As a decision was solidified, an end-to-end data lake and data warehouse solution was created with an initial set of analytics reporting that provided full visibility into the P&L and Balance Sheet for the finance executive team as well as a visual view of their labor data for operations leadership.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable, and flexible data lake and data warehouse environment.
  • Fivetran provided flexible data pipelines loading data into the data lake, saving time and money on data engineering development.
  • Matillion was the core data transformation technology used to integrate and cleanse the data in preparation for visual analytics.
  • Power BI provided reports to the operations and executive leadership teams for actionable insights and trends.

Results

Empowering decision-making with a single source of truth

With this solution and knowledge transfer, the organization is able to leverage the analytics output from our project as a template for building future reporting. A single source of truth from the cloud data warehouse allows the business to look at the numbers with confidence for decision-making.

Key financial metrics are available to view by snapshot, trends, as well as drill-down to more granular components in a visual, easy-to-digest method. The labor reporting has already yielded insight into better management of overtime for the workforce.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

  • Healthcare & Life Sciences

Driving ROI and data-driven decisions with self-service reporting for regenerative medicine

OneSix implemented a secure, self-service Power BI reporting solution, enabling a regenerative medicine company to gain immediate ROI from their new CRM/ERP system and drive data-informed decisions across sales and finance.
Data Analytics
Microsoft Azure
Power BI

Overview

Leveraging new CRM/ERP data for actionable insights

A regenerative medicine company specializing in placental-derived products was in the process of a technology transition. The company implemented Dynamics 365 Business Central as its new CRM and ERP platform to track sales and accounts receivable.

Their new platform unlocked troves of new data that opened a new future for their business, one that is rooted in analytical insights and data-driven decision-making. But, in order to get a valuable ROI for their system upgrade, they needed a self-service reporting platform to take advantage of their newfound data assets.

Our Solution

Building a Power BI reporting suite for self-service access

OneSix developed a suite of reporting tools within Power BI to equip the company with the data it needed to improve its bottom line.

  • Sales: A collection of sales-related data visualizations provides insight into performance at a salesperson, region, product, and customer level.
  • Finance: Accounts receivable could now be tracked at an enterprise level, quickly pointing out customers with high levels of aging invoices.

Self-service data enablement was built in, enabling access to clean, curated datasets and reporting insights to all team members, from any device. Row-level security settings open the door to insights beyond the C-Suite, allowing individual salespeople to securely log in and see their own revenue growth, identify cross-sell opportunities at a product level, or profile important customers.

Technologies Implemented
  • Dynamics 365 Business Central CRM/ERP platform brought new data streams previously unavailable to C-suite leadership and front-line sales teams.
  • Azure Active Directory was utilized as a direct channel for granting access and establishing secure, row-level data security settings.
  • Power BI reports enable insights into key revenue growth strategies and streamlines operations.

Results

Empowering data-driven decision-making across teams

With this highly interactive, foundational reporting structure, the client is now primed to create a culture of data-driven decision-making.

The sales team can see their performance and drill down into a variety of different data points to help set strategy. The accounting team has a one-stop shop for both tracking their accounts receivable at a high level and accessing line item-level datasets that can be integrated into existing workflows without disrupting operations.

The new reporting structure will allow the company to yield immediate ROI on their system upgrade by having reporting live immediately as they transition to their new CRM/ERP system.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Optimizing warehouse operations and 3PL efficiency with near real-time data

  • Logistics

Optimizing warehouse operations and 3PL efficiency with near real-time data

By implementing a scalable data platform with near real-time reporting, OneSix enabled a 3PL client to optimize warehouse operations, enhance financial analysis, and streamline data-driven decision-making across departments.
Data & App Engineering
Data Analytics
Snowflake
Matillion
Fivetran
Power BI

Overview

Enabling real-time visibility and scalability in a 3PL environment

In the fast-paced, hands-on, 3PL work environment, logistics companies require near real-time reporting on key metrics to track warehouse capacity as well as warehouse operation activities.

Our 3PL client is a long-standing logistics service provider based on the east coast. With a wide array of products across consumer-packaged goods, specialty foods, food ingredients, health and personal care products, and alcoholic beverages, the task of keeping track of every pallet and case is paramount to business success. They needed a solution that would consolidate their data, reduce maintenance overhead, and allow them to scale in size as their data needs continue to grow.

Our Solution

Automating data pipelines and building flexible data models

OneSix designed and developed automated data pipelines to easily move data from their legacy platform into a data lake. We created data models to handle the client’s current reporting needs and give them the flexibility to enhance them in the future. We worked with key stakeholders to develop reports that the enterprise can use for financial analysis, warehouse workload trends, and warehouse occupancy.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and multi-tenant data warehouse environment.
  • Fivetran provided dynamic data pipelines per customer’s unique data model, loading data into the data lake, saving time and money on data engineering development​.
  • Matillion was the core data transformation tech used to integrate and cleanse data and load it into the data warehouse in preparation for visual analytics.
  • Power BI provided reports to the operations and executive leadership teams for actionable insights and trends.

Results

Enhanced decision-making and operational efficiency

A modern data platform solution made near real-time data accessible to the different departments in the organization. The C-suite is able to view current and historic financial reporting, slicing and dicing the data by key business attributes to identify high-cost areas. 

The operational teams utilize the warehouse workload reporting to improve labor utilization, identifying and eliminating bottlenecks and prioritizing warehouse activities based on high-volume tasks and deadlines. The result is a modern, data-driven approach to tackling the complex problem-solving required in the 3PL industry.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Eliminating data silos to drive efficiency and growth in title insurance

  • Financial Services

Eliminating data silos to drive efficiency and growth in title insurance

By implementing a unified cloud data solution, OneSix helped a leading title insurance company eliminate data silos, improve data quality, and enable real-time insights for greater operational efficiency and growth.
Data & App Engineering
Data Analytics
Snowflake
Power BI

Overview

Breaking down data silos for streamlined operations

Our client is a title insurance company that provides title, escrow, settlement, and related products and services. They have been in business for over a century and have grown to become one of the largest title insurance companies in the United States. ​

Due to the scale of their business, growth due to M&A, and fast pace of the real estate industry, our client had multiple systems for title and escrow processing based across separate geographical locations. This resulted in a series of data silos and data inconsistencies and frequent delays in delivering enterprise-wide reporting and analytics. ​

Our Solution

Implementing a scalable cloud data architecture

OneSix implemented a solution that uses a modern cloud data architecture that would reduce maintenance overhead, improve data quality, integrate data, and allow our client to scale as their business and data needs change over time. ​

The solution consisted of replicating all the data from various source systems into a data lake. The transformation layer was used to apply business rules, and clean, and consolidate the data into a data warehouse model solution. The new platform provided a new standard across the organization for data storage and information access.

Technologies Implemented
  • Snowflake was leveraged to create a highly secure, scalable data lake and multi-tenant data warehouse environment.
  • Rivery was utilized for acquiring data from various source types.
  • Informatica was the core data transformation tech used to integrate and cleanse an individual tenant's data, loading it into the multi-tenant data warehouse in preparation for visual analytics.
  • Power BI provided reports for actionable insights and trends.

Results

Unified data insights for efficiency, cost savings, and revenue growth

With the modern data solution, the client eliminated data silos, improved the data quality, streamlined workflows, improved efficiency, and increased their ability to make data-driven decisions. Using a single source of truth from the cloud data warehouse, the client generated consistent and accurate reporting across the organization. ​

The operations team created dashboards to identify trends and patterns in order volume which helped the client proactively plan for staffing and resource allocation. The revenue dashboards provided a near-real-time view of KPIs across various business units and geographical locations. The workflow dashboards and reports are being used to identify bottlenecks in the product workflow and improve turnaround time for client services.​ Together, these analytics tools have helped the organization improve efficiency, reduce costs, and increase revenue.​

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us

Centralizing IT processes and data sources​ in renewable energy

  • Energy

Centralizing IT processes and data sources​ in renewable energy

By centralizing data and implementing near real-time analytics, OneSix enabled a renewable energy client to improve asset monitoring, accelerate decision-making, and enhance operational efficiency.
Data & App Engineering
Microsoft Azure
Power BI

Overview

Accelerating insights for renewable energy

When it came to the management of energy projects, our renewable energy client experienced a significant gap in analytics. Their legacy system didn’t provide data on asset utilization until weeks later, hindering their ability to make data-driven decisions in real time.

To speed up the time to insights, OneSix recommended a centralized data repository where asset management information can exist in one place for exploratory and standardized analysis.

Our Solution

Technology modernization and change management

As a trusted partner, OneSix built a deep understanding of the business, its unique challenges, and opportunities. With a focus on data centralization, the engagement has been a healthy combination of technology implementation and change management. ​

As part of a Dedicated Data Team (DDT), OneSix implemented a streamlined process to transform data from raw to business-level tables across internal and external sources. The outcome was a holistic view of project asset utilization. The OneSix DDT also supported and built out new integrations, reporting capabilities, and apps. This included building enterprise dashboards, public datasets, and data catalogs.

Technologies Implemented
  • Azure Data Factory was used for data integration.
  • Azure Synapse Analytics was used to accelerate time to insight.
  • Power BI provided reports for actionable insights and trends.

Results

Near real-time project and asset monitoring

By harnessing near real-time actionable insights at both the project and asset level, significant strides were made in reducing response times to unexpected changes.

Additionally, our recommended approach to centralizing data movement and maintenance has been instrumental in enhancing operational efficiency. Streamlining data management into a centralized system has facilitated smoother access, analysis, and upkeep, thereby optimizing workflows and resource allocation across the board.

Ready to unlock the full potential of data and AI?

Book a free consultation to learn how OneSix can help drive meaningful business outcomes.

Contact Us