App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

Microsoft SQL Server vs Mode Comparison

Add to Compare

Compare similar apps

Bitrix24 logo

Bitrix24

4.1

NetSuite logo

NetSuite

4.1

Ortto logo

Ortto

4.6

Zoho Analytics logo

Zoho Analytics

4.4

Sage Intacct logo

Sage Intacct

4.2

Microsoft Power BI logo

Microsoft Power BI

4.6

Good recommendations?

Overview

SQL Server is a relational database management system (RDMS) designed to help businesses of all sizes analyze structured...

Mode is a cloud-based software that helps enterprises leverage business intelligence (BI) tools to extract data from multiple...

  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials
  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials

Video & Screenshots

Pricing

Starting from

13748

One-time payment

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

Starting from

ic-pricetag

No pricing info

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

User reviews

4.6

1.7K

5

4

3

2

1

1.1K

597

49

4

1

  • Value for money
  • Ease of use
  • Features
  • Customer support
99%
would recommend this app

4.6

87

5

4

3

2

1

54

32

1

0

0

  • Value for money
  • Ease of use
  • Features
  • Customer support
100%
would recommend this app

Pros

This is a great way to leverage your data to get better metrics and results. The world is driven by data these days and this is a great way to leverage that.
Very good - SQL Server have so far been a joy to work with. Along with T-SQL support and Azure integration, we're very happy with its performance and environment, including cool data visualization.
I like that it's really stable and it doesn't consume a lot of resources. It's easy to use, highly customizable, and the performance is great.

Pros

Also is good subscription by email (or other methods) and great to use python to create some sophisticated analysis.
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 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.

Cons

For instance, rather than receiving a syntax error, you can receive a weird message if you forget to include a comma while listing the fields you are asking for.
What I don't like most about this is that the error messages can be lacking sometimes leaving you puzzled as to what actually occurred.
For example if you miss a comma while listing out the fields you are querying for you can get a strange error rather than a syntax error.

Cons

It has limited features on visualization options, such as drag and drop.
Another complaint is that the dashboard layout editor doesn't feel as intuitive as the rest of the Mode platform.
Charting options can be limited sometimes, and I don't always have the time to put something together in python. Pivot tables are AWFUL, just get rid - it's not even worth offering them.
  • Vendor responds to reviews
  • Last review8 days ago
  • Vendor responds to reviews
  • Last review25 days ago

Key features

  • Total features36
  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts/Notifications
  • Application Development
  • Backup and Recovery
  • Benchmarking
  • Collaboration Tools
  • Compliance Management
  • Contact Database
  • Customizable Branding
  • Customizable Dashboard
  • Customization
  • Dashboard
  • Data Blending
  • Data Cleansing
  • Data Connectors
  • Data Dictionary Management
  • Data Discovery
  • Data Extraction
  • Data Import/Export
  • Data Mapping
  • Data Migration
  • Data Profiling
  • Data Quality Control
  • Data Storage Management
  • Data Synchronization
  • Data Transformation
  • Data Verification
  • Data Visualization
  • Drag & Drop
  • Forecasting
  • Full Text Search
  • Functions/Calculations
  • Integration into Third Party Applications
  • Interactive Reports
  • KPI Monitoring
  • Key Performance Indicators
  • Marketing Reports
  • Mobile Dashboards
  • Mobile Reporting
  • Multi-User Collaboration
  • OLAP
  • Performance Analysis
  • Performance Metrics
  • Predictive Analytics
  • Private Dashboards
  • Profitability Analysis
  • Public Dashboards
  • Publishing/Sharing
  • Queries
  • Query Builder
  • Relational Display
  • Reporting & Statistics
  • Reporting/Analytics
  • Sales Reports
  • Scheduled/Automated Reports
  • Scorecards
  • Search/Filter
  • Self Service Data Preparation
  • Self-service Analytics
  • Server Monitoring
  • Single Page View
  • Storytelling
  • Strategic Planning
  • Third Party Integrations
  • Trend/Problem Indicators
  • Visual Analytics
  • Visual Discovery
  • Visual Workflow Management
  • Widgets
  • Total features59
  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts/Notifications
  • Application Development
  • Backup and Recovery
  • Benchmarking
  • Collaboration Tools
  • Compliance Management
  • Contact Database
  • Customizable Branding
  • Customizable Dashboard
  • Customization
  • Dashboard
  • Data Blending
  • Data Cleansing
  • Data Connectors
  • Data Dictionary Management
  • Data Discovery
  • Data Extraction
  • Data Import/Export
  • Data Mapping
  • Data Migration
  • Data Profiling
  • Data Quality Control
  • Data Storage Management
  • Data Synchronization
  • Data Transformation
  • Data Verification
  • Data Visualization
  • Drag & Drop
  • Forecasting
  • Full Text Search
  • Functions/Calculations
  • Integration into Third Party Applications
  • Interactive Reports
  • KPI Monitoring
  • Key Performance Indicators
  • Marketing Reports
  • Mobile Dashboards
  • Mobile Reporting
  • Multi-User Collaboration
  • OLAP
  • Performance Analysis
  • Performance Metrics
  • Predictive Analytics
  • Private Dashboards
  • Profitability Analysis
  • Public Dashboards
  • Publishing/Sharing
  • Queries
  • Query Builder
  • Relational Display
  • Reporting & Statistics
  • Reporting/Analytics
  • Sales Reports
  • Scheduled/Automated Reports
  • Scorecards
  • Search/Filter
  • Self Service Data Preparation
  • Self-service Analytics
  • Server Monitoring
  • Single Page View
  • Storytelling
  • Strategic Planning
  • Third Party Integrations
  • Trend/Problem Indicators
  • Visual Analytics
  • Visual Discovery
  • Visual Workflow Management
  • Widgets

