Mode Analytics

Mode Analytics

(33)
4.2 out of 5 stars

Mode is an analytics platform that helps data driven teams analyze, visualize, and share data.

Work for Mode Analytics?

Learning about Mode Analytics?

We can help you find the solution that fits you best.

Mode Analytics Reviews

Ask Mode Analytics a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
  • For Category
Ratings
Company Size
User Role
Industry
For Category
Showing 33 Mode Analytics reviews
LinkedIn Connections
Mode Analytics review by <span>Mihir T.</span>
Mihir T.
Validated Reviewer
Verified Current User
Review Source

"Perfect for extremely limited and specific use cases; needs work to scale for larger orgs"

What do you like best?

Mode is incredibly lightweight (in-browser app) and easy to learn for novice SQL users. It has a relatively friendly query editor that allows quick switching between different data sources, simple plotting, and easy drag-and-drop report generation. The product is most suited for data analysts and scientists to perform quick-turnaround analysis and share insights.

What do you dislike?

Mode is missing several key features that hold it back from scaling in our organization. Fundamentally, analysts and scientists support other business-unit customers, many of whom need regularly-updating dashboards with the ability to perform interactive drill-downs and post-query calculations. Mode supports neither use case.

Even though it is geared towards quick analysis and report-sharing, Mode is limited to 10,000 rows per query and quickly becomes buggy and unstable for larger record sets, or for reports with many (20+) queries. This puts it in an unfortunate intersection of being neither flexible enough for non-analysts nor powerful enough for analysts.

There is no staging / development environment or Github integration, making version control difficult. We have taken to using a stack of SublimeText / Github / Mode for versioning and reproducibility, which adds overhead to every analyst's workflow and makes modification especially difficult for non-analyst stakeholders.

We also find that feature releases are haphazard and their product roadmap remains a mystery. I'm not clear what Mode's vision is for their product: whether they are trying to capture the non-analyst space, or maximize utility within the limited analyst and non-analyst intersection described above. Feature releases are often buggy or poorly communicated, resulting in breakages (e.g. graphs suddenly look weird) and requiring more reactive maintenance than desired.

Recommendations to others considering the product

Identify your use cases and workflows, and think critically about whether Mode will handle them. Ask questions about whether Mode will also scale to handle where your workflows might go.

What business problems are you solving with the product? What benefits have you realized?

Mode solves the problem of quick analysis very well. A prior workflow of:

- SQL query in editor of your choice

- Export to computer

- Analyze locally in R or Python

- Drop into PowerPoint

has been almost. completely eliminated with Mode, which performs an end-to-end solution for the above (provided that the data sets are small, and no post-hoc drilldowns are needed). In that sense, it enhances productivity. But its limitations have also suppressed productivity and opened conversations about whether another product is more appropriate for the scale of our org.

Sign in to G2 Crowd to see what your connections have to say about Mode Analytics
Mode Analytics review by <span>Arvind R.</span>
Arvind R.
Validated Reviewer
Verified Current User
Review Source

"Headed in the right direction, but still a long way to go"

What do you like best?

It's query editor is very easy to use, and allows people to quickly get access to the database and start writing queries. There are helpful views of the schemas and columns that allows new users to familiarize themselves with our data model rather quickly. The ability to set parameters on reports (essentially filters that allow users to change query values) allows for very flexible queries that can be adjusted based on the end user. Definitions are another great feature that allow me to save commonly-used snippets of SQL. This allows for more consistent analysis across our org, and also saves me a lot of time since I don't have to re-write the name subqueries over and over. Also, their Customer Support team is super responsive and always incredibly helpful.

What do you dislike?

It's fundamentally not a BI tool. Mode is more of 'nice-to-have' tool that makes lightweight analysis more convenient, and allows people to share cool insights with each other. That said, it falls short in some areas when compared to other BI tools on the market. Here are some examples of things that are missing:

1. No separation of Development and Production environments. This can make it tricky to collaborate on dashboards and reports with other people, since changes will get overwritten when working on things simultaneously.

2. Lack of a GitHub Integration. It is not currently possible to set up a peer-review process, since there is no concept of opening a PR in GitHub to merge changes into production. At my prior company, we would have modifications to dashboards and reports reviewed by at least one other member of the analytics team to help catch mistakes. This is not possible with Mode, since there isn't a GitHub integration. This also makes it difficult to make global changes across all your queries (for example if a table name changes).

3. Limited post-query modifications. I have worked with other BI tools that allow you to do things like add running totals, row sums, column sums, etc. by allowing you to perform calculations on query results themselves. With Mode, you have to specify every additional calculation you want in the query itself, which leads to a lot of unnecessarily complicated and redundant queries.

4. No way to drill down into charts. A very common request when looking at a chart is to see the underlying data. For example, when looking at a chart that shows the number of churned customers every month, people often want to know the 'actual' customer list that churned on a given month. In BI tools at past companies, people have been able to access this data with a click (i.e. click on a data point to see the line items that make up that data point). The lack of this feature in Mode leads to additional workload for the analytics team since people ask for the underlying data fairly often.

Outside of these areas, Mode does tend to be a little buggy, with the UI not responding as expected, tooltips freezing on the screen, and other minor issues that pop up from time to time.

Recommendations to others considering the product

