endorsedCompleted

Analytics Backend for Landscaping Supply Company

Services Covered:

Big Data Analytics and Business Intelligence • Cloud Consulting and Services

Industry

E-commerce & Retail

Duration

2 months

Budget

10K - 49K

Start Date

1 May 2021

Team Size

1-5 Employees

Engagement Model

Nearshore

Project Capability Score (PCS)

70/100

Good

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

Netsmartz was hired by a landscaping supply company to develop an analytics backend and set up core infrastructure on Azure, including database configuration. The infrastructure is live and used across several departments; Power BI is leveraged against the data services for day-to-day operations. The vendor was flexible, knowledgeable, and delivered high-quality technical outputs.

Key Challenges

Establish an in-house analytics department
Set up the core analytics infrastructure for the team

Project Deliverables

Infrastructure setup on Azure
Database setup and configuration
Automated synchronization from Google Sheets to PostgreSQL
Integration with third-party data sources

Project Solution

Netsmartz set up the analytics infrastructure on Azure, configured the database, automated synchronization from Google Sheets into a PostgreSQL database, and integrated third-party data sources. The engagement involved 2–3 vendor staff depending on phase, including a project manager, data engineer, and Power BI analyst.

Project Outcome

Output became a core part of daily operations across multiple departments
Enabled company-wide use of Power BI for operations and tracking results
Delivered high technical capability and quality of deliverables

Platforms

Cloud

Tech Stack

Azure
PostgreSQL

Client Endorsement

Overall Review Rating

4.25

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“The infrastructure is up and running. Netsmartz's output quickly became the core of the client's every day work. The vendor was very flexible and knowledgeable throughout the engagement. They also had commendable technical capabilities with high-quality deliverables.”
Anonymous
COO
Date: 08/28/2021