Integrations

  • Total integrations114
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • Salesforce Sales Cloud
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite
  • Total integrations14
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • Salesforce Sales Cloud
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite

User reviews that mention these apps

WH
AvatarImg

Wasim H.

Industrial Automation, 10,001+ employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

My SQL server review as a developer

Reviewed 5 months ago
Pros

Safe mode database server allows unwanted deletion due to a mistake. Simple straight forward queries to fetch the data. Integration with SQL workbench

Cons

Requires a lot of memory to run the server locally. Need to have opensourse latest versions available.

fm
AvatarImg

francis m.

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Robust well established relational database and support is readily available in many ways and easy.

Reviewed 5 years ago
Pros

It is stable and has some advance security features compared to other database and supports client server mode and clients access information necessary to them.

Cons

Licensing is difficult to get .It consumes a lot of RAM which makes the machine to freeze.It might be comfortable for beginners.

MS
AvatarImg

Michael S.

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

The only database tool worth using

Reviewed 5 years ago
Pros

I've used SQL for years and I'm always impressed at how each next version takes user feedback and rising industry standards in to account.

Cons

Other than lacking some UI features in the latest releases (i.e., dark mode) there really isn't anything not to like.

AC
AvatarImg

Alberto C.

Telecommunications, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

The SQL database of choice for mission critical solutions

Reviewed 4 years ago

It's been our SQL database for 2 decades, and has always proven to be very reliable

Pros

Always-on mode makes this a trully high availability database Encryption-at-rest with per-database encryption keys XML and JSON support Very high performance Distributed availability groups Very reliable Great management app (Enterprise Manager)

Cons

Distributed support is still in the early days ans is somewhat lacking

AvatarImg
AvatarImg

BJ N.

Computer Software, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Great for applications of all sizes

Reviewed 4 years ago
Pros

I've managed databases for applications ranging from small static websites to large multi-tenant content management systems. SQL Server is great for both. Best feature is being able to use SQL Command Mode (SQLCMD) for scripts.

Cons

When restoring databases, I have occasionally ran into the issue where settings or privileges weren't correctly mapped.

AvatarImg
AvatarImg

Jossmely S.

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Unites Sql with Internet

Reviewed 5 years ago

facilitates the creation of solutions to problems with versions, disaster recovery and backup copies. You can transfer databases in a very simple and intuitive way between your local environment and the cloud.

Pros

Graphic environment that allows the administration. allows to work in server client mode, where the information and data are hosted on the server and the clients of the network access it. It allows to manage information of other data servers, it supports stored procedures.

Cons

Huge amount of RAM that is used for the installation of and use of Software, is somewhat expensive. My version 2005 does not allow the compression of data, which generates a lot of disk space.

SM
AvatarImg

Steven M.

Construction, 501-1,000 employees

Used weekly for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Microsoft SQL Server

Reviewed 2 years ago

My overall experience has been just fine, this is a solid product with Microsoft backing it up. It's the SQL equivalent to a Toyota Camry; you'll get there, and it won't be flashy, but it gets the job done.

Pros

