Premier Needle Arts

Case study

Premier Needle Arts

Unifying enterprise data and forecasting product demand across a portfolio of craft brands.

A worker checking yarn and fabric inventory in a craft-supply warehouse.
Editorial illustration.

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.