Mode is headed in the right direction, but they are so far behind other BI tools in key areas I can't recommend them as the main BI tool for any size of company. They lack of a GitHub integration is a huge pain, and gets very difficult to easily create beautiful dashboards (it's possible, but everything has to be custom CSS and JS). They have no data modeling laying, which makes queries unnecessarily complicated. They have addressed some of these gaps over the past few months, but they still have a long way to go.

What business problems are you solving with the product? What benefits have you realized?

Mode allows us to provide widespread transparency into our business. We have a set of basic dashboards that keeps people up to date on many of our key metrics. In addition, the existence of answers to basic data questions encourages people to think more deeply about what drives our business forward. It also reduces the number of redundant requests our analytics team gets, and gives us time to dig into the more meaningful problems we can solve.

What Business Intelligence Platforms solution do you use?

Thanks for letting us know!
Mode Analytics review by <span>Melia V.</span>
Melia V.
Validated Reviewer
Verified Current User
Review Source

"Mode Analytics lets you use regular old SQL to its full potential for data analytics."

What do you like best?

Mode Analytics lets you use regular old SQL to its full potential for data analytics. It is fast, efficient, and lets me get whatever I need out of our data warehouse formatted the way I want it. I've used several other BI tools that do a poor job of trying to cobble together a SQL query for you, which can be very frustrating, especially if you know SQL and already know what you want.

What do you dislike?

I wish you could more easily build advanced visualizations without needing to know HTML, CSS, and Javascript.

What business problems are you solving with the product? What benefits have you realized?

We use Mode to get quick answers to a lot of ad hoc analysis questions. It is great because everyone is looking at the same query (instead of many different people trying to write their own separate queries), and you can send a link directly to the report. The greatest benefit is that Mode enables the business user to get updated info on their own whenever they need it just be re-running the report.

Mode Analytics review by <span>Josh C.</span>
Josh C.
Validated Reviewer
Verified Current User
Review Source

"Always Room for Improvement"

What do you like best?

If the script encounters an error there's usually a very coherent description of what the error is and where it's located. That alone acted as a tutorial to learn SQL.

What do you dislike?

There are too many glitches and bugs. For example, display builder will properly display null values as blanks, but the charts will aggregate blanks as "0"s and lower averages. Highlighting a section of the chart to examine the stats and then updating the chart will freeze the examined section of the chart, and this will remain frozen throughout the entire page until I refresh. Dragging charts in the report builder is difficult if the screen size isn't exactly 100%, and I keep it at 90%.

Recommendations to others considering the product

Stick to pulling source data and make charts in a secondary program.

What business problems are you solving with the product? What benefits have you realized?

The data warehouse allows us to efficiently archive our data on a secured, backed-up server that currently provides more stability than if we were to create our own.

Mode Analytics review by <span>Koltyn P.</span>
Koltyn P.
Validated Reviewer
Verified Current User
Review Source

"Glitches and flaws, but headed in the right direction"

What do you like best?

Help articles, ability to add parameters with liquid, Python school, quick and thorough replies to chats, doesn't log me out

What do you dislike?

- For users who do not know Python, the charting options are limited and the color schemes are too few.

-There are glitches in the report builder where if your screen size is not at 100%, you cannot rearrange the charts.

- If you have several queries in one report, and you have not removed the Display Table from Report Builder, the interface gets glitchy.

- On occasion, a "hover bubble" from a chart becomes fixed on the screen until the whole site is refreshed.

- Can't set up subscriptions with a variety of parameters, so we have to use 10 different reports of the exact same query but different parameters (soon to be 20) which means 20x the time and room for error in data cleansing.

- If two people are working in the same report simultaneously and one saves, the other loses all their work. Wish it were a bit more like GDoc platform in that sense

- Very difficult to distribute reports to all those in the company who need it. We've resorted to Gmail forwarding to get daily reports out to over 200 people

Recommendations to others considering the product

If you want to embed/send to users outside of those with Mode access, make sure to consider/select plan accordingly.

What business problems are you solving with the product? What benefits have you realized?

- Customer Support agent level KPIs

- Volume tracking

- CRM activity

- Replacement %s

- have found many benefits...we didn't have a database prior to this so combining reports via Excel was nearly impossible, let alone sloooooooooooooow

Mode Analytics review by <span>Sameer S.</span>
Sameer S.
Validated Reviewer
Review Source

"Mode as SQL Editor / Embedded BI"

What do you like best?

Mode's team is clearly technically savvy and security-focused. Every time we approach a corner case or a new feature, we notice that Mode has approached it in a straightforward way, with security as its default.

What do you dislike?

There are a few lingering bugs (such as my browser grinding to a halt when I pull up a JSON column), but these are the types of issues I'm sure will be addressed soon. I'd also still like to be able to host Mode on my own infrastructure.

Recommendations to others considering the product

I can't recommend these guys enough. We are paying less than half of what we were paying for our previous BI tool, and have far better output.

What business problems are you solving with the product? What benefits have you realized?

We needed a SQL analytical platform for our technical services team. We wanted a more powerful, easier-to-use replacement for the BI solution that we had integrated into our app. Mode delivered both, ridiculously well.

Its SQL editor is top-notch, and as an added bonus lets us use Python when SQL's not up to the job. As an embedded BI tool, we can now make reports far more quickly than we could have hoped to before -- and because Mode allows us access to the raw HTML, we have been able to style our reporting so that it looks exactly like our app.

Learn more about Mode Analytics

Mode Analytics Downloads

Kate from G2 Crowd

Learning about Mode Analytics?

I can help.
* We monitor all Mode Analytics reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.