RevGen helped a large manufacturing and distribution client improve their data and analytics capabilities by stabilizing and enhancing their AWS data lake, data warehouse, and Tableau visualization environments.
A large manufacturer and distributor of aftermarket automotive products had recently implemented Tableau and a number of Amazon Web Services (AWS) including Amazon Glue, Amazon S3, and Amazon Athena for their data and analytics environments. However, due to several challenges with the new environments, many users continued to utilize legacy reporting applications, creating additional overhead and cost for the maintenance of multiple technologies as well as data discrepancies between the disparate environments.
The slow performance of the Tableau implementation and fragility of the AWS environment coupled with data quality issues caused business users to revert to older reporting tools and data stores that were perceived to be more reliable.
The client was experiencing delays in distributing reporting to their business users. The large amount of data loaded daily into Tableau and the inability to load data incrementally meant that important reports were not available when the business needed them, which was critical for a multi-national organization working across many time zones.
The client struggled with inaccurate data in their Tableau reports, data lake, and data warehouse model on Amazon S3 and Amazon Athena. This undermined confidence in the data and reporting.
Also, they had several legacy .NET reporting applications, each of which was custom coded and costly to maintain or modify. These applications were on-premises and sourced their data from Microsoft SQL Server.
RevGen partnered with key stakeholders in Sales and Finance to identify the greatest pain points that were hindering adoption of the Tableau implementation. From there, RevGen worked closely with IT to improve performance and stabilize the client’s data and analytics environments on Tableau and AWS.
The solution consisted of identifying and addressing the most pressing issues within the environment that limited user adoption.
RevGen investigated the challenges facing the client to identify and prioritize fixes, best practices, and enhancements in Tableau, the data lake, and data warehouse model on Amazon S3 and Amazon Athena, and in the data pipelines in AWS Glue.
RevGen immediately began fixing the Python code in the AWS Glue jobs to address data quality issues by implementing best practices. We also built alerts utilizing Amazon EventBridge and AWS Lambda to quickly notify the client when processes failed or were delayed.
After stabilizing the environment, RevGen began developing a “Version 2” of the data model in Tableau that utilized Tableau Data Extracts. This would address additional data quality issues, reduce load times, and lay the foundation for incremental data loads.
“The RevGen team is by far the most intelligent and capable team I have ever worked with. I trust you and your team 500% and look forward to working with you long term.”
RevGen helped the client lay a foundation that would enable them to leverage more advanced data and analytic capabilities to support future growth.
The execution time for the daily data load into Tableau from Amazon S3 was reduced by almost 50%, which put data in the hands of business users when they needed it.
With the data quality fixes and alerting, the company has renewed confidence in their newly implemented (and stabilized) data and visualization tools, which has driven increased user adoption.
The organization is ready to embrace the future with a solid data and analytics foundation and to retire their legacy .NET on-prem reporting applications. Together, RevGen and the client will continue to build the sustainable technology capability that will support higher advanced analytics maturity necessary to drive accelerated future growth.
Improving data quality was key to ensuring our financial services client retained data integrity and accuracy while also reducing time and money spent on after-hours issues.
The transfer of marketing leads to sales teams is critical for customer acquisition, however our client’s process was time consuming and heavily manual. RevGen built a proof-of-concept solution that automated the entire handoff.
To improve sales efficiency, our client needed an “At-a-Glance” customer segmentation model that could evolve with their business.
Get the latest updates and Insights from RevGen delivered straight to your inbox.
