Multi-variable scenario modelling means changing several assumptions at once — price, volume, exchange rate, interest rate, start date — and seeing the effect on every result, for every entity, product and period. A spreadsheet copes with one or two variables. Beyond that you need a tool in which scenarios are part of the model’s structure,…
Business forecasting is one of the most important capabilities for any organization that wants to plan effectively, allocate resources wisely, and respond to market changes with confidence. Whether you work in retail, manufacturing, finance, or supply chain management, the ability to predict future demand, revenue, or operational needs can dramatically improve decision‑making. In this guide,…
Getting started with Quantrix. In this video you will learn how to build multidimensional data model using Quantrix Modeler software. Step-by-step demo by Tahir Tahirov from Smart Modeling Solutions.
Check out our new YouTube video about Dashboards: Sales, Customer Analytics, Budget vs. Actual. Subscribe to our YouTube channel
Watch step-by-step instruction for building a Bullet graph in Quantrix. A bullet graph is a variation of a bar graph that shows progress towards a goal or performance against a reference line. A bullet graph consists of a featured measure (such as current revenue), a reference line (such as a target), and qualitative ranges (such…
Check out our new video about building Strategic Plan in Quantrix which includes: Multiple scenario for each parameter, Acquisition manager with one-click asset addition and Portfolio manager for simulation and impact analysis. Subscribe to our YouTube channel
Онлайн-семинар Quantrix на русском.Часть 4. Создание сценариев в Quantrix 0:00 Представление – Таир Таиров, Smart Modeling Solutions01:05 Создание сценариев в Quantrix – Rich Lopez, Quantrix Authority
Онлайн-семинар Quantrix на русском. Часть 3. Алгоритмы расчета, управление моделями и иконографика. Использование алгоритмов расчета, возможности масштабирования моделей и визуализация с помощью иконок в Quantrix – Таир Таиров, Smart Modeling Solutions
To enhance the filtering process and provide an option to show all items, user can consider adding an “ALL” item to the dropdown list (this can be done via concatlist() or the generate items feature). When a user selects “ALL,” the entire table will be displayed. This approach may be more intuitive for users, as…
It is possible to reorder items based on values via script (an example shown below). It should be clear that in a sorted matrix, Quantrix sees only original (unsorted) item position (index). One can check it by adding item with #category formula in the sorted matrix. So, concept of sorting and reordering somehow different.
This script designed to change the column width of items.
XLOOKUP is promised to be the only Excel lookup function you need, mostly replacing VLOOKUP and INDEX & MATCH. But it has problems which I outline in this video.I cover 4 problems of Excel XLOOKUP and compare it to SELECT function of Quantrix Modeler.
We use cookies to improve your experience. You can accept or manage your preferences at any time. Some features may not work properly without consent.