Skip to content

Everyone’s thinking about your customers, but who’s thinking about you?

Whilst attending Finovate earlier this month, I noticed a lot of focus on consumers, as companies considered how to make previously tedious tasks simple for end users. Despite this, I couldn’t see how the back-office processes behind these offerings were being made any easier – it seems like the hard work behind the scenes still isn’t streamlined.

Although it was exciting to see how the future of Fintech is taking off rapidly, there must have been someone in the room who was wishing that their job of modeling the growth of these new technologies, sales and investments could be made easier?

As Greg Palmer said in his opening remarks – Fintech really is global (Region). Not only this, but the companies going through the launch process of either a new app or service offering, would have had to look at the timescales and finances against this to ensure success (Time). Additionally, there usually isn’t one idea on the table in development meetings – it’s usual for several variances to be considered (Products). It’s also likely many of these variables were backed by teams, external consultants or even investors (Personnel). When you then take a deeper look at the finances of the launch, including the income required to become profitable; the cost of sale; your outgoings and many more (Line Items), you can be faced with quite a complex array of scenarios.

The words in italics are not mistakes or even notes to remind me what to write. I wanted to highlight the fact the world we live in consists of many dimensions. There is huge complexity when putting these factors into a financial model using a traditional spreadsheet. Notice how, even with what could look like a simple project, I have easily outlined five dimensions of the model.

I believe that Quantrix really could be the missing puzzle piece for many innovative companies, like those who attended Finovate. Quantrix helps simplify, accelerate and perfect the modeling process behind the scenes as well as creating ‘what-if’ type analyses. Because modeling is now very multi-dimensional, we must adapt to the requirements of our users to make their lives easier. After all, who doesn’t want that?

If you want your modeling processes to be best-in-class, download a free 30-day free trial and explore the benefits of Quantrix Modeler or get in touch.

Quantrix Delivers “Incredible Value” for the Astound Commerce Performance Management Solution

Anyone who spends enough time with data understands just how much is involved in turning it into valuable and actionable information. For Astound Commerce, the choice to deploy Quantrix Modeler as part of its comprehensive performance management solution means it now has a true decision support system that enables its business professionals to spend less time on the data, and more time using it to run the business more effectively. And it opens up the opportunity for the company to extend the solutions it delivers to its customers.

alex-bw

Alex Nisenboim Technical Architect Astound Commerce

Based in the San Francisco Bay area with offices around the world, Astound Commerce offers strategies, tools, creative services and The Astound Way process to help some of the world’s most recognizable brands create an enhanced digital shopping experience for their customers. In addition to multiple offices, it had numerous systems it used to manage its global business, including financial transaction records, resource management, HR, and more. “We had the classic set up of systems that weren’t connected,” says Alex Nisenboim, Technical Architect, Astound Commerce. “The challenge of analyzing the data was formidable. We needed a comprehensive solution.”

The first step in building the business intelligence stack for the company was to create a single data warehouse. It invested the time and resources required to perform a major extract, transform, and load (ETL) process to create a unified, coherent data warehouse that would provide a trusted data source for BI modeling. But once the data was ready, which tool would deliver the best platform for data modeling, forecasting, and financial insight? “Most tools put the emphasis on data analysis and exploration. They don’t recognize the value of something like a well-formatted P&L,” says Nisenboim. “But Quantrix has data exploration, visualization, and financial formatting working together in something that resembles a spreadsheet environment. We can produce reports that people understand.”

astoundProviding data-driven answers to business questions is the holy grail of business intelligence. Astound Commerce uses Quantrix to deliver insight into various aspects of the business by allowing stakeholders to readily find these answers in a visual, easy-to-understand format. “Who are our best performing customers/projects, viewed by sales, gross margin, utilization rate, or other metric?” says Nisenboim. “We can incorporate all of these and more into one model and use it as a decision support system. Stakeholders can be served different slices of data and different levels of rollups to get answers to questions in a quantitative manner.”

