ProCogia helped process third party Vehicle Operations Data
Company Information
Facing the challenge of efficiently managing and analyzing extensive vehicle operations data, a leading global shipping company sought to refine its Azure-based data platform. ProCogia was enlisted to leverage its expertise in data engineering and consultancy to optimize data ingestion, processing, and accessibility. The goal was to create a scalable, cost-effective solution that adhered to industry best practices and facilitated easy access to critical telemetry data.
The Challenge
The shipping client required a solution that could seamlessly ingest and process large volumes of third-party vehicle operations data without the continuous operation of resource-intensive Spark clusters. The challenge was to construct a system that was both efficient in handling data in the Databricks Delta format and scalable enough to meet the client’s growing data demands. Additionally, the solution needed to embody best practices in software development and testing to ensure reliability and maintainability.
Procogia’s Approach
The client, a large corporation operating in the marine/shipping industry, had already started building a data platform in Azure where all data was curated using the Databricks Delta format. A consultant specializing in Azure and Databricks was brought in to analyse the requirements and existing platform.
To serve vehicle operations data, an Azure web app was constructed in Python using Pandas and Flask. The Databricks Standalone library was used to access the telemetry Delta table, removing the need to have an expensive Spark cluster running 24/7.
In doing so, ProCogia introduced the client to industry best practices for developing, unit testing and deploying Python web applications.
The Results
ProCogia delivered a stable, highly scalable, protected REST endpoint, which provided an excellent template for similar applications in the future.
We introduced and demonstrated industry best practices for developing and unit testing Python and PySpark code.
The solutions were fully unit tested, documented and deployed into the client’s production environment as an integral part of their data platform.
Services Used
Data Engineering
We partner with all major cloud providers, allowing us to adopt a data-agnostic approach focused on delivering tailored game-changing solutions.
Data Consultancy
We provide data consultancy to organizations to optimize your investment in people, processes, and technology. This is typically through data strategy engagements, roadmaps, transformations, and independent technology advice.
Conclusion
Through the development and implementation of a Python-based Azure web app for the ingestion and processing of vehicle operations data, ProCogia substantially enhanced the data management capabilities of the global shipping client. This project not only streamlined data accessibility and processing but also established a foundation for scalable, best-practice-driven application development within the client’s data platform. ProCogia’s expertise in data engineering and consultancy has thus enabled the client to achieve significant advancements in data strategy, efficiency, and operational scalability, positioning them for continued success in the competitive shipping industry.
Explore more stories
Dig deeper into data development by browsing our blogs…
How QueryIQ is Revolutionizing Financial Reporting
How QueryIQ is Revolutionizing Financial Reporting Introduction In the high-octane realm of accounting and financial services, having immediate access to precise data isn’t just
How a Leading Retailer Boosted Sales by 18% with QueryIQ
How a Leading Retailer Boosted Sales by 18% with QueryIQ 18% Increase in Sales Introduction In today’s fast-paced retail landscape, the ability to make
Improving Weekly ETL Dependencies and Redshift Cluster Runtime for a Global Retailer
80% Reduction in Run Time Information This case study showcases the expertise of ProCogia’s Senior Data Analytics Consultant, Jens Sommerfeld, in optimizing ETL processes
Get in Touch
Let us leverage your data so that you can make smarter decisions. Talk to our team of data experts today or fill in this form and we’ll be in touch.
