Data Science, Diverse, Success-Stories
Trade statistics
Collection and analysis platform for Swiss trade statistics
vonThomas Maier
16 Apr 24
Via the trade statistics platform, fiduciaries collect data on the balance sheet and income statement of around 7,000 commercial companies in over 90 industries. With the help of statistics based on this data and configurable reports, they provide their clients with key information for an individual assessment of their situation.
Initial position
The trade statistics were founded in 1946 by the Swiss Trade Association and managed by the “Conference of Commercial Trust Companies”. Until recently, the conference published the most important business figures of about 90 industries in book form. In 2020, the digitalization project for statistics was launched. On the one hand, data collection was to be digitized, and on the other hand, members were to be enabled to generate individualized evaluations and reports. In the future, this should also enable further statistical evaluations and the further scaling of the platform.
Digitization of data collection and analysis
All processes for the creation and use of trade statistics were transferred to a new web application. In addition to the complete data collection, the automatic data preparation including intelligent cleaning and extensive evaluation options, this also includes the administration of the memberships as well as a comprehensive user management with different authorization levels.
In the data collection, the fiduciary members record the figures of the balance sheet and the income statement of their customers according to commercial law. In order to calculate relevant key figures, additional key data is also collected – for example, the number of employees and the size of the company. The application supports the user with numerous input aids such as detailed explanations, automatic validations, previous year comparisons or consistency checks. Submitted data records can be checked by the data office and, if necessary, rejected with correction notes.
Data security and anonymization are central to the evaluation. All data sets undergo intelligent outlier cleaning to guarantee robust and meaningful comparative statistics. Based on the number of data records submitted, the level of detail of the evaluation is also dynamically adjusted to prevent conclusions being drawn about individual companies. With a comprehensive report editor, users can create and configure individualized industry and customer evaluations. To do this, they can freely combine different table views, interactive time history graphics, and their own text modules with individual comments.
„With Datahouse we had a competent partner on our side, who helped us with their statistics know-how and project experience to complete the project in time and cost and to provide all our users with a very intuitive solution in a modern design.“
Markus Helbling, BDO Zürich
Conclusion
The trade statistics have been successfully digitized. The platform facilitates efficient and accurate data collection for members and makes it possible to create individualized industry or customer reports. Specialized user roles for the business office and the data office facilitate administration and enable the further scaling of trade statistics.
More
Are you facing similar challenges or do you have a similar project that you need help with? Then don’t hesitate to contact our Senior Expert Data Scientist Thomas Maier.