Users are thrilled with the answers and insight that Quantrix delivers. For example, Astound Commerce’s client services team used to spend a lot of time calculating key performance indicators. “With Quantrix, data that KPIs are calculated from flows seamlessly. They can concentrate less on the analytics, and more on the actual management of the accounts,” says Nisenboim. The implementation also positions the company to build analytical and performance management models for clients, a service it plans to add to its portfolio of offerings. “We have built the expertise in delivering the whole solution, starting from managing the data via ETL all the way to building cloud-based models for clients using Quantrix,” says Nisenboim.

The ability to collaborate via the web-based Quantrix Qloud is another positive feature for Astound Commerce. With team members spread throughout Europe and the United States, gathering and sharing data used to be a time-consuming process requiring multiple Google spreadsheets and unreliable data. “Now, we have different stakeholders participating in this dialog, looking at the same analytics all coming from the same data source,” says Nisenboim. “This can only be achieved from a solution like Quantrix.” It has deployed Quantrix’s Enterprise Qloud version, where Astound has an on-premise Qloud server, enabling the company to host models and collaborate via its own private cloud.

With a robust data warehouse serving information into the collaborative Quantrix Qloud for modeling, Astound Commerce now has a single source of data providing precise, tailored views of a company-wide model. “We now have the full stack, from ground to the Qloud,” says Nisenboim. “Quantrix has it all. The value is incredible.”

Mischler Financial Group Uses Quantrix Qloud to Stand Apart

Competition is strong in the institutional brokerage market, and niche firms must find a way to stand out. Mischler Financial recognized that its institutional clients needed more in a partner than a strong reputation and competitive pricing – they needed access to information. A series of models developed on the Quantrix Qloud platform has created a “slam dunk” edge for the firm.

Mischler logoMischler Financial is the financial industry’s oldest broker/dealer firm owned and operated by service-disabled veterans. It serves institutional clients including public entities such as cities, counties, and municipalities, and provides direct access to global equities and fixed income markets, new issue underwriting and syndication within the US Equity and Debt capital markets, and asset management for liquid and alternative investment strategies.

“These large institutions operate very large funds – often in excess of hundreds of millions of dollars,” says Jason Klinghoffer, CFA, Director, Mischler Financial. “But many times the fund managers are public servants without access to the tools and resources a Wall Street money manager has.” Recognizing their budgetary limitations, Mischler sought a way to level the playing field for its customers that buy and sell without access to Bloomberg terminals or costly analytics programs.

Klinghoffer joined the firm in 2014 with a mission to create a new set of analytical models to replace the cumbersome investment strategies and offerings spreadsheets that Mischler provided to clients. One requirement: an online platform for direct client access. “No matter how cool your spreadsheet is, at the end of the day, email is a huge bottleneck,” says Klinghoffer. “It’s inefficient, clients can’t easily access the models on demand, and we can’t track whether or not they are using them.”

Originally he planned on developing an internally housed solution from the ground up, but chose Quantrix after discovering the robustness of the cloud-based Quantrix Qloud. “It has its own admin panel, we can assign logins to clients, and we didn’t have to develop a system to host the analytics,” says Klinghoffer, who uses Qloud tracking functionality to track user logins and usage. “We can see who is logging in and who is accessing and using models, all from within Quantrix. This creates great efficiency in managing our clients’ information and analytical needs.”

The modeling capabilities and calculation engine far exceed what Mischler was able to do with Excel: the firm can separate data from the logic of the presentation, which means it can house data in various places without dragging down performance. “I have data stores that are two gigabytes in size – imagine trying to put them into a spreadsheet and get some intelligence out of them,” says Klinghoffer. “The memory requirements alone would shut them down.”

In addition to improved delivery and calculation, Mischler says plain language formulas and efficient structure makes it much easier to manage models. “Even with such large data sets and complex models, I can come back in after months and understand what’s going on,” says Klinghoffer. “I can step through a formula to see what is being manipulated, and understand the impact of any change I will make. Thanks to category relationships between matrices and dimensional linking through formulas, even my most complicated models only need a few hundred formulas to calculate tens of millions of cells!”

