Case study
Premier Needle Arts
Unifying enterprise data and forecasting product demand across a portfolio of craft brands.

Forecasting across craft brands
Premier Needle Arts oversees manufacturing, global distribution, and retail operations across quilting, knitting, sewing, and needlework. Following multiple acquisitions, the business had inherited separate ERP systems, warehouse databases, and inventory catalogs.
Growing SKU counts and disconnected demand forecasts contributed to excess inventory costs and stockouts of fast-selling products. Manual reporting cycles could take weeks.
A shared view of inventory
The Emperitas team consolidated five legacy database systems into an enterprise data warehouse on Snowflake. They used dbt for data modeling, lineage, and automated quality testing, and standardized master data management across subsidiary brand catalogs.
They built a forecasting model with Prophet and LightGBM to predict demand for individual products across global distribution centers.
Reported results
Excess inventory holding costs fell 22% within 12 months of deployment. Order fulfillment accuracy reached 99.1% across the multi-brand distribution hubs.
Automating data pipelines and executive dashboards saved an estimated 15 hours per analyst per week.