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

Rich Lopez | TrustRadius Reviewer
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.

Pros

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

Cons

  • 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!
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.
Anything you do in Excel you can do easier (maybe not initially as there is a learning curve), better, and more effectively in Quantrix. If there is a repeatable process that requires updates to data then Quantrix is the solution. If you need something that does highly complex structure, organization, and summarizing of data Quantrix is the answer.

Quantrix Feature Ratings

Long-term financial planning
10
Financial budgeting
10
Forecasting
10
Scenario modeling
10
Management reporting
10
Financial data consolidation
10
Multi-currency management
10
Minority Ownership
10
Local and consolidated reporting
10
Detailed Audit Trails
10
Financial Statement Reporting
10
Management Reporting
10
Automated board and financial reporting
10
Personalized dashboards
10
Color-coded scorecards
7
KPIs
7
Cost and profitability analysis
10
Key Performance Indicator setting
10
Benchmarking with external data
10
Flat file integration
9
Excel data integration
6
Direct links to 3rd-party data sources
5

Comments

More Reviews of Quantrix