In the spring of 2016, Mischler rolled out its package of models to customers via the Quantrix Qloud, available 24/7, including portfolio and security analytics, investment strategy development, and inventory offerings. It offers these tools for free to clients who execute some of their bond transactions with Mischler, providing intelligence and data that were formerly out of reach to them and leveling the playing field for Mischler with the largest investment firms.

“Clients can buy their bonds from anyone – this is our value-add,” says Klinghoffer. “We give them the tools they need to make decisions, all within a seamless online cloud environment. This is a slam-dunk for us – and we’re just getting started.”

Mike Salisbury on the Quantrix Product Roadmap

Mike Salisbury is the Director of Quantrix and is responsible for the overall Product Roadmap for the Quantrix Modeler and Qloud products. Mike took a few minutes to share some insights on recent product developments and upcoming new features.

It has been a busy few months for the product teams. Can you give us an update on recent product developments on the Desktop modeler?

Certainly! In January we released a major version of the desktop product and I am pleased to say it is getting great reviews from our user community. We totally reskinned the User Interface application and focused on making the commonly used features much easier to use. New icons, new color themes, new launch panel, all aimed at making the most seasoned user to the new user more comfortable with our application.

The Dependency Inspector was completely redesigned in a recent edition of Quantrix Modeler, and it is now much easier to debug formulas.

The Dependency Inspector was completely redesigned in a recent edition of Quantrix Modeler, and it is now much easier to debug formulas.

Our Dependency Inspector (DI) redesign is a big hit. It makes formula debugging much simpler and users of all abilities can trace the calculation thread throughout the model. I personally use the Salesforce integration daily in our Quantrix sales forecasting model, and our Tableau integration means users can get information directly out of Quantrix into Tableau reports.

In our March release, we enhanced the DI even further by allowing users to navigate directly to the formula from the DI to make formula edits. Users can re-index and rename their category items on-demand, and we continue to make strategic UI improvements like shading the formula edit area in a light green to make it clearer to the user where the focus is on the screen.

How about recent Qloud developments?

New iOS tablet integration for Quantrix Qloud opens up in-the-field uses for Quantrix.

New iOS tablet integration for Quantrix Qloud opens up in-the-field uses for Quantrix.

We are really excited about our IOS tablet integration. I encourage iPad users to navigate to http://qloud.quantrix.com to check it out. Having the ability to use Quantrix Models on a Tablet device should open up some opportunities for executive and ‘in the field’ type use-cases we have in our customer community. I think one of the best features is being able to move a matrix dimension tile to the row, filter, or column tray simply by dragging it with my finger. Simple but very effective!

In our March release we introduced Salesforce compatibility for Qloud. If you are using the Salesforce integration on your desktop models, you can now use this integration on both Hosted and Enterprise Qloud. We believe the data analysis you can do in Quantrix far exceeds anything you can do within the Salesforce application itself.

How often do you release new software?

We strive to have a new desktop and Qloud release every three months. We have adopted the Agile method of software development. This allows us to quickly iterate on new features (and bug fixes) in two-week cycles or ‘sprints’. At the end of each sprint, we have a functioning product. At the end of the three-month cycle we move into a formal test period and then release to our customers. Doing this allows us to be much quicker and more reactive to our customer needs.

What is next for the Desktop Modeler and Qloud?

For Qloud, we are actively converting the Qloud framework to AngularJS. This JavaScript framework allows us to develop new features much quicker, and is more suited for tablet development. This is a big project, but our production Qloud already has many of the AngularJS pieces in place on the login page and the models list on the current hosted Qloud. We continue to work on switching over other non-model elements of the Qloud to this new technology.

In regards for Qloud features, we are actively working on Multi-user Edit. This will be an Enterprise-only feature that will allow Enterprise Customers to deploy models to users, and then allow those users to edit the model at the same time – no more waiting for your colleagues to release the lock on a model. With this comes some powerful new features including tagged versions and ‘save-as-you-go’, all to ensure you can collaborate effectively.

