endorsedOngoing

Custom Data Portal Dev for Cannabis Retailers Collective

Services Covered:

Custom Software Development • Website Development

Industry

Agriculture

Duration

51 months

Budget

50K - 199K

Start Date

1 May 2022

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

72/100

Good

Project Capability Score (PCS) estimates how capable Novatore Solutions is of successfully delivering a project like this, based on its past experience, track record, and ability to handle similar work. Learn more about PCS

Client

Confidential

Canada

Project Summary

Novatore Solutions developed a custom data portal for a retail cannabis collective, building ingestion, reconciliation, and analytics capabilities using PostgreSQL, React.js, and Power BI. The vendor implemented a reconciliation engine that normalizes multiple input formats and produces reports and invoices for producers and retailers. The engagement began with a discovery phase and remains ongoing since May 2022.

Key Challenges

Build a data portal to collect and reconcile retailer data
Translate reconciled data into industry analytics for partners

Project Deliverables

A custom data portal built from discovery through implementation
Data ingestion capability for retailers to upload or connect POS data
A reconciliation engine that normalizes multiple report formats and produces clean reports and statements
Analytics visualization UI (Power BI) for users
API connections to POS providers for automated data pulls

Project Solution

Novatore Solutions conducted a discovery phase and developed the portal from scratch using PostgreSQL and React.js with Power BI for analytics. They built data ingestion pipelines and connectors to allow retailers to send data, developed a reconciliation engine to normalize multiple report formats and generate statements and invoices, and are building the UI and API integrations to connect to POS providers for automated data retrieval.

Project Outcome

Processes an average of 2 million lines of data per month from retailers
Reconciliation throughput improved from roughly three weeks to results provided within a day (retailers now have one week to upload; engine returns results within a day)
Novatore met project deadlines approximately 90% of the time

Platforms

Tech Stack

PostgreSQL
React.js

Client Endorsement

Overall Review Rating

4.5

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Novatore Solutions has developed a reconciliation data system that processes an average of 2 million data lines per month, improving the client’s processes significantly. They communicate effectively through Google Meet and WhatsApp. Novatore Solutions uses Git for project management.”
Shakir Tayabali
CEO
Date: 02/02/2023