Quantrix Best Business Decision Ever for Any Type of Modeling Traditionally Done in Excel
February 14, 2018
Quantrix Best Business Decision Ever for Any Type of Modeling Traditionally Done in Excel
Score 10 out of 10
Vetted Review
Verified User
Overall Satisfaction with Quantrix
We use Quantrix exclusively to budget and forecast our financials top to bottom. We use Quantrix on the manufacturing side of the business to model throughput capacity, production forecasts for SKUs, and most recently for product wheels.
- Quantrix gathers info from numerous sources in a single click. Thereby making structure to process sustainable and scale-able. Once the logic is written the data refreshes and you are good to go with furture analysis and planning. There is no need for rework, copying down formulas, etc. In our latest product wheel build process we reduced our time from 3 weeks of time to 2 days to build out product wheels. There was a sharp contrast between Excel ( previous method) and Quantrix.
- Quantrix links perfectly to SQL Server which allows us to get actual data quickly, push out forecasts or other data for other systems to consume.
- Quantrix range based formula writing and common term formulas are a HUGE time saver. Debugging formulas is a breeze in Quantrix using what is called the dependency inspector. There is no need to copy down formulas; make sure cell ranges are locked etc. It is one formula controlling a multitude of cells that scales as the data set shrinks or grows. Also if there is an error in the formula you have 1 formula to fix not hundreds or even thousands. Common terms in your formulas helps immensely and reduces the amount of headache of debugging your formulas.
- Quantrix Scales with ease. Adding additional data or shrinking the data does not require (manual) structure updates to Quantrix. It accordions according to the data imported. Pivoting data and looking at it as well as filtering it and then building off of those filters and pivots is a joy to do in Quantrix!
- Complexity - Excel does not have it! Where the vlookup ends in Excel the Quantrix Select statement is just warming up. Functions like: Select, Selects, SelectList, SelectGreaterThan, SelectBetween, SelectLessThan, and one of my new favorites SelectLike in addition to CASE and Switch Logic make Quantrix a dominating force when it comes to writing complex logic in your business model. Quantrix does is beautifully.
- Find and Replace feels like it is from 1990.
- Filtering. The filter tray is excellent, but filtering on a two dimensional data set is a bit cumbersome.
- The DataLink Wizard needs to no longer be a wizard, but a single screen with every tihng I could ever want in regards to data connectivity at my fingertips (much like Tableau in that regard).
- Qloud. The function and look of this offering seems a bit clunky. I don't use it much because it seems a bit clumsy.
- Budget Process now takes a handful of weeks instead of 3 months.
- Reduces work on monthly journal entries from 16 hrs plus to < 10 minutes.
- Turns lights on for capacity modeling. Capacity model used to take 1 week to update with no scenario capabilities. Now using Quantrix it takes minutes with the capability to add scenarios!
- BizNet Excel Suite and Microsoft Access
These are traditional spreadsheet-based software packages. Any trouble you have with Excel you have with these, but that is eliminated with Quantrix. Quantrix is an Excel/Access like application, but so much better because of the things I've previously described in this review.