Revenue Lift Index: How PREDICTif Solutions Empowered a Customer’s Cloud Migration Journey

Usman Aslam
7 min readAug 29, 2023

--

In the ever-evolving landscape of business, where data has become the cornerstone of decision-making, Wilsonart, a pioneer in interior design and surfacing solutions, embarked on a transformative journey to amplify its data analytics capabilities. Spearheaded by the expertise of PREDICTif Solutions, this visionary initiative aimed to build a robust Data Science infrastructure in the cloud. Let’s delve deeper into how this transformative collaboration led to the successful implementation of Wilsonart’s Analytics Platform initiative, catalyzing growth, insights, and innovation.

A Shared Vision of Data-Driven Excellence

The Analytics Platform initiative, executed in close partnership with PREDICTif Solutions, unfolded as a pioneering venture that sought to revolutionize Wilsonart’s data analytics capabilities. At its core were two strategic use cases: the Revenue Lift Index (RLI) and Contact Management. These diverse yet interconnected projects were set to transform raw data into actionable insights, steering Wilsonart toward data-driven success.

1. Revenue Lift Index (RLI): Illuminating Sales & Marketing Insights

The RLI project emerged as a critical tool for Wilsonart to navigate the intricate realm of Sales & Marketing statistics. PREDICTif Solutions took on the role of architecting a solution that seamlessly integrated data, advanced analytics, and intuitive visualization. The culmination of their expertise and Wilsonart’s business acumen was a Tableau dashboard that illuminated insights through interactive visualizations.

Leveraging the prowess of AWS services, Glue jobs, and orchestrated workflows through Step Functions, the RLI architecture materialized. Data flowed seamlessly from Wilsonart’s on-premises BI Data Warehouse, underwent transformation via Glue jobs, and ultimately populated the RDS database. PREDICTif Solutions’ ingenuity resulted in a dashboard that not only showcased data but also empowered stakeholders to make informed decisions through dynamic interactions.

2. Contact Management: Orchestrating Efficiency Amid Complexity

In the fast-paced realm of marketing, accurate customer contact information is a linchpin for success. The Contact Management project, guided by PREDICTif Solutions’ expertise, sought to streamline this intricate process. With an ETL framework driven by AWS Glue, data from diverse vendors found a harmonious home in an Amazon S3 bucket.

PREDICTif Solutions’ unique approach ensured the development of an adaptable framework capable of gracefully handling diverse data sources. The result was an automation-driven solution that streamlined Wilsonart’s contact management process. Through iterative collaboration, PREDICTif Solutions aligned the technical solution with Wilsonart’s specific needs, culminating in an efficient and effective data management process.

Leveraging AWS Services for a Tailored Solution

The journey from data challenge to effective solution required a strategic orchestration of various AWS services, each serving a distinct purpose in solving Wilsonart’s intricate problems. The seamless integration of these services played a pivotal role in crafting a tailored solution that met Wilsonart’s specific needs. Below, you’ll find an insightful breakdown of the specific AWS services thoughtfully harnessed by PREDICTif to craft and implement this innovative solution for Wilsonart:

1. AWS Cloud Infrastructure

The foundation of the solution was laid with a robust AWS Cloud Infrastructure. Leveraging Amazon Web Services ensured high availability, durability, security, and governance for Wilsonart’s data science initiative. The architecture was designed to accommodate large-scale governance and transparency, adhering to secure practices.

A crucial component of the architecture was the implementation of the AWS Control Tower. This management service set up guardrails and security policies across the entire AWS environment, ensuring a standardized and secure foundation for all subsequent accounts. An AWS Organization Unit (OU) named Security OU was established, under which dedicated AWS accounts for logging and auditing were auto-generated. This hierarchy facilitated monitoring and transparency of operations within the AWS accounts.

2. AWS Identity Center & Identity Access Management (IAM)

Effective management of user access was paramount, and AWS Identity Center (successor to AWS Single Sign-On) played a vital role in streamlining access while maintaining security. This service allowed Wilsonart’s users to access multiple AWS accounts under the Control Tower using a single set of credentials. IAM Identity Center integration with a managed third-party identity provider, CyberArk, ensured stringent access control.

IAM users were tailored exclusively for PREDICTif consultants, who were responsible for solution delivery. Multi-factor authentication (MFA) was implemented to enhance security for root users of both the AWS Management Account and the Data Science account.

3. AWS Networking Services

The networking aspect of the solution was meticulously crafted to ensure seamless connectivity and data flow. A Virtual Private Cloud (VPC) was created to house account-specific resources, with private and public subnets tailored to distinct requirements.

For secure access, Virtual Private Networks (VPNs) were established, allowing ingress and egress points to and from the VPC. Site-to-Site VPN connections provided a secure bridge between the AWS environment and Wilsonart’s on-premises network, while an Internet Gateway enabled internet connectivity.

