A few suggestions for useful features: Time Series functionality would be handy (Exponentially weighted moving average, centered moving average etc).
Aggregations across sliding intervals (by shift / by day/week/month/ Finical year etc). Being able to quickly answer questions like What is the production for week to date, current shift etc. How about previous week/shift etc.
One other comment I will give is I find SQL to be useful as a protection against product lock-in. It's essentially the lowest common denominator language for dealing with data extraction/transformation etc. Our business has been burnt before by having our reporting/BI written in a tool specific language it made migrating away from the product very difficult. Ever since I've very much been of the mindset to do as much using SQL as possible.