Re:Spc-kit: A toolkit for statistical process control using SQL
by jacques_chester on Wednesday March 06, 2024 @10:01AM
(#39616686)
I think the SPC tests for detecting process shift would be EWMA and Cusum. The code has EWMA support, but it relies on a function to work and so is tied directly to PostgreSQL.
[ Parent
| on HN ]
Re:Spc-kit: A toolkit for statistical process control using SQL
by apwheele on Wednesday March 06, 2024 @12:00PM
(#39618013)
Agreed a bit of different use cases. (Or maybe should say the SPC approach is a better/more principled approach, whereas this is an easy graphical approach and I don't need to worry about "resetting" the CUSUM.)
I use the binomial CIs in dashboarding scenarios, so if the user selects a different subset of data, all the graphs are auto-updated (on the SQL side). Which when you get people subset into tinier slices of data it becomes more important.
So if you can upfront identify the processes you want to monitor, then when flagged have this send an alert. That is better than a dashboard forcing people to click on stuff and hope they identify a anomaly in the process.
Re:Spc-kit: A toolkit for statistical process control using SQL
by melondonkey on Wednesday March 06, 2024 @01:04PM
(#39618830)
More dashboards need this I think. I’ve also added relative standard error values on aggregations before to serve as a reliability filter that doesn’t even show users data when they slice it too then.