Amazon Route 53, AWS’s managed DNS service, facilitated domain name resolutions within the AWS environment, ensuring efficient resource access paths.

4. Data Processing and Analytics

The heart of the solution was the intelligent processing of data to provide actionable insights. AWS Glue, a serverless ETL (Extract, Transform, Load) service, was employed to orchestrate the data pipeline. Glue jobs efficiently pulled data from Wilsonart’s on-premises BI Data Warehouse and transformed it, ultimately populating the designated Amazon RDS (Relational Database Service) instances. AWS Step Functions played a pivotal role in orchestrating the sequence of Glue jobs, ensuring a seamless and automated flow of data processing tasks. These RDS instances served as repositories for the processed data, making it readily accessible for further analysis. Meanwhile, CloudWatch and CloudTrail monitored the activities, providing valuable insights into resource performance and user behavior. The illustration below vividly demonstrates the strategic role of AWS Step Functions in seamlessly orchestrating a diverse array of AWS services within the solution:

5. Visualization and Interaction

For Wilsonart to derive meaningful insights from the processed data, visualization was key. Utilizing Amazon S3 and Amazon EC2 (Elastic Compute Cloud), Tableau dashboards were developed to provide interactive displays of critical indices like the Revenue Lift Index (RLI). The Tableau server hosted on Wilsonart’s premises connected seamlessly to the AWS-hosted RDS instances, enabling real-time analysis and decision-making.

6. API Gateway for Accessibility

To enable external users to retrieve calculated RLI values, an API endpoint was established using AWS API Gateway. This private endpoint, secured by a secret key, triggered Lambda functions for RLI calculations, seamlessly integrating with the processed data stored in RDS. This accessibility bridged the gap between the analytical results and actionable insights, empowering Wilsonart’s decision-makers.

Image Source: AWS Public Documentation

PREDICTif’s Role in Crafting the Solution

The strategic deployment of these AWS services, meticulously orchestrated by the PREDICTif Solutions team, culminated in a comprehensive and powerful solution. PREDICTif’s expertise in architecting cloud-based solutions allowed Wilsonart to transform complex data challenges into actionable intelligence. By customizing AWS services to suit Wilsonart’s unique requirements, PREDICTif ensured that every component of the solution aligned seamlessly, resulting in an efficient and tailored data analytics platform. The visual representation below provides insight into the successful implementation of both the Revenue Lift Index and Contact Management solutions.

Collaboration: The Heart of Success

PREDICTif Solutions’ role extended beyond technical implementation; it was rooted in collaboration and alignment with Wilsonart’s business goals. Here are pivotal aspects that spotlight the essence of this transformative partnership:

  1. Customized Craftsmanship: Recognizing that each business possesses unique requirements, PREDICTif Solutions delivered solutions tailored to Wilsonart’s specific needs. Their approach ensured that technical solutions directly addressed real-world business challenges.
  2. AWS Mastery: By harnessing Amazon Web Services (AWS), PREDICTif Solutions sculpted an environment that prioritized scalability, security, and efficiency. This AWS Cloud Infrastructure formed a robust foundation, allowing Wilsonart to unlock the full potential of their data.
  3. Seamless Orchestration: The harmonious orchestration of Glue jobs, Lambda functions, and Step Functions underscored PREDICTif Solutions’ skill in streamlining complex processes. This orchestration paved the way for data to flow seamlessly, enhancing efficiency and reducing operational friction.
  4. Future-Focused: PREDICTif Solutions’ commitment extended beyond the present project. Their proposed future improvements, such as the transition to a Transit Gateway and performance testing of the Tableau dashboard, exemplified their dedication to ongoing innovation.

Conclusion: Navigating Data-Driven Horizons

The union of Wilsonart and PREDICTif Solutions stands as a testament to the transformative power of collaboration, technical expertise, and a shared vision. Beyond amplifying analytics capabilities, this partnership sparked innovation and propelled Wilsonart into the realm of data-driven decision-making.

As businesses continue to navigate the dynamic landscape of data analytics, initiatives like the Wilsonart Analytics Platform illuminate the path to success. By fostering a culture of collaboration and leveraging expert guidance, PREDICTif Solutions has not only facilitated a technological transformation but has also paved the way for Wilsonart’s continued triumph in the realm of data-driven excellence.

Before you go!

  • Stay tuned for more insights! Follow and subscribe to Cloudmize.
  • Did you see what happens when you click and hold the clap 👏 button?

Author: Usman Aslam (Principal AWS Solutions Architect)

--

--

Usman Aslam
Usman Aslam

Written by Usman Aslam

Ex-Amazonian, Sr. Solutions Architect at AWS, 12x AWS Certified. ❤️ Tech, Cloud, Programming, Data Science, AI/ML, Software Development, and DevOps. Join me 🤝

Responses (2)