Microsoft SQL server is a great tool to use with SQL, I mean it's Microsoft, so it's probably going to be good no matter what, you're also going to know how it's going to be laid out too. It may not be my favorite editor, but it's a solid choice for sure.

Cons

This may be a petty complaint but I would love to see an official dark mode added, also updating the overall look to make it feel more "2020" instead of "1990" might be nice too.

AR
AvatarImg

Verified reviewer

Computer Software, 501-1,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

SQL server as a platform

Reviewed 4 years ago

2 year and it's going good. I am working as a quality analyst and found it easy to work on SQL.

Pros

It's latest updates are major step to give choices of development, data types and cloud by bringing the power to link with Linux and windows. Adaptive query processing with three new improvements adaptive joines, batch mode memory feedback and interleaved execution for multiple statements is a new generation query processing strategy.

Cons

Hmmm, Cost! Yes cost I can say is freaking hurdle. One needs to be dependent upon Microsoft for their ecosystems which would be costly again. Need big investment for this and they provide updates in 2 year cycle.

AvatarImg
AvatarImg

navjot s.

Computer Software, 501-1,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Best database tool

Reviewed 4 years ago

I am using this software from the day 1 of my so far experience. I learned alot just because of its easiness. This is also very flexible for heavy queries and also for optimization the code.

Pros

Very easy to use and having almost tools for all user actions which save time and good for novice persons. Its best tool is Sql Profiler which you can't find in other database applications.

Cons

Most of the time system hangs when opening the Job's steps detail. This bug is in almost all versions. Also, we can't check the table content in debugging mode of a store procedure, which I alway fancy to must have feature.

JD
AvatarImg

Jelle D.

Consumer Goods, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Fast SQL database engine

Reviewed a year ago

I have great experiences with Microsoft SQL Server, it's reliable and fast, as long as you're able to pay for it.

Pros

Microsoft SQL Server has a lot of functions and does not miss one feature I need in my RDMS. I think it's great software to be used within companies with big databases.

Cons

The software uses a lot of data, doesn't have dark mode support right now and the whole design feels old. The thing I liked the least is the price of the software, it can be very expensive depending on the licensing tier.

AvatarImg
AvatarImg

Jesús F.

1,001-5,000 employees

Used other for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

Extraordinary system to manage relational databases

Reviewed 5 years ago

It is one of the best database management systems, but it is not for beginners

Pros

It has ease of transaction support, in addition to scalability, stability and security, it can include a powerful graphical administration environment, allows working in client-server mode, where information and data are hosted on the server and terminals or clients of the network they only access the information and have a relational database that would allow multidimensional data to be included in the basic database license

Cons

It has a large amount of RAM memory for the installation and use of the software, it has a limit of simultaneous connections for the pages and is tied to the platform of the operating system on which it is installed. Also, it is not very good for beginners to practice

AvatarImg
AvatarImg

Erue D.

Education Management, 201-500 employees

Used weekly for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

fast, safe and just great

Reviewed 4 years ago

sql server is used as the main data base engine for the different administrative management systems, as well as student registration, previously we used another database which did not have the capacity to perform functions such as stored procedures, implementing sql server we could manage other processes directly to the database. we could notice that sql server is the one indicated for local implementations, we have advanced in the maintenance since it is much simpler, the backups are achieved with a few clicks, there is no database engine that has the security that the sql server has.

Pros

- The creation of views, stored procedures, creation and modification of bd and tables, is extremely simple. - the administrator of the management studio database is very complete and can perform many processes in design mode - Multiple functions to improve and enrich queries sql. - Works perfect for large data storage. - The management of user permits is very useful, you can assign different roles and roles in the database. - It is very easy and effective to perform both backups and restorations.

Cons

- Configuring public access to the network can be quite cumbersome. - Restoring databases between different versions can bring compatibility problems - It is very difficult to get online servers that support sql server. - The support for linux is almost nil.

AvatarImg
AvatarImg

Brayan Agostinho D.

501-1,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Microsoft SQL Server logo

Microsoft SQL Server

excellent database manager with a large number of tools for the development of a project

Reviewed 5 years ago
Pros

When developing a project where a large amount of information must be recorded, it is excellent to use a SQL relational database. it allows us to store information in the best way so that the data is not cloned and does not find repetitions of these. Microsoft SQL Server gives us a large number of commands and tools to develop, manipulate, retrieve, create and define data, and can be configured to use multiple instances. includes a friendly graphical environment that allows the use of commands. it allows us to work in client-server mode and supports storage procedures and transactions. can be used to develop complex projects that contain three or more layers without any problem