For Desktop, continuing the improvement of our user interface and ease of use as well as developing more getting-started help is high on our list. We are making our Salesforce integration even better by allowing joins between multiple tables in the Salesforce hierarchy. We continue to address issues and enhancements to make sure our calculation engine is as efficient as possible, because we know our customers like to make very large models!

How can a Quantrix user provide feedback?

We very much appreciate feedback from our users. Many of the new enhancements and features are the direct result of user suggestions. There are many ways to provide feedback:

As always, thank you everyone for your support of Quantrix!

Richard Holohan, Logistics Capital and Strategy, Finds Quantrix Delivers “Massive Cost Efficiency”

At last fall’s Seminar by the Sea conference for Quantrix users, Rich Holohan of LogCapStrat sat down with us to talk about his use of Quantrix for quantitative modeling. Like many former Excel users, he needed a replacement for an Excel model that had “gotten out of control.” In this video, he talks about the flexibility and efficiency of Quantrix, including the dramatic reduction of man hours required to update one client’s model. From three people full time for two weeks, to one person for two days, the Quantrix model offered “massive cost efficiency.” Watch the full video for more.  

 

People of Quantrix: Brian Cabana, Engineering Manager

Brian is the Engineering Manager and Lead Engineer for the Quantrix team and has been with the company for over ten years. He has actively participated in the design, production and testing phases of each of the releases of Quantrix since version 1.0. He currently manages the engineering team and is the lead engineer on the various projects for Quantrix Modeler and the Qloud.

Brian Cabana, Engineering Manager, Quantrix

Brian Cabana, Engineering Manager, Quantrix

What is involved in your role as lead developer for the Quantrix Modeler desktop product, and how has it changed over the years?

As Engineering Manager, I help manage the prioritization of issues and run the projects from an engineering standpoint, as well as other typical managerial duties. I also do a lot of coding of features, which I enjoy. I’ve been with Quantrix since 2003 and from an engineering perspective, a lot has changed. Java, the base language we code in, has improved. User interface design principles have changed, particularly in terms of migration to mobile devices. In that period, we’ve moved from being a desktop only application to the web, launching the Qloud, and continuing to move to mobile device. And we have had a lot of fun.

What is most important focus from an engineering standpoint?

Two things: usability and stability.

Talk about usability.

In the 1990s, usability meant, “Can you do it?” Today, it’s “How easy is it to do it?” That is a big shift. We want to make new users more comfortable using Quantrix. Power users love it, but we are working on making it more usable for more people. That means making things easy to find and easy to do.

Some recent examples of our work on usability include the recently improved launch panel and the major changes to the Dependency Inspector. Before, it was hard to understand what was happening in the cell. Now there are a lot of clues as to how it calculates, including the ability to hover over the formula in the dependency inspector to see the calculations. Another change is that when a user starts to edit a formula, it gets a green background. You know exactly what you’re editing. We plan to do more usability improvements like this as well as revamping some other tools.

How important is user feedback?

We have a great user base, and they provide great feedback. We also track when people call support. If they have a hard time doing things, we try to fix that in development. We try to be as responsive as possible. At one of our Seminar by the Sea events, a power user told us that it would be great to be able to select a range of cells and filter on them immediately. One of our programmers went home that night and coded up a proof of concept. We included that feature in our next release.

Have you always been a software engineer?

I served in the Navy on submarines. Then I became a high school math and science teacher. I went for a masters in computer science, and learned about Quantrix. I pestered the company founder until he gave me a job.

What do you do when you’re not coding for Quantrix?

I have a lovely wife and two young children. We love to go cross-country skiing and snowshoeing. I also love to read – I’m currently reading a fascinating history of Maine called The Lobster Coast.

Validus Uses Quantrix for Financial Planning

