I’ve hopped around a bit, company to company, almost always SAAS products, and have been asked to design generally the same features. I use existing platforms and software when I can, but some things just need to be custom for their system.
Something that has always needed to be custom- but not because the problem is unique to their ops- is charting and visualizations. When dealing with massive amounts of data you need to organize the raw data in a way to be consumed at runtime (“rollups” some might call it), and pass it through some visualization library like hicharts, google charts, some d3js example you found, etc.
This is really time consuming and it feels unnecessary, like a platform should exist that will take your companies raw data, organize it by your criteria, and spit out visualizations that you can embed into your tools.
I know of Tableau, Domo, Grow, etc. But having talked with them they don’t support, and aren’t keen to supporting in the future, this use case. They want you to pay-per-seat, and use their platform for internal reporting and analysis. They don’t want you to design a revenue report and at runtime filter the results by one of your 30,000 users and display it through your own admin.
Does the platform I’m describing exist and I haven’t found it? Can I avoid writing another routine to calculate rollup data, avoid writing another stored procedure to filter/pivot that data, and avoid juggling multiple charting libraries because not one library has all the features I need?