Stop struggling with
spreadsheets
Separate Structure from logic
Create models free from the burden of having to worry about the impact of the changes you make. Formulas will automatically update to reflect new structure.
Better model performance
Our real-time, in-memory, proprietary Java-based technology is proven across thousands of deployments, and trusted by some of the world’s largest organizations
Import and Export Data
Built in data import and export functionality ensures that you can always connect to the most current data and update it with a click of a button.
Natural Language Formulas
Intuitive natural language formulas ensure users’ existing Excel® skills are transferrable, easing user adoption and eliminating the need for technical coding skills.
Always-on Pivoting
The power of pivot tables except always at your fingertips. Quantrix’s always-on pivot engine means you can pivot and summarize your data (including calculated fields) at any time – without having to re-write logic! You can write formulas in any view of the data and immediately pivot to see the result in a new way.
Range based formulae
Traditional spreadsheets use cell addresses — such as B2 for column B of row 2 — rather than meaningful names — such as Revenues or Expenses. Anyone who has tried to read such formulas, whether written by someone else or oneself, knows how hard they can be to understand or verify. Quantrix provides the most flexible modeling expression based syntax, allowing you to specify multi-dimensional slices of data, taking your analysis far beyond Data Analysis Expressions (DAX) and other similar paradigms.
Quantrix’s natural language formula engine means you can write formulas referring directly the structure itself meaning that modifying a name will update all formulas for consistency – and more importantly one formula can calculate hundreds, thousands or even millions of cells. With user features such as formula syntax highlighting and automatic type-ahead, writing and debugging formulas has never been easier!
Category linking
One of the most powerful concepts within Quantrix Modeler is the ability to link common structure. Being able to keep your lists of items in sync across a model or even across a set of models means adding or changing a product, region, scenario or year is as easy as a single click – no more trying to track down every reference when making edits!
Visual Dependency Inspector
Our cutting-edge dependency inspector allows users to focus in on the logic driving a model. With a single click, interrogate the logic driving a particular value, see the values passed into the arguments with formula breakdown and finally; visualize and navigate to the dependencies for a clear picture of the data flow.
Interactive Dashboards
Often the users of your model only need to access certain parts of the model such as assumptions and results. Using our interactive presentation canvas you can easily organize multiple tables and charts, onto a free-form dashboard to give users a simple interface in which to interact with a model. You can add tables, charts, built-in widgets, expressions, custom scripted actions, logos and branding to get the exact experience you users require.
Separating the presentation from the structure and logic of the model allows you to model freely and efficiently without worrying about the final layout.
Groovy Scripting
Using the built in scripting language Groovy, you can manipulate Quantrix data structures to perform common automation tasks. Adding buttons and logic to a user input is clean and easy. With the ability to import/export scripting libraries, you can cut down on the amount of code you need to maintain.
See Pricing for Quantrix Modeler
Request A Free Trial of Quantrix Modeler