Cons

This software can consume many resources on computers, such as RAM. causing our equipment to freeze. in relation to quality and price, it has a lot of competition compared to other SQL relational database administrators

AR
AvatarImg

Verified reviewer

Computer & Network Security, 11-50 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Mode is the SQL kit you wish you always had

Reviewed 5 years ago

SQL queries, database lookup, results graphing, BI.

Pros

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.

Cons

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.

AR
AvatarImg

Verified reviewer

11-50 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

Mode logo

Mode

New user beginning in SQL

Reviewed 5 years ago
Pros

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.

Cons

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

RA
AvatarImg

Roarke A.

Transportation/Trucking/Railroad, 11-50 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Mode logo

Mode

Mode Analytics - A Review

Reviewed 3 years ago

I started using mode with no knowledge of SQL or R and was able to learn some of the introductory information through DataCamp and online which has allowed me to get much more value out of Mode. The other platform we use is Metabase which is great for our Customer Care team because it does a lot of (if not all) of the heavy lifting for SQL queries. A few standardized queries or templates for queries might give less knowledgeable people the ability to get more value from Mode.

Pros

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.

Cons

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.

DC
AvatarImg

Dillon C.

Real Estate, 1,001-5,000 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

A brilliant product - period.

Reviewed 3 years ago

Brilliant

Pros

- The SQL tutorial that got me started with Mode. - The user friendly UI - Report tooling.

Cons

There used to be some limitations with graphs, but it seems to have gotten better over time.

AvatarImg
AvatarImg

Nicholas F.

Financial Services, 51-200 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend6/10

Share this review:

Mode logo

Mode

There's a lot it does well, but a lot it does poorly

Reviewed 4 years ago

Great if you're proficient with R, Python, and/or HTML. Also great if your metrics are really simple.

Pros

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)

Cons

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

EV
AvatarImg

Elle V.

E-Learning, 201-500 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

A great data visualization tool and an excellent SQL tutorial

Reviewed 3 years ago

Mode is simple and useful. I especially love its tutorials on SQL. It helps a marketer learn the basic skill in a very digestible way.

Pros

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

Cons

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

JS
AvatarImg

Jane S.

Retail, 201-500 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

Mode logo

Mode

Easy for a SQL noob, but more templates + help with chart building needed

Reviewed 3 years ago
Pros

As someone new to SQL, the error messages are relatively easy to parse and it's really simple to copy and tweak queries and reports.

Cons

The chart building is not super intuitive; it would be great if there were easy templates to use.

AvatarImg
AvatarImg

Bertrand S.

Information Technology and Services, self-employed

Used weekly for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Nice platform for people doing data analysis on a daily basis

Reviewed 3 years ago

Mode platform is a nice tool to process / request Data on a daily basis. It would be a must have for Data scientists / analysts producing analysis / reports for executives / BI teams.

Pros

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.

Cons

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.

DM
AvatarImg

Drew M.

Information Technology and Services, 1,001-5,000 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Mode logo

Mode

Very happy with Mode

Reviewed 3 years ago

For my needs (and my team) it has been very useful to use mode to analyze snapshots of production data to get more insight into problems and to work out the scope of fixes/migrations needed to address issues.

Pros

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.

Cons

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

AH
AvatarImg

Alexander H.

Research, 51-200 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

Mode logo

Mode

Great for sharing data

Reviewed 3 years ago

Mode has improved a LOT since we first began using it in the spring of 2019. The notebook interface is much faster and more stable (it could still be snappier and closer to 'native', but it's much much better), and the plotting abilities are much more flexible and nice to look at. Big props to the mode team for integrating so many useful features and improvements!

Pros

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.

Cons

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

JW
AvatarImg

Jennie W.

Financial Services, 11-50 employees

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Great tool for analyst of all levels

Reviewed 3 years ago

Very positive.

Pros

I love that [1] I could get started very quickly [2] easy to write sql queries [3] but have the option of adding more complex features to build cool dashboards.

Cons

The advanced features are cool, but it takes a lot of time to figure out how to use them. The Mode service team is really good at providing support, but you still need a lot of background to leverage the help they give you.

AvatarImg
AvatarImg

Aaron S.

Internet, 51-200 employees

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

Mode logo

Mode

Love the Python Support

Reviewed 4 years ago
Pros

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

Cons

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.

WG
AvatarImg

Will G.

Internet, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

Great product that keeps getting better

Reviewed 3 years ago

I'm a big fan of Mode. We use it for all kinds of business analysis and operational improvements. Plus, we use the dashboards to run daily meetings and have daily emails sent out with key metrics. I've found the support to be great and you can tell that they're working hard to make improvements every quarter.

Pros

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.

Cons

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.

MR
AvatarImg

Madeline R.

Financial Services, 11-50 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Mode logo

Mode

Mode

Reviewed 3 years ago
Pros

Mode is very easy to use, and it really helps with my day-to-day tasks and projects

Cons

There are some SQL features that aren't compatible with MODE, which has led me to do extra work to complete my queries that could be complicated if that function was available.

MD
AvatarImg

Mario D.

Cosmetics, 201-500 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Mode logo

Mode

Good for operative reporting but not as well as bi tool.

Reviewed 3 years ago

Small companies without any reporting tool is good to start.

Pros

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.

Cons

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.

AC
AvatarImg

Adrian C.

Computer Software, 1,001-5,000 employees

Used monthly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Mode is great :)

