ETL & Analytics Dashboard for Veterinary Marketing Company
Services Covered:

Industry
Advertising & Marketing
Duration
6 months
Budget
50K - 199K
Start Date
1 March 2020
Team Size
6-10
Engagement Model
Offshore
Project Capability Score (PCS)
74/100
Good
Project Capability Score (PCS) estimates how capable NeoITO 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
Vet Marketing Pro
Project Summary
Neoito built an ETL-style analytics platform for a veterinary marketing technology company by designing the architecture, setting up a PostgreSQL database, and connecting it to Google Data Studio. They implemented roughly 70 API calls to aggregate marketing and API call data, created dashboards for analytics, and provided documentation. The product met the client's data needs and was acquired eight months into the partnership; the vendor communicated daily and met deadlines throughout.
Key Challenges
- Create an ETL platform to aggregate API call and marketing data flows
- Consolidate disparate data sources into a single analytics dashboard
Project Deliverables
- Set up a PostgreSQL database
- Built ~70 API calls to aggregate data from different sources
- Connected the database to Google Data Studio for dashboards
- Created analytics dashboards
- Provided documentation and transferred technology to acquiring company
Project Solution
Neoito identified the system architecture, set up a PostgreSQL database to centralize data, connected that database to Google Data Studio for graphical dashboards, and implemented approximately 70 API calls to pull data from multiple sources for redundancy testing. They developed analytics dashboards from the collected data and delivered full documentation and technology handover when the project was acquired.
Project Outcome
- The team obtained the data they needed and the architecture recommendations proved correct
- The API calls were implemented successfully and produced credible, detailed data
- The product met success criteria and was later acquired by another company
- The vendor communicated daily and met every deadline, enabling transparent project management
Platforms
Web
Cloud
Tech Stack
PostgreSQL
Client Endorsement
Overall Review Rating
5
5 out of 5 stars
Timeliness
Cost Rating
Willing to Refer
Quality of Deliverables
Neoito's expertise produced a credible, detailed API database, and it played a smooth part in making the project a success. Just eight months in, our project was acquired by another company. The team stayed professional and communicative throughout our partnership.
Note: This endorsement is based on publicly available client feedback from external review sources.
More Projects by NeoITO
Endorsed
Ongoing
Social Networking
Angular Frontend Development for Community Engagement Platform
Services Covered:
+1 more
Endorsed
Ongoing
Software Development
Angular Migration & Web Client for Queue Management Platform
Services Covered:
+1 more

