Collaborating closely with the client’s Data team, Routine played a pivotal role in addressing these challenges and establishing a single version of the truth. The key components of the solution included:

• Data Cleaning: Routine assisted in cleaning the data within individual tables and ERP systems, ensuring data accuracy and integrity.
• Data Standardization: We created comprehensive data policies to standardize data input and flow across the organization, promoting consistency and uniformity.
• Data Mart Implementation: A centralized data mart was developed, serving as the repository for the “single version of the truth.” This data mart consolidated and harmonized data from disparate sources, enabling seamless reporting and analysis.
• Multi-Team Utilization: The solution was adopted and utilized by various teams, including IT, Finance, and Audit, ensuring cross-functional alignment and collaboration.

Several challenges were identified and addressed during the implementation:

• Orders: The absence of primary keys was rectified by requesting the client to provide all line items in Orders files and identifying unique attribute combinations.
• Vendors: PO numbers in various formats were cleaned up using Routine, and for multiple assets ordered in a single PO, serial numbers were split into different rows to create a standardized flat structure.
• Activity Log: The Activity Time field, initially in an unusable text format, was converted into a DateTime format using Routine. Additionally, noisy data in the Activity Level fields was filtered by identifying relevant keywords.