This is literally what SSRI and PowerBI was invented for. Still requires codemonkies to prepare the data, but at least it cuts down on the rate of requests by allowing them to massage filters by themselves.