Ecommerce Forecasting
Category: Data Analytics & Alerts
A simple database that automated a client’s reorder process with more accurate sales forecasting.
Objective: Create a flow of product to closely match market demand
Approach: Set up an ETL to pull all sales, shipping and returns data for all ecommerce channels. Added some complex, custom kit/component calculations. Created a simple dashboard showing daily product restock forecasts, automatically updated using manufacturer shipping alerts.
Tools/Tech: SQL, Webhooks, PHP
Client/Industry: Ecommerce, 12,000 Skus
Game Highlights
- CEO could focus on other things with a simple, daily dashboard that would send alerts for any supply issues.