Mode

- You can query database tables directly using SQL
- The visualizations are easy to set up and beautiful
- you can literally style ANYTHING on your report using CSS, Javascript, and HTML
- the Python notebook is powerful and easy to use, you can use Plotly along with a whole bunch of other great libraries for working with data.
- There is a Mode API so you can use report results in tools like zapier to help build alerting around your business metrics
- flexable parameterization for reports

This is minor, but the UI can get the tiniest bit glitchy, on occasion. That said I've seen the Mode team address lots of the issues over the years.

The thing that we liked most is that any employee who is familiar with SQL could set up reporting that can be run by all of our staff (technical or otherwise) to solve problems and avoid directly contacting developers when common data issues come up. For example, when our clients call and ask a common question, the team can immediately run a Mode report and provide the answer in real time, leading to a simple business process and effective solution for the client.

Certain SQL functions are not available in Mode. Organizing reports was hard to manage, and we had many legacy reports from past colleagues that had no context unless the user opened the report, which became time consuming.

Security First - It's clear to us that security a primary consideration for all features they roll out
High Customizability - we are able to skin our reports as we'd like
Great Integrations - we post reports to Slack, via API, etc.
Usability - it's extremely easy to use

White-Label Feature doesn't seem to be a priority, as it doesn't get frequent updates