Case Study: Cedar Valley Farms Improves Cannabis Sales Data Analysis with Yellow

Cedar Valley Farms builds a data pipeline in 5 months with Yellow

Cedar Valley Farms, a cannabis cultivation operator based in Colorado, faced a challenge in gathering and analyzing sales data from its various points of sale due to the complicated and disparate APIs used by different storage and analytics services. To create a single, unified database with analytical tools, they partnered with the vendor Yellow for a data engineering solution.

Yellow implemented a data pipeline that collects information from analytical platforms hourly, processes it into a canonical format, and makes it accessible via REST API endpoints for use in dashboards and charts. The solution included JWT-based authentication for data security and successfully integrated a key platform, Flowhub, using long polling. The project achieved its business goals, resulting in a released service that has received positive user feedback for increasing data efficiency.

Cedar Valley Farms