endorsedOngoing

Data Warehouse Connectors & RedShift–Domo Integration for Digital Marketing Agency

Services Covered:

Custom Software Development

Industry

Advertising & Marketing

Duration

45 months

Budget

10K - 49K

Start Date

1 November 2022

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

79/100

Good

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

Grand Rapids, United States of America

Project Summary

A digital marketing agency contracted DATAFOREST to develop a data-driven dashboard by integrating disparate data sources into a data warehouse. DATAFOREST built an AWS-based architecture using RedShift and Lambda to create connectors between multiple systems and implemented a connector between RedShift and Domo for reporting. The client reported that the vendor consistently delivered on scope, on time, and on budget and praised their communication and project management.

Key Challenges

Integrate disparate data sources from a vendor with proprietary systems into a data warehouse
Rapidly develop data connectors so the client's team could focus on dashboard development
Produce a data-driven dashboard to support business decisions

Project Deliverables

AWS-based architecture using Amazon RedShift and Lambda
Collection of connectors between multiple data systems
Connector implementation between Amazon RedShift and Domo for reporting

Project Solution

DATAFOREST used an AWS architecture (including Amazon RedShift and Lambda) to build a set of connectors that integrated multiple proprietary data sources into a centralized data warehouse. They also implemented a connector between RedShift and Domo to enable reporting and supported the client's team through regular project management and communication.

Project Outcome

Delivered on scope, on time, and on budget
Improved communication and responsiveness with regular collaboration via Slack
Project managers provided effective coordination across time zones

Platforms

Tech Stack

Amazon Web Services (AWS)
Amazon RedShift

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“DATAFOREST consistently delivered on scope, on time, and on budget. They communicate incredibly well and give helpful suggestions throughout the course of the project. The client is impressed with the team's project management, regular collaboration, responsiveness, and industry knowledge.”
Charlie White
Director of Software Development
Date: 02/13/2023