Mode Reviews

- Ease of use - autocompletion is very good - easy to generate complicated analytic reports - easy export for reports

- long query time or inexplicable time outs - very limited options for data visualization

I really liked the way you can write & test your own SQL queries. You can also easily request different Datasets coming from different sources (MySQL, PostgreSQL, Hive, Impala, Aurora, Google BigQuery...) via the same SQL queries. Moreover, it's very simple to create charts and diagrams from the data to generate nice presentations / reports. By the way you have a nice integration with Python/R notebooks.

When your are creating / editing reports, you need to have good knowledge of SQL/Data queries. This side of the platform would be reserved to Data scientists / engineers / analysts. But once the reports are created, it's still one of the best tool in the market to communicate / take decisions with executives / managers / BI teams / clients.

The reports are easy to read and keeps our org wide data super accessible. There's a lot of variety and options as far as visuals are concerned and the product seems flexible enough to work with most, if not all of our applications.

I find it sometimes confusing to navigate and find reports. Would benefit from a nested folder structure for improved organization of reports.

The ability to obtain cross function data from multiple locations

sometimes the amount of data entered returns less responses

As a developer I like being able to write SQL to help analyze problems and also create reports/charts to visualize trends/issues based on our warehouse of production data.

The charting is useful but it would be nice to be able to iterate/switch through chart types a little more easily (without sometimes having to start over when dimensions/measures are reset).

Mode gives me an easy way of understanding licensing on our platform. On top of that, it can provide insights so I can keep on top of my monthly KPI's and make sure I am on target and helps me prove to the company some of the tasks I have been able to complete.

Once logging into the database, it can be fairly difficult to use. It's has a very dark user interface which is hard to navigate.

Mode is easy to set up and a great cost effective option for small teams.

Not as easy to scale as other options. I wouldn't recommend for larger organizations.

Integration with Python Notebooks is very useful.

Impossible to load data from local folders.

Democratization of data - allowing users to self-serve and pull data on their own without having to know how to write queries/scripts/the like.

The fact that all new reports are created by default in your own personal area as opposed the desired location where you created the report in the first place.

I really enjoyed the customer support and the customizable graphics through javascript

I did not like the limited amount of predefined visuals

Very easy to use and gives a lot of useful information

Honestly not much. Its a great product that really helps with my job role.

Straight forward to use. Easy to use. Can do a lot with it.

Sometimes it crashes but it's not that big of a deal.

I love the Python support out-of-the-box, and that you don’t have to pay extra for it (like some other companies).

It was not easy enough for us to hide implementation details from our users. Everyone was able to view the raw SQL statements and infer our database schema from there.

Convenience of being able to write queries through browser.

lacking some features, and documentation for work-arounds

I like how easy it is to view the source code from the dashboard and edit it from there.

It has limited features on visualization options, such as drag and drop.

I like how it easily I can navigate through the warehouse to find the correct tables and the run the first hundred rows of a table is invaluable

You have to run a query to know if I made a mistake in it (big query checks the query live without execution )

It relatively easy to create graphs/reports from you data. Grouping, totalling, etc.. it's all pretty simple and easy to convert a few queries into full blown graphical summary.

I feel it's hard to find relevant documentation for a reporting problem or feature. Usually I end up asking colleagues or digging up some other report where I think I have seen the feature used before.

I love how easy it is to create charts and diagrams from the data to make it easier to explain to others. I love the power that comes with being able to write your own SQL queries

The speed. I know it's data intensive but at the same time, it's a slog to develop in when you are waiting 30s each time the query runs

I like the user friendly interface and the readily accessible view of data.

At times, Mode Report can take up to 20-30 minutes for a small time frame of data.

Gives good insight that the most common provider doesn't once you get everything set up. Lots of ways to look at data.

Getting set up takes time. I guess that is true of all options, just be ready and meticulous for setup

- Easy to read and interpret - Customization is amazing - Honestly, makes my job easier as a salesperson - I can rank my leads accordingly and prepare for my calls easier

The actual visuals could be enhanced for a better user experience.

The User Interface and the fact that I can perform SQL queries and Python coding on the software are definitely a win. Especially considering the ability to use the query results in the python notebook without having to export and re-import tables.

The fact that it is an online product that I have to log in to each time I want to use it. It would be nice to use my terminal to launch it seamlessly after a first time log in.

A big part of my role involves presenting reports where the majority of the data is pulled from Mode. It is always reliable and super simple to use. I would certainly recommend this solution!

None that I can think of. I am not familiar with cost or anything, but reliability is paramount and Mode offers that.

I love the ease of use here. I hadn't used SQL prior to this and their SQL training was really beneficial for me to go through.

At times, it's confusing in how to share your project, who it is sharing to, what they have access to, etc.

Simple to spin up and share new queries and insights.

Creating visualizations isn't straightforward, but I may have more learning to do