endorsedCompleted

SQL Data Warehouse and Forecasting for Outdoor Equipment Retailer

Services Covered:

Big Data Analytics and Business Intelligence • Data Engineering • Data Integration • Database Development and Management • Managed IT Services

Industry

E-commerce & Retail

Duration

13 months

Budget

10K - 49K

Start Date

1 March 2021

Team Size

1-5 Employees

Engagement Model

Onshore

Project Capability Score (PCS)

70/100

Good

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

Vietnam

Project Summary

Synodus built an SQL data warehouse and Power BI reporting system for an outdoor equipment e-commerce company, optimizing data models and BI visuals and implementing a sales forecasting model. The project centralized data updates (every 10 minutes), improved report performance, and supported cost-optimization for warehousing and shipping.

Key Challenges

Data came from many sources and was difficult to monitor
Centralized .csv files on AWS S3 were not optimized for querying, causing slow loads (40s)
BI reports were slow to load and limited in scope
Company structure complicated report distribution
High warehousing costs due to large storage needs

Project Deliverables

Data warehouse on SQL database with 10-minute updates
Optimized BI reports and data model (DAX) in Power BI
Reporting system covering sales, marketing, finance, and customer support
Sales and revenue forecasting model to estimate imports
Row-level security (RLS) consultation and implementation

Project Solution

Synodus built a SQL-based data warehouse with data refreshed every 10 minutes, optimized the data model and DAX in existing BI reports, and developed a Power BI reporting system covering sales, marketing, finance, and customer support. They created a periodic sales and revenue forecasting model and recommended/implemented row-level security (RLS) to enforce department-based access.

Project Outcome

Report load times reduced from 40 seconds to 3 seconds
Warehousing costs reduced by 23%
Improved accuracy in shipment and courier cost calculations
Weekly/monthly report deliveries and improved team responsiveness

Platforms

SaaS

Tech Stack

Amazon Web Services (AWS)
SQL
S3
Power BI

Client Endorsement

Overall Review Rating

4.88

Timeliness

Cost Rating

Willing to Refer

Quality of Deliverables

“Synodus' new data model for the client's sales reduced the cost of warehousing by 23%. They optimized the gap between courier shipping costs and fees, as well. They had an effective organizational structure with a responsive structure.”
Anonymous
Demand & Operation Planning Mngr
Date: 10/12/2022