Grist vs. IBM Informix vs. Microsoft Excel

This is well suited to someone (or a team) who are technically minded and have a dataset that they need to be able to use in many ways. It's less appropriate for a team who isn't technically minded and/or don't have the data they need to manipulate. It would be useful for things that you could use a database or spreadsheet for such as CRM, Advertising database, Business tracking, Health tracking etc.

Incentivized

IBM Informix creates an effective and secure channel for easy and quick data management and transfer across other major Cloud platforms and other data storage systems. The analytical ability is also the best and most effective visual functionalities and the encryption and the data archiving functionalities are great and easy on reporting.

Incentivized

I don't really know another program as powerful as Excel. I've used Google Doc programs but do not feel they come close. So far, anytime I've needed a table of some sort for data, whether it's budget oriented or information off a survey, the best system has been Excel. We do web audits on occasion and we create an Excel worksheet featuring every URL of the pages we're auditing, notes, data about the content, information about files attached to the page and other information to help us determine what pages need updating, deleting or otherwise. We also use Excel primarily to export our Google Analytics to in order for us to create reports for clients that need to see specific information about their traffic.

Incentivized

• Provides amazing customer service, help, examples, and explains what they are having you do
• The layout is easy

• Industry leading OLTP performance.
• Excellent Data Warehouse performance from the basic engine. Outstanding Data Warehouse performance from the Informix Warehouse Accelerator module.
• Best embedability among major RDBMS systems.
• Scalable from the smallest Raspberry PI up to the largest monolithic systems and out to dozens of distributed nodes.
• Hybrid data capabilities to merge relational data with time seriesv, geospacial data, JSON data and other non-traditional data types with performance comparable or better than systems dedicated to those data types.

Incentivized

• It is very good at embedded formulas and tying cells to one another
• It allows me to compare deals terms on a side-by-side basis and talk my clients through it easily.
• It is very helpful as well in terms of allowing me to filter/sort results in many different ways depending on what specific information I am most interested in prioritizing.

Incentivized

• Making the user permissions more obvious on how to use them - They are highly adaptable, but hard to understand how to use them
• Small changes such as auto colouring the choices/toggles options and being able to edit them once set.
• Being able to copy the formatting from one column to the next

Incentivized

• It is very difficult to find a missing functionality in Informix, technically is great. I will again criticize the business side and how it has been managed over the past, I hope this could be improved with HCL's help. I know they are working hard, but we need to start letting the world know and revert their concept about its existence and that it is one of the best competitors within the data treatment, in the market. We need to start telling the world about success cases and stories showing this and backing up its strong technology.

Incentivized

• Excel offers collaboration features that allow multiple users to work on the same spreadsheet, but managing changes made by different users can be challenging. Excel could improve its features by offering more granular control, better tracking of changes, and more robust conflict resolution tools.
• Itcan be a barrier to productivity when importing and exporting data from other applications or file formats. To improve its features, it should offer better support for standard file formats and more robust error handling and reporting tools.
• Excel can be challenging for finance students and working professionals, but it can be improved by offering more robust tutorials, better documentation, and more user communities and support forums.

Incentivized

Informix is the best RDBMS on the market. Period.

Incentivized

Excel remains the industry standard for spreadsheets and has maintained simple and straight-forward formula writing methods. Although there is a learning curve to do more complex calculations, there are countless help sites and videos on the Internet for almost any need.

Incentivized

Server management is easy enough to be able to embed the engine in a device and let it run for years without maintenance.

Incentivized

I'm giving it a 7 because it is my go to. But the fact other prefer Google Sheets when working with a team does get irritating. I've used the online version of Microsoft Excel that other teams can get into and it still seems behind Google Sheets. It's a little clanky and slow? If that's even a term.

Incentivized

I have rarely, if ever, had issues with its availability.

Incentivized

Excel load and performs calculations immediately. It integrate well with all Microsoft Office applications and does not slow them down.

Incentivized

The Informix product support team has won awards and is appreciated by the entire Informix user community.

Incentivized

I have not had to use it often, but it is good.

Incentivized

Grist is easier to use, faster, and loads quicker with heavy data.

IBM Informix creates effective solutions for big data extraction and data transportation functionalities across the entire Cloud services and the Automation ability is the best. The security that IBM Informix provides for all our business data and other project information and contacts is effective and the reports are very clean and easy to understand.

Out of Microsoft Excel, Microsoft Power BI, IBM SPSS, and Google Sheets, Microsoft Excel is by far the most common tool used for anything data-related across organizations. Accordingly, our organization has also implemented Microsoft Excel as a first-step tool. We recently adopted Microsoft Power BI (the free version), and use it occasionally (mostly for creating dashboards), but it is less commonly understood by stakeholders across our organization and by our clients. Accordingly, Microsoft Excel is more user-friendly and because of its popularity, we can easily look up how to do things in the program online. Google Sheets is a comparable alternative to Microsoft Excel, but because it's cloud-based and we have sensitive data that needs to be protected, we chose against using this software. Finally, a few users (including myself) have access to and utilize IBM's SPSS. For my role, it's a helpful tool to do more rigorous analyses. However, because of its cost and limited functionality as a simple spreadsheet, we only use it for more complex analyses.

Incentivized

N/A I was not involved in this process.

Incentivized

Each user can use it to whatever level of expertise they have. It remains the same so users can contribute to another's work regardless of whether they have more or less expertise

Incentivized

• It's saved a lot of time in both creating an advertising database and managing it week to week effectively. I had previously created in others that haven't worked, and this does, saving me a good 1 hour weekly, and 5 hours or more each time I had problems with the last ones
• Being able to stay on track with this has meant I'm following up at the right time (advertisers) and keeping a professional manner and not losing business due to missed communication
• Saving me $ from buying a program like Access (or Airtable monthly) and then the learning curve that that has. This has a much easier learning curve to say the least.

Incentivized

• Although I do not own nor have visibility on my company's figures:
• Informix generates consistent savings on DBA staffing, no need for many DBAs as other DBMS require.
• The replication architecture allowed consistent savings in the infrastructure as well as developments and maintenance, the job is already done, no need to develop complex and costly solutions, it's just a matter of configuring it.
• The advantages of hybrid development (i.e mixing SQL and NoSQL in the same database) is not just a marketing hype: it allowed us to solve with a brilliant solution, in one afternoon of coding, a functional problem we have been having for more than 10 years!
• The biggest drawback is that IBM pricing may be constraining, it has too important gaps between the mid range and highrange in terms of pricing

Incentivized

• Excel has positively impacted the business as it has increased our efficiency.
• It also saves us the time that we would have spent on making the calculations that it does for us.
• Since it works on all devices and is compatible with both Windows and Mac, we do not have to invest in any other alternative.