Likelihood to Recommend If your company is really small, I can understand the need for a product like this. However, I would go for MS Access... FileMaker Pro can not be integrated with other systems (like MS Access can at least be handled by C# for instance, and can be integrated with MS Excel or even SQL server). I'm really not sure in what scenario one would choose for FileMaker Pro. If your application or company grows bigger, you're going to have a problem to move to another environment. Also, the fact that only one person can work with the backend at any given time is a problem in a somewhat larger company.
Read full review For tasks like financial analysis, budgeting, forecasting, and data visualization, I frequently use Microsoft Excel. I can develop financial models, use pivot tables to examine enormous datasets, and produce eye-catching visualizations thanks to its comprehensive features. I have, however, also come across circumstances in which Excel isn't the best tool.Excel falls short of alternatives like
Google Sheets when I need to collaborate with my team in real-time. I favor employing robust database management systems or data analysis tools like SQL, Python, or R for managing very big data sets or sophisticated calculations. I use specialized tools like SPSS, SAS, or programming languages for better outcomes when complex statistical analysis or machine learning are necessary. And finally, for formatting elaborate reports, In conclusion, even though I consider Excel to be a great tool for many finance jobs, there are some limits in collaborating, processing big amounts of data, performing complex analysis, and creating documents that I take into account when choosing the best tool for the job.
Read full review Pros The relational database management system makes the program highly customizable to fit the needs of any product. You can add a ton of information to each record and update your inventory on a regular basis with an Excel import or manually inside of the record. It has the capability to incorporate barcoding, which can manage your available inventory with ease. The scripting language allows FileMaker to automatically calculate complex algorithms automatically or generate report outs with the click of a button. This allows for greater UI, especially with active users who are not familiar with writing code. Almost all of our internal data is linked to the FileMaker database The server license allows many users to update the database in real time, which is handy if your inventory is constantly changing. We have users with Macs, PCs, iPhones and handheld tablets linked to our FileMaker database and they are updating the information constantly throughout the day. If you invest some time into formatting and scripting the database, there is a high ease of use for users without knowledge of any programming or FileMaker itself. Read full review 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. Gary Ceder Managing Director - Transaction Advisory
Read full review Cons Developer features need to be beefed up - namely adding the ability to search code for a phrase or keyword and the ability to do the same in the "relationship graph" in the database. Add ability for users to edit the same table record at the same time by version control. Allow Filemaker Server to use more than 1 core; currently multi-processing is not supported and it can be tricky to find just the right server to support the application you've built to the fullest capacity. Read full review Counting conditionally formatted cells (e.g., you have 5 green cells, 10 red ones, and 3 orange ones in a row). Merging cells in a table; I have to remove the table first and then re-add the table to merge cells together. Offering more preset colour categories for formatting graphs. Built-in functions to run ANOVAs, Multiple Linear Regression, Factor Analysis, etc. Read full review Likelihood to Renew It it not really up to me but my opinion does have some weight in the decision and the reason I would renew my use FileMaker Pro 8.5 is because I am finally getting used to it! Now that I have been working with the program, tasks have become quicker and projects are getting done faster. File Maker Pro 8.5 really is a versatile tool and I think we are just scratching the surface with it's abilities.
Read full review It comes with MS Office. Unless we stop using PCs or Microsoft Office, it's highly unlikely, even imperceivable to not continue to use Excel. It would be nice to see more Excel functions used, though, beside basic tables and calculations.
Read full review Usability The usability rating I'm providing is for the development interface - the usability of the application you build is relative to how much effort is put into the application. Filemaker needs to roll out some features that are "modern" sooner rather than later. They do roll out new features every year, but at a slow pace. We generally get 1 new TRULY useful feature every year. They need to step it up some!
Read full review Microsoft excel stands out in its User Interface as compared to any other software which offers same functionality. It can be used by a beginner as well as the expert in the same field. It is having many features as we dig deep in it like advance functions, dynamic arrays, pivot, VBA and Macros.
Read full review Reliability and Availability I have rarely, if ever, had issues with its availability.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Performance Again it does what I need it to do with little to no issues.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Support Rating The forums are great with lots of helpful experts and the staff monitor them to provide help where needed. There have been a couple of unique technical issues I've had to deal with that I haven't been able to get resolved so I chose to score this a 9 instead of a 10.
Read full review I have not had to use it often, but it is good.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Implementation Rating Suggest you use an iterative R.A.D. or AGILE development approach. (i.e. rather than writing a gigantic spec for a system, then building it). FileMaker facilitates quick prototypes. Developing an example, then allowing users to "try it out" is a snap.
Read full review Alternatives Considered FileMaker is still the quickest way to go from zero to having a minimum viable working solution. Simple solutions can be built in as little as a afternoon of development. It is the only tool I am aware of which allows tech savy end users with domain knowledge to build bespoke apps for their businesses without undertaking professional software development training.
Read full review We utilize
Tableau and
Alteryx in addition to Excel. We use Excel since we have a data dump that could be utilized in feeding for these two solutions. We select Excel for some manual work then plug the data into the other two tools for further analysis around text analytics like word clouds in
Tableau , or text mining in
Alteryx . Excel is an input data source that we use in conjunction with these two.
Read full review Contract Terms and Pricing Model N/A I was not involved in this process.
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Scalability It integrates well with all cross functional teams
Mike Baucom Project Leader/Marketing Professional Commercial Truck Marketing
Read full review Return on Investment We are a more agile company because of FileMaker. A few of us who are tech-savvy enough to manage the database (but are not professional developers) can make needed adjustments to our database without having to employ an in-house developer or contract with a 3rd party. As our business processes evolve and change, it's easy to update the database to accommodate those changes. Read full review 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. Read full review ScreenShots