The intact foundation needs an effective method to evaluate and understandably visualize the performance of its various business areas. So they decided to use a Power BI solution to get the best insights from their data. With the help of Microsoft Power BI The foundation can now carry out more efficient and, above all, more regular evaluations of your business activities.
In the year 1997 was the Foundation intact founded as a “simple” unemployment project with a guarded bike station. Since then, the services and offerings have developed significantly. Today intact offers long-term unemployed people a wide range of work opportunities in different areas. Its goal is to enable the long-term unemployed to find meaningful employment, to build a social network and to provide support with professional integration.
The intact foundation offers a variety of services that are assigned to different business areas. It is therefore important for the foundation to have an overview of the performance of the individual areas. However, no division into areas is possible in bexio (business software). In order to track the success of the business areas and report it to the board of directors, the data must be exported from bexio and the list and distribution of overhead costs among the areas must be created manually. This process involves considerable effort for the foundation and was therefore only carried out every six months.
In order to be able to carry out more efficient and regular evaluations in the future, the intact foundation has decided on a Power BI solution.
The new solution is intended to enable the foundation to carry out a timely and rapid evaluation, including the distribution of overhead costs across all areas. The comparison to the previous year, the budget analysis and the analysis of customers and products are also among the requirements for the Power BI solution. The evaluations should be available at any time via dashboards. An authorization concept gives the board of directors, management and department management individual access to the reports. With the help of well-chosen visualizations in Power BI, facts such as liquidity development, the utilization of the areas and the pursuit of goals should be clearly presented. Using integrated drills and tooltips, the foundation should be able to access further helpful information intact.
Another requirement of the intact foundation is that independent evaluations and dashboards are possible. This enables the people involved to analyze the data and information relevant to them and gain important insights.
Also important for the foundation was the integration of the previous year's data and the budget. Since the business software bexio was only introduced at intact last year, the previous year's data is missing. These should be integrated into Power BI together with the budget so that comparisons are possible.
At the beginning, redIT dealt with the integration of the previous year's data and the budget in order to enable future comparison. For this purpose, the previous year's figures were saved on SharePoint and integrated into Power BI. In addition, the data was assigned to the respective areas to enable a detailed development evaluation. At the same time, the budget could be integrated into the system in a similar way.
The different accounts can be assigned to the business areas using Power BI. To do this, distribution rates can be entered in Excel for a whole year or on a monthly basis. Based on this, Power BI creates a distribution key (1: chart of accounts key), which enables the automatic allocation of income and expenses according to the set percentage, as well as a table with the business areas (2: cost centers) for further evaluations and the allocation of overhead costs.
In a second step, the overhead costs are distributed among the business areas in Power BI in order to obtain an overview of the respective areas. This distribution can also be controlled using fixed or variable distribution rates in Excel. After the overhead costs have been distributed, the authorized persons can view regular evaluations and the current income statements for each area.
Based on the known requirements, redIT has already created an initial dashboard for management and department management. In addition, the intact foundation received an introduction to Power BI and its data model, which means that employees are now able to design or adapt dashboards independently.
The intact foundation had the requirement to restrict the authorizations of department heads in Power BI in order to enable automatic pre-filtering of the data for the respective people. For this purpose, roles were defined that restrict access via the logged in user (more about this in this blog).
The intact Foundation's decision to implement Power BI as a solution for data analysis and evaluation is an important step towards optimizing its business processes. By incorporating various requirements, such as timely evaluation of business areas, comparison with previous year's data and budgets, and the ability to independently create evaluations, Power BI is established as a powerful tool. This enables the foundation to make informed decisions and manage its services transparently and efficiently. The introduction of Power BI enables the intact foundation to better manage its business activities, identify opportunities and effectively pursue strategic goals.
If you also use the business software bexio and want to link it with Power BI, you can find it here our offer for this.
«Corina Camenzind from redIT Services AG accompanies us with expert knowledge, patience and humor in the fascinating possibilities of Power BI. Thanks to the financial cockpit with integrated business accounting, we have an overview and save time through automated processes.”
Olivier Eicher
Head of Central Services, Foundation intact
Interested in this solution?
The intact foundation decided on a Microsoft Power BI solution with Bexio so that they could easily analyze and evaluate the performance of their various business areas. redIT handled the entire planning and implementation in collaboration with the intact foundation.
Find out how PILATUS-BAHNEN AG was able to experience measurable cost reductions and increased efficiency through printing services.
The Enzler Group has decided on matrix certification in 2022. Accordingly, the requirements for a uniform QMS structure became more and more important.
The success story surrounding the automation of accounts receivable accounting speaks for itself - time for a panoramic trip of a different kind!
Find out from UBV Lanz AG's success story how you can benefit sustainably from Security Awareness Training & Phish Threat!
This year, the topic of automation was the focus at Arval Schweiz AG. Specifically, the digital inbox was outsourced.