Dan Kirkpatrick of Validus Holdings Group attended the 2015 Seminar by the Sea in Portland this fall, and shared his thoughts about Quantrix Modeler. In this video, he discusses how the company uses Quantrix for financial planning, including developing P&Ls and balance sheets by company and division. It also uses Quantrix for scenario testing and for building capital models. Validus is a holding company for reinsurance and insurance operating companies and investment advisors, and it has a high volume of historical data – its models are large, with some at 1.2+ billion cells. Kirkpatrick says that Quantrix is “leaps and bounds ahead of Excel” in its ability to create models that deliver insight to senior management.

Jackson Laboratory Uses Quantrix for Endowment and Treasury Portfolios

Nathan Briggs, senior treasury analyst at Jackson Laboratory, uses the Quantrix business planning and modeling solution to manage endowment and treasury portfolios. The models track investments, accounting information, and market variances along with return calculations.

Jackson Labs switched its models from Excel to Quantrix to provide a more robust and structured solution, and improve formula management. “What we liked about Quantrix was the ability to change one formula in one place and have it be pushed throughout the model,” says Briggs.

 

In addition to desktop modeling, Jackson Laboratory uses the online version – the Quantrix Qloud – to improve collaboration with external investment advisors and managers. “Using the Qloud has allowed us to share information more efficiently,” says Briggs. “Now we’re simply publishing that information to the Qloud – they can go on when they are ready and download information and manipulate it how they need to. It certainly has been a time saver.”

 

Dan Murray of Interworks to Speak at Seminar by the Sea

Dan Murray is Director of Strategic Innovation for Interworks, a global IT services and business solutions provider. He is the author of Tableau Your Data!, and will be the featured speaker at this year’s Seminar by the Sea. We had a chance to talk with him about the data modeling ecosystem, and the value of an iterative process.

Describe your practice at Interworks.

Murray: InterWorks has a different model than most consulting companies —we aim to do high quality work, very quickly and then leave. Our consultants are good at translating technical needs into business cases. We also provide clients with thought leadership and project planning/implementation. Then we help them design dashboards that help them see and understand their data. We

Dan Murray, Director of Strategic Innovation, Interworks

have a broad skillset surrounding business information including data visualization, database design, extract, transform and load logic, hardware and network design to enable appropriately responsive data.

How did you get started working with data?

My first job was with a leveraged buyout firm. We bought bankrupt companies, looked at data, figured out how to make them profitable, and flipped them. That was better than an MBA – I figured out how to set up capital structures, leverage business assets, and drive profits. Over the last 30 years I’ve used data to solve problems, identify opportunities, and drive improvement. In the last seven years I’ve focused on teaching clients how to do this well.

What are some of the changes you’ve seen in your 30+ years managing data?

The proliferation of data bases – they are growing all the time. Many of our clients don’t have one database; they have a dozen and they can’t figure out how to get to the information. Our practice is built on helping companies bridge those gaps. And the tools are so much less expensive. Small and medium-sized businesses can’t afford to spend $1 million on toolsets to extract data and spit out multiple scenarios. Tools like Quantrix are dramatically lower in cost.

What else sets Quantrix apart?

Quantrix defines formulas the way that databases think – not by the cell, but by dimension. You can take a model with 4,000 formulas in Excel and do it with 40 in Quantrix.

You talk about the data ecosystem – where does Quantrix fit in?

At the center of everything is some kind of database. And Quantrix does something that no other tool does – it architects formulas in a very efficient and powerful way by speaking the database language at the data level, not the cell level. This means it can do powerful things with assumptions for predictive analysis. Factors that affected a business’s performance a year ago might not affect it a year from now, so you need to build a complex calculation that based on a sliding assumption. You identify the dimensions that are important to your business, and the assumptions that have worked in the past. With Quantrix, you can adjust the sliders to see if each factor will impact the future, by how much, and the outcome.

Give me an example of how that information impacts performance over time.

Today, most companies create a budget, and then re-budget every quarter. They take it for granted that they need to revise their forecast, but they are not using that information to refine their forecast. Quantrix can be the tool that you are iterating the potential future from. When you have new information, you should be populating the database with that innovation, and capture your assumptions. They are part of the innovation cycle. We tend to forget the bad ones and overemphasize the good ones – but with Quantrix connected to a database, you can see how good your assumptions were, and use them when you iterate. If we can reduce the time and effort required rebuild that forecast, then you can really advance over time.

