Why and When to Use Zoho Analytics, Instead of a Spreadsheet Software Like Microsoft Excel.

• You can enter data right away or copy-paste data
• Connectivity to Access, SQL Server, OLAP server and any ODBC connected data sources
• Import from XML and Web URL sources

Summary: Offers a reasonable set of options to input data.

• You can enter data in a 'spreadsheet-like' interface. Easy embedded controls for fast data entry like calendar etc.,
• You can copy-paste data too
• Import from CSV, TSV, XLS or HTML files
• Tool to pull data from MS Access, SQL Server, Oracle and MySQL databases and upload the same into Zoho Analytics.
• Import data from Web URL. Also, scheduled periodic imports can be setup.
• Command line tool for batch uploads and to push data from other applications/database.
• Web API to push data from your application. Also create custom forms to submit data using API.

Summary: Offers a wider and more functional set of options to input data.

• Wizard based report creation predominantly
• Applying functions and formulas over data is possible, but needs extra clicks and steps
• No drill-down capability to explore the data
• Creating multiple reports over the same data, somehow ends up in bifurcating the data or duplication.
• In multi-user setup, same data set (sheets) viewable by everyone to create reports. No easy model for sharing a subset of data for report creation without duplication

Summary: Basic reporting and analysis is easy to do. More powerful and advanced reporting/analysis becomes complex.

• Intuitive drag-and-drop based report creation and analysis.
• Visually analyze data instantly instead of opening up wizards for every minor change you would like to make
• Easy to filter data relevant to a report, again through drag and drop. Also powerful filters are possible through logical operations and functions/formulas support
• Applying functions/formulas is just a click.
• Drill-down reports to view the underlying data
• Create data subsets (with necessary filters applied) and share to users according to their necessity and privilege. This enables them to analyze and create reports only on the data set shared to them.

Summary: Complex analysis of data and powerful reporting is easy to do.

• Basic querying can be done with filters
• Advanced querying or filtering can be done using Macros.
• Pulling (Merging) data across sheets is a complex task. Not easy to create and maintain.

Summary: Merging and querying disparate datasets is difficult to do.

• Most of the querying and filtering can be done through the drag-and-drop interface
• Easy to pull (or join) data across tables to create the necessary reports
• Supports standard SQL (Structured Query Language) for complex querying

Summary: Complex querying is possible as it supports SQL.

Note: A Visual Query Builder is also in the pipeline.

• No support for Automated analysis and report creation. Every report or analysis has to be done manually.

• Supports Automated Analytics, which applies an advanced rules engine based on predefined rules to scan your data and generates reports automatically. These reports can be customized later.
• Cuts down time on analysis and report creation. Makes you more productive.

• Spreadsheets are built for one person
• You can email copies of a spreadsheet to other users
• Conflicting modifications done are to be synced manually, which is error-prone and tedious. Maintaining single version of truth is a great challenge (can even be an impossible task).

Summary: Sharing and collaboration is difficult and error-prone.

• Easy to share a view to users who have Zoho Analytics accounts. Only on login, users can access these views.
• You can even share views to anyone (general public)
• The same (and latest) version of reports and data are visible to everyone. Naturally, this takes care of conflicting modifications.
• You can share reports and data with fine-grained permissions like Read-only, Read-write, Data Export, etc.,
• Revoke sharing permissions anytime

Summary: Being online, sharing and collaboration becomes much easier.

Know More ...

• Limited support for Export formats.

• Supports Export as PDF, CSV, PNG, JPEG and XML formats
• Also use Web API for exporting data in different formats.

• There are no direct publishing options, to have the data and reports in a spreadsheet hosted in your blog, web pages etc.

• Embed all your reports anywhere (your blogs, web pages or intranet or SharePoint etc.,) as widgets
• Embedded reports are always live and up-to-date
• Always serves the same version. No duplication

• Each sheet in a workbook is independent
• Very hard to associate relationship between data which can naturally be linked
• Pulling (Merging) data across sheets which are related is a complex task. Not easy to create and maintain.

Summary: Difficult to define relationships across different data sets.

• You can relate columns in a table with other tables with the use of Look-up columns
• Helps you ensure sanity of data when related data are removed from the system
• Easily join related data for necessary reporting and analysis

Summary: Defining relationships across tables is easy.

Know More ...

• Data security is just one level. You can password protect your spreadsheet.
• You cannot segment data and reports and share it to multiple users with the necessary privileges and without duplication.
• Spreadsheets are available in the local user machines and prone for easy data loss/theft etc., (it's too easy to copy or delete!!)

Summary: Securing data is hard to achieve and is almost impossible.

• Data and reports access is protected with proper user name and password
• Only shared reports and data are viewable to the respective users
• Permissions can be controlled while sharing to users (like read-only, read-write etc.,)
• All users work over the same copy of data. No duplication.
• User data is hosted in secure, redundant server grids.

Summary: Your data is with professional hands and hence safe.

Also check out Zoho's Privacy Policy

• Excel 2007 can support up to a Million rows in a sheet. Previous versions support upto 65K rows in a sheet
• As data grows, sluggish responsiveness will become an issue, since every processing has to be done in your local machine.

Summary: Sluggish responsiveness when dealing with larger datasets.

• Evaluation edition supports upto 500K rows in each table.
• Support for millions of rows in a single table
• Processing is done on a powerful server grid (server farms) and not in local user machine. This ensures performance and scalability to support hundreds of users simultaneously.

Summary: Quick responsiveness even for very large datasets as the system is designed to handle huge volumes of data.

• A spreadsheet is designed to be a personal productivity tool. As long as the data and reports are handled by a single person, things are fine
• Multiple users working on the same data, reports and analysis, results in conflicting modifications. Syncing becomes error-prone and very tedious. Also, maintaining a single version of the truth is a great challenge. This affects Data Integrity.

Summary: Data integrity is hard to achieve.

• The same (and latest) version of reports and data are visible to everyone through online sharing (no duplicate copies). This naturally takes care of conflicting modifications, thus enforcing data integrity and consistency.
• Relational Modeling support also enforces data integrity. More...

Summary: The underlying design takes care of data integrity (single version of truth) by itself.

• Accessible from your own machine
• Email the spreadsheet or put it in shared repositories for wider access. Duplication & synchronizing is always a problem

• Available On-Demand
• Accessible from anywhere on the globe through the Web

• Per installation cost for each desktop requiring spreadsheet
• IT maintenance cost for upgrades and security patches

Summary: High licensing and maintenance costs.

• Monthly subscription
• Liberal free edition ($0) to take care of most of your basic requirements
• Unsubscribe anytime you do not require further usage
• Accessible with just browser from anywhere.
• No software installation required in any machine

Summary: Affordable monthly, pay-as-you-go subscriptions.

Note: Check out our affordable pricing plans.