Thread by @beeonaposy

Update: based on feedback from this thread, we're doing a trial of Mode Analytics, and liking it so far.

I'm going to add some specifics about our use case, and pros and cons of Mode so far, below in case anyone is trying to make this decision for their org. 👇

https://twitter.com/beeonaposy/status/1108817167015993344

In current state, we have important data living in at least three databases hosted on different servers. This means we need a solution that will allow us to combine data from multiple DBs, and Mode lets us do that using either #rstats or #pydata, which is a big plus. ✅

That said, Mode provides some tools for building visualizations on top of queries (without code!) that we were hoping our business users could utilize if analysts did the work of querying and combining data sources. This isn't fully possible currently, but could be in the future.

Mode has been really helpful for democratizing access to data sources. Assuming a business user or product person knows SQL (some of ours do, or are learning), they're already able to start answering their own questions which is 💯

Additionally, it allows for building interactive reports / dashboards (using their built-in viz tools or by adding plotly to R or Python viz) in a way that's comparable to Shiny, which is great for end-biz-users. 👩‍🎨

Should have added at the beginning: the main pain points we're trying to address with a BI tool are:
* Create and host reports and dashboards without having to maintain much infra
* Automatically update and share reports and dashboards
* Some DIY access for non R/Python folks