Mode Reviews

I like that in a single place I would be able to query data from multiple data sources, visualize them through charts/tables and if needed create python notebooks for further analysis. Also, the ability to share your work and rerun your work by setting schedules is amazing.

Inability to visualize map data. Not exactly clear on how to custom aggregate data on the Pivot table.

- 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.

Easy to use with technical background. Easy to run a queries analyze the results and built interesting charts to do some exploratory data analysis or follow some KPIs. Also is good subscription by email (or other methods) and great to use python to create some sophisticated analysis.

It's not easy to use for final user without SQL background. If you are looking for operative reporting or EDA is a good solution but if your final users don't know SQL and wats to do some analysis with data like: drag a drop dimensions measures from data mart and build their own analysis, use "drill down", use some sophisticated filters (or/and) or analysis to compare two sets of data,... it has a great way to go.

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

MODE is very easy to learn and really helpful. Since we started using it we’ve been using more and more, making it a MUST for any single area of the company. Connecting to Slack and automating its reports allowd the whole company to know how the business is performing at anytime.

It would be much appreciated if heatmaps could be easier to implement.

Great value for the price. Clearly a tool built for analysts.

The self-service BI is not as good as tableau. However - I hear they plan to make this better.

We love Mode's ability to push analytics into Slack for internal analytics. We also heavily use Mode's White Label Embed capability into our website. We are able to configure Mode's look and feel to be perfectly on-brand. Mode's analytics plug perfectly into our site.

Mode's Grid and Pivot grids still have a long way to go. We end up plugging DevExtreme into Mode - which accomplishes exactly what we need... but it's a lot of work. It would have been nice to have beautiful pivot grids and data grids out-of-the-box. Mode also needs the ability to have triggers (only send this report if X>Y). Right now, Mode can only send on a schedule... but many of our needs are warning systems (if X<=0 then send an alert to this team).

Flexibility. Combining your data with an easy to use HTML editor is great for making custom tweaks to an existing graphic or analytic. Integration. The ability to integrate with most data sources is a great thing. Makes it easy to get started.

I think the app needs tighter integration with the notebook framework. Ideally - we could do some final data tweaks in our language of choice and make it available as a dataset to be used in a mode graphic. I don't like mixing graphic types.

Mode is very flexible and has some great features • Easily schedule reports to go out to your customers (something Tableau does not do well) • Make definitions (commonly used sql chunks) that can be used by anyone in the business • Appealing interface • R, Python, and HTML integration • Good organization options • Easy to customize axes of the graphs you make • Very flexible (if you know HTML) • Really helpful chart type called "BigNumber" which displays your KPI in big, bold numbers (oddly hard to do in Tableau)

