I can buy or manually provision anything, no technical hurdles or policies from that side. My absolute focus is the raw UX for business people.
Suggestions?
Metabase is the only tool I’ve used where I’ve managed to get non-technical users to actually engage and use to query building tools to answer their own questions.
We designed it specifically to provide an excellent UX to business users while reducing BI burden on the data team. We find that most business users often just need to search, filter, and sort instead of looking at charts to make operational decisions.
UX-wise, what sets us apart are:
- <1s full-text search (even on billions of rows of data), feels like Cmd+F in Google sheets, but faster
- Performance: we stream billions of rows into the web browser, seamless scrolling (no paging of 50 records at a tieme)
- Rich cells make tables easier to scan/read (enum strings => colored tags, numbers => color-coded based on value => checkboxes, timestamptz => clear date time pills)
If that fits what you need, happy to give you a demo.
arthur(at)dataland.io
Otherwise, I think the simplest BI (if charts are impt) could be something like evidence.dev or Metabase.
But I also think it's going to require some curation on your part. Can you reasonably expect business users to navigate the entire schema/table tree across these three sources? That's where I think the bottleneck often lies -- if your BI tool allows engineering to just expose a subset of curated core tables.
> has the best UX for nontechnical people to assemble some data
If they can use Excel / pivot tables, they can use Definite. They can also just ask in natural language and we generate the report for them.
> Salesforce, some mariadb/postgres and (optionally) hubspot as data sources
We have pipelines for all of these and can spin up a managed data warehouse to store all the data if you don't already have one.
Drop me a note at mike@definite.app if you're interested
Maybe that'll change one day with AI, and when it does that will be bought by every big company in the world (-:
Follows a conversational "ChatGPT-like" approach since already 2016.
Info: I'm one of the founders.