endorsedOngoing

BI & BigQuery Data Warehouse for Cannabis Dispensary

Services Covered:

Big Data Analytics and Business Intelligence

Industry

E-commerce & Retail

Duration

45 months

Budget

50K - 199K

Start Date

1 November 2022

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

76/100

Good

Project Capability Score (PCS) estimates how capable Addepto 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

Purple Lotus Patient Center

San Jose, United States of America

Project Summary

Addepto built a BI-driven data warehouse for a cannabis dispensary, modernizing the client's data infrastructure to handle multi-source online and offline data. The work included a BigQuery data warehouse, Looker for visualization, and AirByte pipelines extended with custom connectors and GPT, deployed on a Kubernetes cluster. The engagement is ongoing; the client praises Addepto's project management, communication, and proactive, cost-effective technical choices.

Key Challenges

Make external and business processes fully data-driven
Modernize data infrastructure to handle multi-source (online and offline) data flawlessly

Project Deliverables

Data warehouse on BigQuery
Looker data visualization layer
AirByte data pipeline enhanced with custom connectors and GPT
Kubernetes deployment of data infrastructure

Project Solution

Addepto built a new data warehouse architecture extended by existing BI elements. They used BigQuery for the warehouse, Looker for visualization, and enhanced the AirByte data pipeline with custom connectors and GPT. The solution was deployed on a Kubernetes cluster and designed to handle multi-source online and offline data and support future AI-driven improvements.

Project Outcome

No measurable outcomes yet to share
Strong project management with consistent, clear communication
Timelines met or communicated clearly when delays occurred
Responsive team providing proactive, cost-effective solutions

Platforms

Cloud

Tech Stack

Google Big Query
Kubernetes

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The project is ongoing, but the client praises Addepto's excellent project management skills and clear and consistent communication. The technically proficient team has met all deadlines and is proactive in coming up with the most efficient, cost-effective solutions for the client's problems.”
Sara Krishnamachari
Chief Financial Officer
Date: 05/23/2023