Онлайн-семинар Quantrix на русском. Часть 2. Опыт внедрения Quantrix для составления бюджета. 0:00 Представление — Таир Таиров, Smart Modeling Solutions01:20 Опыт внедрения Quantrix в TOO «Magnum Cash&Carry» — торгово-розничной сети №1 в Казахстане — Жибек Мамбетова, АССА, Заместитель финансового директора по финансовой отчетности и бизнес-процессам, ТОО «Magnum Cash&Carry».
Онлайн-семинар Quantrix на русском. Часть 1. Вступление и опыт использования Quantrix в банке. 0:00 Вступление — Таир Таиров, Smart Modeling Solutions6:11 Использование Quantrix для стратегического планирования в банке — Михаил Прозоров, ПАО «БАНК УРАЛСИБ»30:10 Использование Quantrix для ad-hoc анализа в банке, Алексей Романов, ПАО «БАНК УРАЛСИБ»
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.
This almost 30 years old article promises that Lotus’ Improv for Windows will change the way people create and look at spreadsheets. With Excel dominating the market, these amazing advantages of Lotus Improv are almost forgotten. But they are still valid today.Luckily, we have all these amazing concepts of Lotus Improv in Quantrix for those who want…
I think the most interesting way of using role names is in creating different views of the same Matrix based on the role. This means users with different roles will see different parts of the matrix assigned to them. We can do it by using the role name variable in filter expression. You save your…
Show changes directly on the matrix along with the date and user name using data from Audit Trail. This feature significantly increased transparency and enhance my model audit capacity.
This article will introduce you a new, innovative way of financial modelling for your planning, budgeting, forecasting needs and running “what-if” analysis with multiple scenarios. Every controller faces complex modelling tasks in his/her daily work. Be ready to sit on driving seat, quickly and efficiently create your financial model. Multidimensional modelling is an alternative to…
Dieser Artikel wurde im größten Fachportal für Controller im deutschsprachigem Raum — CONTROLLING-Portal.de veröffentlicht. Link zu Fachbeitrag In diesem Artikel wird eine neue, innovative Methode zur Finanzmodellierung für Ihre Planung, Budgetierung, Prognose und Durchführung von Was-wäre-wenn-Analysen mit mehreren Szenarien vorgestellt. Jeder Controller steht in seiner täglichen Arbeit vor komplexen Modellierungsaufgaben. Bereit sich auf den Fahrersitz zu…
Our client is a global company with headquarters in Germany and over 15 offices worldwide. They use Quantrix models to monitor and control the financial and operational aspects of hundreds of concurrent projects. We provided a solution to integrate their project management software with Quantrix, enabling them to view and analyze the data on project…