The Challenge


Procogia’s Approach


  • 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.

The Results


  • 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.


Related Blogs


Let’s Connect