We probably need some extra docs to help flesh out how this can be achieved (based on actual requirements from a mapping project):
Submission history for each enumerator
Custom date range filtering of submissions
Total submissions vs total number features surveyed
Filter submissions by tasks
Average submission time per enumerator
Expected number of submissions vs actual daily submissions
Leaderboard based on submission
Yes, PowerBI is proprietary, but it's free to use, very powerful, and user friendly. We need to be realistic and suggest the easiest solution that most end users will connect with. I would propose we document the process for PowerBI first.
Additional Research
(from previous thread)
Describing various options in different forms.
Desktop Apps
PowerBI is the simplest and most powerful. The files can be shared with other users of PowerBI Desktop. The dashboards cannot easily be shared on web however.
Excel can also load OData, but it's not as visually appealing or easy to use as PowerBI.
Haven't tested Tableau, but it's meant to be good (less powerful that PowerBI).
Hosted Solutions
Note with these options we need to pay to host them...
~Redash, acquired by databricks… (limping on as OSS currently, so let's see where it goes)~
~Apache Superset & Metabase don’t support OData~
Grafana has an OData plugin and is a fantastic CNCF project.
Probably our best choice until we discover something else.
A bit of a pain to configure the data provider / dashboard, but works.
We could possibly use the XOData chrome extension, but it looks a bit old. Not tested.
Final option is to make our own simple dashboard using a Graph library (charts.js or Apache ECharts) and HTML tables.
The creds for OData endpoints would need either be:
Embedded in the web app - not an option 😅
Configured by the user - not that user friendly.
Summary
In summary this is a tough decision!
Recommendation:
Have simple visualisations for most common requirements built into FMTM (as we do currently, but improved upon).
For more complex / bespoke needs, just ask the user to install PowerBI and make a dashboard (this could be done for them by sharing a pre-configured .pbix file dashboard).
Problem
Follow on from #1440
Possible Solutions
Additional Research
(from previous thread)
Describing various options in different forms.
Desktop Apps
Hosted Solutions
Note with these options we need to pay to host them...
Grafana has an OData plugin and is a fantastic CNCF project.
volumes: grafana-storage:
Web
Summary
In summary this is a tough decision!
Recommendation:
.pbix
file dashboard).