Our team was engaged by Polpharma to work on an Internet of Things (IoT) scenario, which involved using the Microsoft Azure IoT stack to monitor the temperature of laboratory refrigerators. We then collaborated closely with Polpharma and Microsoft, to enhance the existing solution. These enhancements show not only assets and their monitored values, but also the location of each asset on a floor plan. This allows users to identify assets more rapidly, and to observe correlations of asset location with temperature changes over time. After a short analysis at Polpharma laboratories, we built a proof of concept (PoC) solution, which enabled us to confirm that the proposed architecture was fit for purpose. Additionally, the PoC phase was designed to yield an order of magnitude estimate for the associated time and cost of implementing the full solution.
Objectivity formed a team consisting of 2 .NET/Azure Developers, a UI Developer, a UX Specialist, a Business Analyst, and a Project Manager. The team delivered the scope of the PoC in 11 weeks, consuming 74 person-days, including analysis and preparation of technical solution.
Technical Architects from Objectivity proposed an architecture that accommodates future extensions and meets all of Polpharma’s requirements. To save costs, the concept contains only those components that are needed at each specific stage of the project. The solution’s architecture breaks the data flow into the following layers
- Device (device specific formats and protocols)
- Data transfer (manual or automatic data input, contextualisation, data integrity)
- Raw Data (original data files from devices)
- Processing (reading, cleansing and enriching data)
- Processed Data (data stored in data marts, correlations and insights)
- Analytics (data de-normalisation and modelling for reporting, and advanced analytics with machine learning)
- Presentation (reports, dashboards and self-service analytics endpoints)