we are evaluating a new analytics and dashboarding platform for our product: an e-commerce and e-procurement platform served to customers’ end users via browser.
The platform homepage is essentially right now a dashboard with main analytics and KPI requested by customers but we show also simple tables with news and informations. Now, this dashboard is built with a proprietary code, a widget system where only us (IT) can build new widgets or create dashboards.
These widgets, when loaded, execute a stored procedure on SQL server that build the data to show using filters preconfigured at application level to ensure current user can view only the data have to view, they are like “master filter” at dashboard level that users cannot modify.
This filters are saved on our database as parts of a SQL WHERE clause (this could be different on Redash i think)
Some widgets permit to be filtered accordingly to master filters and some could have a drill-down: a direct link to others internal pages like product sheet, orders list pre filtered, …
The dashboard is shown inside our portal having a unique UI (styles, colors), some customer could ask to have custom stylesheets or labels on widgets title or field (one ask for “Agencies” another ask for “Offices”, for example)
The platform is highly profiled, every user is identified at application level with a role and various other attributes and, based on customer’s configuration, this could affect in many ways data the final user can access, for example:
- Superuser: view all across his customer
- Marketing user: view only a part of orders and shipping documents related to a certain product category
- Standard: view only his “site” data as orders or shipping document (for example an insurance agency or a bank local office)
Now we show real-time data because some widgets are linked to budgeting data: for example if a user insert a new order, budget is modified accordingly and recalculated, final user (and super users too) see the budget changing automatically and instantly.
We would, primarily, have a new way to create these dashboards in a more easy and fashonable way and, unlink IT work from creating and maintaining the dashboards and permits to a non-technical users like our Customer Support to create and edit dashboards OR, even better, preconfigure widgets to be used from Customer Support and the final user itself so they could modify a default dashboard and create its own with different widgets.
I would know if, in some way, and with which limitations, this could be done via Redash.
Feel free to ask if something is not clear, i think could be not so strange use case for a platform like this.
Thanks in advance