I worked with Cedric Aeberli and his team to develop the interface and the MIS tool based on Avaloq ASSL, they were very responsive and always present over the years to help us improve our QlikView dashboards and accompany us throughout the project.
Marie Françoise Manana
Senior Accountant, Alpian
We have been working with the Integraal Solutions team for many years, and we particularly appreciate their responsiveness and availability.
The SMART for Real Estate decision-making platform, which deployed early 2021, gives us a better analytical vision of our business.
With the help of the Integraal Solutions team, who are always ready to listen to our needs, we can create and consult dashboards quickly and easily. This data makes our day-to-day work much easier and also allows us to provide a better service to our clients and improve our internal controls and monitoring.
Stefanie Sidler
Managing Director, Bory & Cie Agence Immobilière SA
I first met Cedric Aeberli when I was working for Banque SYZ and we were looking for a steering/MIS tool. We did some market research and identified Integraal Solutions. It took me about 30 seconds to recognise the value of their expertise and the power of the tools. As I often say, if I were running a bank, I would have Integraal installed before I arrived and I would be able to understand the strengths and weaknesses of the organisation from day one.
Philip Biber
Partner, Sionic
We have been working with Integraal since 2015. We first worked together to implement a consolidated MIS reporting solution for our various entities in the Private Banking business line. This dashboard has become an indispensable steering tool for management and the front office in order to monitor the Bank’s profitability and the performance of our private bankers. Then, thanks to the Framework, we were able to develop other dashboards with Integraal in different contexts to meet the bank’s other needs: the MIS product, which gives us a more detailed view of the bank’s activity at the transactional and client level; a dashboard specific to our Investment department, which provides them with a tool for monitoring their activity, in particular to check that the portfolios are correctly invested according to the allocation models and investment strategies; and also a Compliance dashboard which generates alerts in the AML context. Integraal therefore allows us to meet multiple needs in different areas, with simplicity and efficiency.
We have been using the tools of Integraal Solutions SA since 2016. The growth of our activities and the need to have a global analytical vision to support our strategic decisions led us to look for a Management Information System solution. After a review of the various software and service providers available on the market, it became clear that Integraal Solutions met our requirements, including the promise of working with a competent team that listened to our needs. SMART for Wealth Management has become our real dashboard, which we have named internally “NS Cockpit”, and I dare say we couldn’t live without it.
Amélie Janssens de Bisthoven
Head of Business Intelligence, NS Partners SA
We were pleased to implement the SMART for Wealth Management solution, which measures the monthly activity and profitability of Relationship Managers. Profitability includes the measurement of the direct cost of the sales teams (full salary of the FO, cost of assistants, travel, telephone, IT, etc.). Good measurement improves the dialogue between sales people and management and provides the basis for decisions on the choice of an appropriate sales channel (visit, AI, e-marketing, use of EAM). The responsiveness of the Integraal teams and the high level of business analysts enabled us to rapidly deploy dashboards drawing on Avaloq data.
Eric Berling
Head of Finance and Accounting, S.P. Hinduja Banque Privée
When I was CEO of Arab Bank in Geneva, we collaborated with Cédric Aeberli and his teams in the implementation of the SMART for Wealth Management and Avaloq solution. We were perfectly satisfied. Cédric is a reliable person who delivers what he promises.
Nicolas Chikhani
Banker, CEO, Board Member & Investor
We have been working with Integraal Solutions since the beginning of 2020 and I would recommend them to anyone who wants a solid and reliable foundation for creating effective dashboards. They listened to my needs, advised me, created a suitable database and then trained me so that I could use the system independently. To date, I have been able to develop about ten Dashboards and in case of specific questions, they have been very reactive to help me! These dashboards have clearly helped me to improve my monitoring, my internal control and the service we provide to our clients.
Jérôme Chincarini
co-CEO, Synergix SA, new generation fiduciary
Data is everywhere and the biggest challenge is the quality of the data. The field of property management is complex and requires being proactive, efficient and pragmatic.
of business users need quality data in their decision-making processes
The quality of the data is essential and it must be admitted that not everything is perfect. Data is the result of our business processes: it highlights our strengths and weaknesses. We should not expect data to be perfect, it probably never will be; however, we should pay particular attention to key data that have a strong impact on the organisation. A data culture cannot be improvised, it is built over time and requires a strong impetus from the management teams.
Real estate significantly reduce the time needed to set up a business intelligence platform by using SMART
You have to admit your mistakes and not be afraid to rethink your foundations. SMART has not escaped this rule, which is why we are constantly evolving our solutions. The 2021 edition, the second major release of our solution, is based on the best technological components on the market and allows for the rapid deployment of pragmatic solutions. We are convinced that the technology exists; it is necessary to use it to create real business solutions.
of operational teams say they are able to produce the right results on time
Accessibility to data is a real issue. Users are constantly being asked to produce new reports and to contribute their expertise and know-how. They must be able to produce analyses on reliable, secure and compliant data. Nothing is worse than producing results that are questioned by a sceptical audience. A global and common repository considerably reduces this risk: each consumer actively participates in increasing the quality of his or her data and thus of the whole community.
of those who use storytelling say they are able to back up their statements with factual information
The storytelling functions allow you to support your words with tangible visuals and factual data. When you rely on facts, it is much easier to achieve your objectives. Trust and agreed-upon facts are the key to audience acceptance. The use of dynamic applications, coupled with powerful storytelling features, can instantly answer the famous question that would probably have embarrassed us with a simple static report.
The applications linked to the effective management rate allow you to calculate the real effective management rate on the basis of your statements. It can take into account major works, renovations, vouchers, etc.
The management of your rental situation is based on the analysis of all key elements of your organisation: owners, groups of owners, buildings, objects, vacancies, tenants, leases, etc. All this data is part of the common data repository.
The applications dedicated to proprietary allow you to give visibility and transparency on your mandates. They are designed for your owners and integrate seamlessly with your infrastructure: website, tablets and smartphones.
Good visibility of operational teams supports the transformation of your organisation. Data is factual and accessible to the right people at the right time.
The applications linked to the effective management rate allow you to calculate the real effective management rate on the basis of your statements. It can take into account major works, renovations, vouchers, etc.
The management of your rental situation is based on the analysis of all key elements of your organisation: owners, groups of owners, buildings, objects, vacancies, tenants, leases, etc. All this data is part of the common data repository.
The applications dedicated to proprietary allow you to give visibility and transparency on your mandates. They are designed for your owners and integrate seamlessly with your infrastructure: website, tablets and smartphones.
Good visibility of operational teams supports the transformation of your organisation. Data is factual and accessible to the right people at the right time.
Staging and a scalable data warehouse, designed for the business needs of real estate agencies.
A generic data model that allows you to quickly have a global data analytics platform. The data comes from your information systems and is integrated into the import area of the HUB, then automatically processed to the final data hub. A single, global data model for all of your business activities.
Out-of-the-box applications, reference templates and ad-hoc dashboard design tools to facilitate and accelerate adoption.
Starting from scratch is not easy; existing applications allow you to grasp the data and quickly get into an operational context that makes sense. Embedded technology allows you to customise applications and tailor the user experience to your many needs. You are in control and can quickly create your own applications on your own.
A centralised dictionary of business data, standardised and available to create your applications independently.
KPIs, measures, attributes and other usage data are centralised in a data dictionary designed for the business. The indicators are documented and accessible via an application to find the right information in a few clicks. In addition to the standardisation of measures, the data dictionary allows the same language to be spoken: a homogeneous definition, a common understanding and consistent data.
The Data Connector is a set of processes for processing a business data source (ERP) in the Data-HUB.
The main role of the connector is to map the data between the source system and the HUB import area. All data comes from your source systems; there is no format or type transformation required. The Data-HUB has been designed to be able to support the main standard data sources on the market.
Any data source can be integrated into your analytical platform.
From our experience, we know that our customers have not waited for the magic solution and have built many business applications. This data is a real asset and we must be able to capitalise on it. The Framework has been designed to be able to consume this data without questioning its origin.
It is not necessary to systematically go through the Framework to make new data available to the business.
Normalised data accessible in a Cloud Data Market can be directly integrated into a Business Data Lake. The BDL acts as a data concentrator and aggregator and enables the integration of numerous heterogeneous data sources.
The processing of data quality is part of a company strategy. SMART tools allow you to industrialise the controls and the management of quality controls.
A rules engine allows the necessary checks to be carried out throughout the data integration process to guarantee data quality and conformity. The controls cover unit quality, integrity, evolution of indicators over time and a whole set of business rules organised by context.
A Staging and Data-HUB designed for your industry’s data.
A generic data model that allows you to quickly have a global data analytics platform. The data comes from your information systems and is integrated into the import area of the HUB, then processed automatically up to the final data hub. A single, global data model to manage your business data.
Discover the Data Connector of the main ERP real estate companies on the market.
Discover our Data-HUBs designed for your business data.
