Helping a Government Agency Align for AI-Powered Impact
Artificial Intelligence
RevGen helped this government agency break down silos and accelerate AI opportunities through strategic collaboration
Driving Adoption of Tableau and Amazon Web Services
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.
Project Overview
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.
Client Challenge
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.
Delayed reporting
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.
Unreliable data
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.
Legacy reporting applications
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.
Approach
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.
Solution
The solution consisted of identifying and addressing the most pressing issues within the environment that limited user adoption.
Analyze
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.
Stabilize
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.
Enhance
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.”
Results
RevGen helped the client lay a foundation that would enable them to leverage more advanced data and analytic capabilities to support future growth.
Reduced load times
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.
Increased confidence
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.
Ready for the future
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.
Success Stories
Enabling a Major Telecommunications Provider to Prioritize and Operationalize AI
Artificial Intelligence
RevGen helped our client turn blue-sky ideas into a realistic, sequenced AI roadmap
Building a Data Pipeline for a Seamless ERP Migration
Technology Services
RevGen designed, built, and executed a Snowflake data pipeline to shift millions of client data records from legacy systems into a new cloud ERP platform.
Subscribe to our Newsletter
Get the latest updates and Insights from RevGen delivered straight to your inbox.