Avaliações do Mode

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

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.