• Visualization options are harshly limited (if you don't know R/Python/HTML) • Limited GUI when building charts. All variables must be predefined in the sql query • Sql editor is...not good. If I am trying to reference a column name of a specific table, it will show me similar column names from tables ACROSS OUR ENTIRE DATA WAREHOUSE. Nearly impossible to find if you have column names like "ID" or "NAME". I typically have to build my sql query in another editor and then copy/paste.

Mode has made it much faster to write + share small dashboards for internal consumption. My team gets a lot of random last-minute inbound requests for analytics regarding different parts of our research program, and Mode really makes it easy to make that data available and re-generable for the leadership teams who make those requests.

Some analytics, like almost-automatic chart and table generation using SQL queries, are streamlined in a way I find confusing and hard to use. I find that I have to structure my SQL query in such a way that data comes out just right for mode to display/plot the way I want. SQL is designed for database manipulation and is not great for manipulating data. If the purpose of directly plotting SQL results...

Read more

Lots of visualizations to use, easy for non-technical people on our team to use it.

There is an issue with PDF exporting cutting off tables and visualizations and i have been asking for it to be fixed for almost a month now and no one has fixed it. It affects my ability to send reports to my co-workers, and that puts the software in jeopardy. If we can't show people in the company that it's great and functional we may lose the software

The tight integration of Mode's SQL editor and python notebooks really brought new functionality to our team. I personally hadn't used SQL queries before attempting to write them in Mode, and the editor made it easy to learn. Suddenly, not only did our company have a single, centralized source of truth for jupyter notebooks that had previously been continually passed around in private messages, but we also had a clearer and simpler way to populate those notebooks with data from multiple databases. It was a a game changer.

Speed of editing is really my only complaint. I write any python notebook functionality outside of Mode and just copy and paste the cells I need to avoid having to write new code within the hosted notebook and deal with the slow refresh rates. This is just an inconvenience though, not a deal breaker. And its definitely seemed to have improved since a year ago. Another complaint is that the dashboard layout editor doesn't feel as intuitive as the rest of the Mode platform. It is specifically often difficult to get the intended result when resizing things relative to each other without iteratively adjusting window sizes in the dashboard editor and actual notebook output.

Very easy to use, set up and organize. Their charting and reporting tools are super powerful, and generate great dashboards and reports. The ability to schedule report runs and even send them to Slack or email makes it easy for everyone in our organization to be on the same page.

Really just some minor UI annoyances, but nothing that would prevent me from recommending the software.

This BI software is very easy to use, it has allowed us to gather great insights comparing data from our CRM to our own in house Portal software.

Occasionally some of the coding can be difficult unless you have a very experienced Data Analyst to work with.

The killer feature for mode is how it integrates into source control (github). I have used a lot of different reporting products and there is always a big pain point in putting the reports into source control and easily understanding what dependencies each report has to various data sources. Mode makes this so easy, and allows me to quickly change data sources from a code editor across many reports.

There does not seem to be a lot of options to connect to datasources other than from a database. It would be nice if you could define connections from an API.

The ease of use. Mode is really easy to use, specially you can put it as a self-serve data platform to anyone in your team maybe support, marketing, sales. Everyone can use and get the data.

The version we had was running queries on our own databases everytime we refresh the dashboard.

I like the ease of use and the fact that they keep improving the visualizations so it's becoming a one stop shop for analytics.

It's not Mode's fault, but I need to teach so many other people SQL in order to help them out. Otherwise they just re-run the same old reports.

The ability to do queries in both SQL and R programming allow for dynamic data pulls. The ability to schedule reports is also very helpful for the different departments at my company.

There aren't a lot of holes in what Mode provides. I may not be as informed as I need to be but I often run into issue joining one SQL query to another SQL query.

The user interface is intuitive and makes it easy to go from writing queries to creating dashboards.

1. There are glitches that can be frustrating. 2. There are certain missing features that would be nice additions. Example glitch: 1. When going from a query to report builder, certain times the created dashboard visuals won't load, which requires a page refresh to make it appear. Example additional features: 1. Ability to show or minimize all queries (i.e., show/hide the query & associated charts). 2. Ability to set a default color scheme for your account without having admin permissions.

Mode let's my team build dashboards to monitor our key results. It's incredibly easy to use and perfect for our needs.

Sometimes queries fail or it takes time to refresh a dash. Wish it were faster.

The UI is clean and simple. I was new to the world of Business Intelligence software and getting used to it was very easy.

It can work out quite pricey if you have a lot of casual/read only users.

so easy to connect to your database and query your data. More recently, you can even use jupyter notebooks and write python scripts to easily join data from different databases. this is really helpful for our everyday work with data in different databases

Nothing, I love Mode and have been recommending it to so many people.

I like the Python Notebook. It allows me to wrangle data from many data sources and quickly share results with the rest of the company.

There may be memory limitations when using the notebook with underlying data sets.

Incredible organization for my sets of code, great sharing amongst teams, great visual display of information

It's pretty hard to think about what I don't like. Dynamic variables have not always worked properly in my experience and charting can be a bit rigid