Quantrix

Quantrix Modeler is one of the most appropriate software tools for developing dynamic financial planning models in small teams composed by skilled power users. There is an also Enterprise version supporting larger user bases and stronger integration with company backend systems. It's not advisable to put Quantrix desktop application in the hands of non-skilled staff since the learning curve is much steeper than what's the typical experience with spreadsheets. Adding a table with ad hoc simple calculations can be done by anyone in a spreadsheet, but requires knowledgeable design in a Quantrix model. On the positive side, experience with students in our classes shows that with focused training an user can be become productive in a relatively short time. There is a web version of Quantrix Modeler, Qloud, that is aimed to end users that only modify input data and consume model results, without the possibility of changing the model logic (structure and formulas)

Incentivized

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

• Quantrix was able to free the definition of calculation rules from cells. It would be interesting to be able to separate the default template structure from changes when importing data.
• Just to be clear to prevent the import (example from a CSV or DB) the creation of new items in addition to those already existing.
• An import navigation by level would be interesting. Or to obtain a split of the number on a tree structure (I bring as an example that of Corporate Planning (https://www.corporate-planning.com/de/).
• As a further enhancement of the above, it would be interesting to be able to define reports like an explosion of a tree structure.

For a newbie it can be difficult until you get the hang of the system. Quantrix is a very logical system, once you understand its underlying ideas.

Microsoft Excel, Infor, Tagetik, Palantir Quantrix is not ready to use budgeting and planning tool, it is basically data modeling tool. That makes Quantrix different. You yourself or with help of consultant create model according to your specific business needs. You will get cost-effective, tailored solution. It is a modeling tool that allows the easy and quick creation of multiple scenarios, conducting “what-if” analysis to accommodate uncertainty associated with forecasts.

• Quantrix has boosted profitability and has proven its worth time and again. The platform has put us on the radar doing things even our biggest competitors could only dream of. We are still early in the development and deployment of our Quantrix Qloud based system to clients, but we already have early adopters coming over from competitor systems that cost exponentially more and do significantly less than what we provide. We feel it is only a matter of time for our Qloud driven analytics to become more mainstream in our space.