What’s the bottom line for companies?

In the end, it’s all about data. Do you have it? Can you interpret it correctly? If you move the dial – which you can do easily with a Quantrix slider – did the expected outcome occur? That, to me, is what it’s all about. Drop the technology hurdle, expose the bones from the assumptions, and have a learning process where you get better over time. It is measurable. At some level, something significant happens – if you’re doing it right, the cumulative effect of the effort will help you grow.

Rich Lopez, aka the “QuantrixAuthority”, Creates YouTube Channel for Quantrix Users

We are always amazed and gratified by our customers’ passion for Quantrix Modeler, but Rich Lopez has taken it to the next level. By day, he works in the finance department of Litehouse Foods, but by night he is YouTube star The Quantrix Authority. His series of three- to five-minute-long how-to videos helps others get the most out of using Quantrix’s multidimensional modeling software, from learning how to snap two matrices horizontally to a canvas, to the benefits of using Timeline for recursion in a model.

How did you get started with Quantrix?

I was introduced to Quantrix when I worked at clothing retailer Coldwater Creek. I used it to build an allocation tool to manage inventory at our 350+ stores. When I moved to Microsoft’s interactive entertainment division, a co-worker and I built a distribution model to ensure that we were getting the Xboxes and games shipped properly. It was during some of the really big

Rich Lopez, the Quantrix Authority

Rich Lopez, the Quantrix Authority

Microsoft launches, like Halo 4 and Windows 8, so we build scenarios for everything we had to manage during the holiday season. We were able to model it down to the daily levels. Quantrix saved my bacon at that job – I could not have done what we needed without it. Now I use Quantrix for financial modeling and capacity modeling for Litehouse.

What inspired you to start making video tutorials about Quantrix Modeler?

I leaned a lot about using Excel from a guy on YouTube called MrExcel. Bill Jelen has more than a thousand videos, and I used to watch him every day. I am a pretty advanced Excel user, but I love Quantrix more. After seeing what MrExcel has done, and seeing how his expertise helped me, I thought I could do something similar to help others with this fantastic software.

How do you choose the topics?

My first video was about the first feature I learned in Quantrix – “Using As.” My mentor taught me that when I started at Coldwater Creek, and it’s basic functionality in Quantrix. Some people at my company are struggling to use certain features of our Quantrix Models, so I’m starting to create videos on topics that will help them.

Who are you targeting?

I am pretty much reaching out to beginners and intermediate users. I am very open to questions – after my second video, I got an email from a Quantrix user in the Ukraine. Just this week someone asked me about using DataLink with .csv files, so I made that video. Whenever someone asks me a question, I try to answer it.

How many videos do you plan to make?

MrExcel has more than 1,000 videos and a forum that everyone knows. I have eight videos online now, and if I get to 100, I know I will have really accomplished something.

I’m following you on Twitter. How famous are you?

Ha ha! On a scale of one to ten, I am probably a “one” in real life. But in the Quantrix world, I hope to one day be about an eight! I am having fun with the videos, and with my Twitter account (@QuantrixAuthor). I have legitimate Quantrix users following me, and I feel like I am rubbing shoulders with some real legends. Some of these people are such power users, and they are telling me to keep making videos. Their feedback is so positive, and it’s great.

Final question – what was your “aha” moment using Quantrix?

It happened at Microsoft. I remember being called into a room by eight managers and having them tell me they needed some specific information, and they wanted it in three days. It could not be done in Excel, so we just pounded out a model in Quantrix. I stayed up until two in the morning a couple of nights, but I developed a model where if the managers wanted to add another distribution center, product line, or launch scenario they just could select a category and hit “enter”. That was it. And I realized then and there that Quantrix Modeler was the coolest tool that has ever been made. Quantrix Forever!