Case Study

Unlocking Actionable Intelligence Through Data Transformation

challenge

Out of Date Platform Not Providing Enough Insights for Growth

The Head of Growth Marketing for a global payments company needed insight into how marketers were utilizing email contacts – specifically, what percentage of available contacts were emailed, how often and how early. The goal was to convert website visitors into active users for additional revenue growth. However, this exposed long-standing technical debt in their marketing systems. Without an upgraded platform to make better sense of the data, they wouldn’t be able to increase sales conversions. 

solution

New Environment With Dynamic Data Visualization

To help our client achieve their sales goals, we: 

  • Designed and implemented a transformation pipeline to create a slowly changing dimension (SCD) that tracks email contact statuses over time (e.g., legal permission to send promotional emails and whether they were a website user).
  • Built a transformation algorithm to link the most relevant set of customer attributes for  multi-account users, such as signed up/gone live/adopted or platform/direct/connected.
  • Created an OLAP cube to precalculate metrics for various levels of detail using these transformed data resources.
  • Designed an interactive visual environment that allows the user to dynamically “slice and dice” various views of the data as time series.

results

More Accurate Insights

The Head of Growth Marketing gained a clear and accurate view of their marketing email asset utilization, which had previously been a mystery. They quantified underutilization and set clear targets and goals for the team. Without the data transformations, SCD modeling and OLAP cube, generating insights would have been impossible due to the complexity of the required queries. The project, from requirements gathering to implementation and user acceptance, was completed in just 12 weeks, delivering significant value to the client’s global marketing operations.

Related Case Studies
See All Case Studies
Case Study
Jan 30, 2025

New Trading Desk Enables Continued Growth for Top 10 US Bank

Following the merger of two major financial institutions, our client—a top 10 US bank—needed to expand their suite of offerings to attract new Fortune 500 clients and increase their competitive advantage. Learn how our expertise in complex capital market solutions helped us establish a state-of-the-art trading desk to fuel future growth.

Read More
Case Study
Jan 29, 2025

Centralized Reconciliation System Transforms Payments Company’s Treasury Operations

A rapidly growing unicorn payments company, faced challenges managing payments across a complex and expanding ecosystem. Learn how we created a centralized solution to streamline data management, ensure compliance, and maintain trust with stakeholders. 

Read More
Case Study
Jan 24, 2025

Future-Proofing a Payments System for Scalable Growth

Our client, a rapidly-expanding payments company, needed to lay the groundwork for their next-generation payments platform. Their existing payments system was outdated and lacked the scalability and flexibility required for future growth. Learn how we built a façade around their legacy system to modernize their payment management processes without disrupting ongoing operations.  

Read More
Case Study
Jan 23, 2025

Reimagining the User Experience for a Top 10 US Bank

A top 10 US bank recognized the need to improve the user experience within their Corporate & Investment Bank’s operations. They lacked a clear definition of their diverse user base and struggled to design intuitive interfaces and experiences that met the specific needs of different user groups. Learn how we created a single source of truth that would drive user adoption.

Read More
See All Case Studies
noun-arrow-2025160 copy 2
noun-arrow-2025160 copy 2
See All Case Studies