Mode

Avantages

The possibility to apply several filtering options to dissect data across multiple dimensions.

Inconvénients

Lack of customization of the interface. User interface can be rather clunky and not as user friendly as it could be, with the result that the learning curve for independent work is steeper than it should be

Avantages

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.

Inconvénients

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.

Alternatives envisagées 

Pourquoi passer à Mode

Avantages

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

Inconvénients

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

Alternatives envisagées 

Pourquoi choisir Mode 

Logiciel antérieur 

Pourquoi passer à Mode

Avantages

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

Inconvénients

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

Alternatives envisagées 

Pourquoi choisir Mode 

Logiciel antérieur 

Pourquoi passer à Mode

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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

Avantages

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

Inconvénients

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

Avantages

"Mode Analytics allows me to easily connect, analyze, and visualize data from various sources, making it a great tool for SEO data analysis""The platform's SQL-based interface allows me to create complex queries and perform advanced data analysis, helping me to identify important trends and insights.""The ability to share and collaborate on data analyses and reports with team members and stakeholders makes it easy to make data-driven decisions.""The platform provides a wide range of visualization options, allowing me to effectively communicate data insights to my team and clients."

Inconvénients

"The steep learning curve for the SQL-based interface may make it difficult for new users to fully utilize the platform's capabilities""The platform's pricing model can be expensive for some teams, especially for larger organizations with many users."

Avantages

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.

Inconvénients

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 is to bypass the python notebook toolchain, it would be nice if there were slightly more configuration tools for data resulting from SQL to help customize plots/chart display.

I would also like the ability to share charts that automatically run on a set time schedule; I find that I frequently share dashboards with supervisors who are perhaps less tech savvy and who inadvertently look at outdated runs of notebooks. Mode *does* indicate that notebook runs are outdated, but it would be nice to be able to push this a step further and have a static link to a dashboard/notebook that re-runs automatically every 30 minutes in the background.

Avantages

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.

Inconvénients

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.

Avantages

Best way to track independent teams performanceHas multiple functions and features and can be used by multiple people from different teams at the same time.

Inconvénients

Is expensive to use and gives error when queries are run multiple timesTracking can be some times buggy if some other team implements something from engineering endsRequires very proper data science modellingIntial Definitions are sometimes tough to understand, so most of the data is to be added to confluence

Avantages

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.

Inconvénients

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.

Avantages

Mode makes it easy to add data from a wide variety of sources, run live queries on that data, and produce detailed graphs and sheets with your results. Its free plan is comprehensive and great for public data collections.

Inconvénients

Mode can be limited in its visualizations and sources. If you're looking for more comprehensive BI toolsets, you may want to consider more expensive options. The cons at this price point are essentially zero though.

Avantages

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.

Inconvénients

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.

Avantages

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.

Inconvénients

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.

Avantages

Convenience of being able to write queries through browser.

Inconvénients

lacking some features, and documentation for work-arounds

Avantages

How easy it is to duplicate a query you're using to answer similar problems.
The ability to schedule reports with .CSVs to run for email recipients .

Inconvénients

I would prefer that when I select a report from a list, such as in a space, that when I return to that list the report I was just viewing should be the first selection. In current state, when I revert back to the list I have to locate the report each time to amend it.

Avantages

The ability to obtain cross function data from multiple locations

Inconvénients

sometimes the amount of data entered returns less responses

Avantages

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.

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

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

Inconvénients

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

Avantages

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.

Inconvénients

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.

Avantages

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

Inconvénients

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

Avantages

Easy to use and plot graphs immediately, you can discover insights really fast.

Inconvénients

Free version does not allowed to share your reports

Avantages

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.

Inconvénients

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.