Quantrix: What Excel Should Have Been
February 13, 2018

Quantrix: What Excel Should Have Been

Jason Klinghoffer, CFA | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Quantrix

Quantrix Qloud is being used a client portal for our institutional fixed income accounts that need access to a wide array of custom analytics for solving problems along the portfolio management decision chain. This includes analytics for modeling cash flows and liquidity needs, strategy development, performance evaluation, portfolio reporting, historical tracking, credit analysis and much more. Quantrix solves an amazing number of problems from the ease of creating custom analytical models to the deployment of a professional enterprise level web-based interface that makes life for our clients incredibly easy.
  • Develop robust, data intensive models with minimal (relative to competing alternatives) formulaic or coding infrastructure.
  • Handle large data sets Excel could only dream about.
  • Professional Qloud environment that only gets better and better. Deliver model output with professional design and customized canvases to deliver a truly unique experience to end users.
  • Qloud administration allows control to specific models and data within models to keep users of all different levels and access authority seeing only what they are supposed to see.
  • Quantrix support team is second to none. They go out of their way to answer questions and find solutions to even the toughest problems in a timely manner.
  • Hard to be critical of the Quantrix team as I know they strive to produce the best product possible. I suppose the next thing on my wish list would be the application of the new Solver functionality to be available in the Qloud.
  • A big help for new users would be a good book on transitioning from Excel or other environment into Quantrix. I know first hand it can be difficult to transition when having to learn the program through a help guide, forums and tech support. I had a lot of trial and error in my journey to producing the desired models. On one hand it was a valuable method as it taught me a lot of what not to do, but I will admit it was not the most efficient way to do things.
  • Would also love to see local user groups being formed at some point in the future. Quantrix puts on a fantastic conference once a year in beautiful Maine, but it is a big journey for someone in Southern California (and limited to one or two days a year). I would like to see some local chapters formed in different areas of the country so local Quantrix users can get together more often and collaborate (maybe a quarterly or semi-annual meetup?). Our Quantrix community is still relatively small and may be a difficult task for some areas, but is also the very reason why this would be great idea.
  • 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.
Excel..think I beat this one to death already. Great for smaller datasets and simple analytical tasks, but difficult to compare to Quantrix when it comes to complex data modeling efficiently.

Tableau - Have only dabbled with it, and it has a great interface and produces some attractive output for sure...but don't think it has the same calculation library, dimensional relations between data and ability to manipulate underlying matrices. Quantrix has built in a feature to link your data to Tableau so you can now use your Quantrix Data and visualize it in Tableau. Given our use of the Qloud as a client interface, Tableau doesn't make a lot of sense for us (though I wouldn't mind having some of the visualization power it brings to the table).
I would recommend Quantrix if the person is trying to create solutions involving large data sets, complex outputs (traditionally complex formulas, output derived from inter-related or dimensional data), or needs advanced canvasing ability to create custom outputs with a wide array of custom charts, tables and scripting to choose from.

I still use Excel for basic tasks such as data aggregation or simple calculation tasks (such as finding the weighted average of some subset of data), but the minute the solution moves into more complex territory I move to Quantrix models. There is just hands down no better way to create more complex solutions as efficiently or as appealing as Quantrix.

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
Not Rated
Minority Ownership
Not Rated
Local and consolidated reporting
10
Detailed Audit Trails
Not Rated
Financial Statement Reporting
Not Rated
Management Reporting
9
Automated board and financial reporting
Not Rated
Personalized dashboards
9
Color-coded scorecards
Not Rated
KPIs
Not Rated
Cost and profitability analysis
10
Key Performance Indicator setting
9
Benchmarking with external data
10
Flat file integration
9
Excel data integration
9
Direct links to 3rd-party data sources
9