- ProCogia engaged their data engineering team who followed an agile methodology reporting progress weekly.
- Automated the ingestion of data using Azure Data Factory.
- The team implemented an ingestion pipeline which incrementally pulled data daily, which replaced previous inefficient full table loads.
- Shifted the report generation from Power BI into the Azure data warehouse enabling previously undiscovered historical insight.
- Improved data quality by removing duplicates and errors over a 20+ year period.
- Azure data warehouse was built and automatically refreshed with business and transactional data.
- Enabled dependency for report generation to be moved to a data warehouse with a subsequent reduction in load on a transactional system.
- New reporting capabilities across including cash, inventory, sales & billing.
- Educated the client on best practices in data management along with descriptive and diagnostic analytics.