endorsedCompleted

Email Leaderboard Dashboard for Medical Education Firm

Services Covered:

Custom Software Development • Database Development and Management • Data Integration

Industry

Education

Duration

1 month

Budget

Less than 10K

Start Date

1 March 2020

Team Size

1-5 Employees

Engagement Model

Offshore

Project Capability Score (PCS)

72/100

Good

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

United States of America

Project Summary

NeenOpal Inc. built a SQL database integrated with MailChimp to calculate point totals for email "races" and connected that data to a Tableau dashboard showing leaderboards. The project automated a previously manual, multi-hour reporting process and saved the client significant weekly time while using a single point of contact for streamlined communication.

Key Challenges

Track leaderboard results for email "races" across different audience segments
Make it easy to pull weekly leader information to increase audience engagement

Project Deliverables

SQL database
MailChimp integration
Leaderboard Tableau dashboard

Project Solution

NeenOpal built a SQL database that they linked to Mailchimp to calculate and store point totals and rankings. They connected that data to a Tableau dashboard to display top-10 leaderboards by race and audience segment. The engagement was managed via a single vendor point of contact.

Project Outcome

Saved significant weekly reporting time, reducing a multi-hour manual process to seconds to retrieve leaderboards
Streamlined communication through a single point of contact
High responsiveness and quick delivery from the vendor

Platforms

SaaS

Tech Stack

SQL
Mailchimp
Tableau

Client Endorsement

Overall Review Rating

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“NeenOpal Inc.'s project successfully saved the client a lot of time each week in reporting. Because the project was simple, they streamlined communication into one point of contact. The team was very hands-on and provided excellent service.”
Anonymous
COO
Date: 07/20/2020