Reviewed 3 years ago

I love using Mode to find hard data to support theories. It helps me make a case when I want to change or present something we need to work on in our team. I also build software tools for our team, so it is useful to have Mode data to backup cases for new changes / tweaks to our software.

Pros

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

Cons

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

JV
AvatarImg

Joseph V.

Computer Hardware, 51-200 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

Mode was a game changer for us, but some aspects remain hard to use

Reviewed 3 years ago
Pros

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.

Cons

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.

NA
AvatarImg

Nathan A.

Internet, 11-50 employees

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Reliable, easy to use software.

Reviewed 3 years ago
Pros

Mostly reliable, queries run quickly and efficiently over large data sets. Easy to put together charts quickly SQL and Python support in one place is great - no need to export .csv files into a jupyter notebook all the time

Cons

charting options can be limited sometimes, and I don't always have the time to put something together in python. pivot tables are AWFUL, just get rid - it's not even worth offering them

MC
AvatarImg

Mike C.

Sports, 51-200 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Solves the problems we need it to

Reviewed 3 years ago

Mode clearly cares about the success of their users with their product and it’s shown in the features of the offer and the support that they have. Mode has helped us eliminate the need for a two or three step business process by allowing us to set up SWL reporting for any college to run, as required. This product is worth exploring if you have a team that needs data to be run re time or on a scheduled basis in order to provide insights that will help them with their day-to-day activities. Reporting that is real time or on a scheduled basis in order to provide insights has been helpful in streamlining day-to-day activities that are data dependent.

Pros

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.

Cons

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.

SA
AvatarImg

Samuel A.

Fund-Raising, 1-10 employees

Used weekly for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

SQL Editor + Python Notebook

Reviewed 3 years ago

I've used Mode to query our databases to investigate basic questions such as revenue generation from each stream of income, drop in user engagement, average cost of client

Pros

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.

Cons

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.

AR
AvatarImg

Verified reviewer

Information Technology and Services, 1,001-5,000 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

Mode logo

Mode

"Mode Analytics Review: A Comprehensive Look at the Data Analysis Platform"

Reviewed 25 days ago

"Overall, Mode Analytics is a powerful tool for data analysis, with the ability to connect, analyze and visualize data from various sources. The SQL-based interface allows for complex queries and advanced analysis. However, the learning curve can be steep, and the pricing can be expensive."

Pros

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

Cons

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

AvatarImg
AvatarImg

Rohan V.

Transportation/Trucking/Railroad, 1,001-5,000 employees

Used daily for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

Mode logo

Mode

Internship Experience: Smooth and Exciting

Reviewed 2 years ago
Pros

It was intuitive and, as an intern that wanted to use a technology that was modern and capable of accomplishing great work, allowed me to achieve such goals of high productivity with maximum output. My ability to integrate Python, SQL, and HTML/CSS into a unified yet personalized dashboard that scaled well with the amount of data queried led to a product that accomplished our project goals without much technical problems.

Cons

Many incredible features are hidden behind a paywall, which is of course the purpose of a paid subscription but causes many users that can't/don't pay to miss some of the best aspects of the software.

NA
AvatarImg

Nathaniel A.

Computer Software, 1,001-5,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

Mode logo

Mode

Mode is a powerful tool for your business

Reviewed 3 years ago

10/10 we couldn't have run our business without it. All of our production reports and alerting happen through Mode and it hasn't ever let us down. Mode works great with other tools in its space and fits nicely in to the modern data stack. Two thumbs way up from our team.

Pros

- 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

Cons

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.