Business Intelligence Consulting

Business Intelligence Consulting

Faster reporting for predictable success.

If reporting and business planning via Excel lists reaches its limits, or if too much information has to be gathered manually from different source systems in order to get a solid view of your own business development, then it is time for a real Business Intelligence solution in your company.

We are happy to support you along the way with consulting services, from the recording of the current status and your requirements to the selection of tools and the implementation of your own BI solution. Due to our experience in complex BI projects, we have extensive process know-how as well as in the agile splitting of such complexities. We develop suitable solutions with the possibility of agile further development.

In cooperation with Prof. Dr. Egle of the Lucerne University of Applied Sciences and Arts, our ARTS Processes partners have published the white paper "Business Intelligence: How Data Analytics in the Aerospace Industry Ensures Faster and Better Information".

Please find the full article here!
Jedox AG

Jedox as Corporate Performance Software

For the implemented project at the ARTS group we use the software Jedox. Jedox simplifies planning, analysis and reporting for CPM and BI. Especially due to the integration into Excel, the software is intuitive to use for users.

Why BI? The advantages.

                                          Business Intelligence
                                          • Connection of various data sources to a data warehouse

                                          • Standardization of the different input data and transformation to data cubes

                                          • Gain knowledge through ad hoc analysis and data mining

                                          • Quick overview of relevant key figures through dashboards

                                          • Streamlining of the system landscape through a central data warehouse

                                          • Faster responsiveness

                                          • Increase in decision quality

                                          • Increased corporate transparency

                                                                            Our approach. We support you during the entire process.

                                                                            A BI solution maps the company's core processes and makes them easily measurable. As an experienced BI team, we map processes in a standardized way and develop the connection to the existing previous systems. For monitoring and regular reporting, we develop KPI's and the corresponding reports so that all important key figures can be displayed clearly via a company cockpit.

                                                                            We use prototyping, iterative development steps and standardized process steps. Prototyping is a development method that originates in agile software development and in principle uses the Paretoprinzip. At the beginning of the project, a prototype is jointly developed in a storming session with participants from the relevant technical and development departments. This prototype can have different degrees of maturity. It can be a click dummy that only simulates a functionality and essentially represents a sample as a specification for the application actually to be developed.

                                                                            The aim is to obtain an MVP (minimum viable product) that already creates added value for your company. In addition to the MVP, a more precise objective and the rough path to it are also specified. This way is divided into different iterative steps based on priorities and efforts. In these steps, we jointly develop your BI application into an integral component of your corporate management and planning.

                                                                            The added value of iterative development steps is to divide the time for conception phases and not to carry them out in one block at the beginning of the development. In addition, changes in the environment, priorities and new insights can be addressed in the agile individual steps. This approach has its origin in the agile software development with methods like Scrum, Kanban or mixed forms like Scrumban, which are adapted to the corresponding requirements and basic conditions. In the process, pre-defined work packages are processed in so-called sprints, small development stages. At the end of a sprint, the achieved tasks are compared with the originally planned ones. A retrospective is carried out in which it is recorded what went well and should be maintained during the sprint and what went badly and how it can be improved. Then the tasks for the next sprint are planned.

                                                                            In the iterative steps the following types of development can be distinguished for our project:


                                                                            Initially manually connected proven input data into the system can be imported continuously by automated ETL processes and thus development curves of the individual drivers can be tracked.

                                                                            Correction of existing assumptions

                                                                            If new KPI's or data sources become relevant or originally planned KPI's lose weight, the relations and connections can be agilely adjusted during development.

                                                                            Adaptation to changing conditions

                                                                            The company can react agilely to expansion and changes in the business segments with a corresponding influence on the evaluation or planning system or technical changes in the previous systems.

                                                                            In the course of the project, we continue to orient ourselves towards the following standardised steps in order to provide you with optimum support throughout the entire process:

                                                                            Recording and mapping of your processes

                                                                            Together we look at your processes and work out how and in which systems your company data is stored.

                                                                            Identification of implementation goals

                                                                            Now we define together which data we use for a later evaluation.

                                                                            Data Warehouse Design

                                                                            The next step is to develop a solution to integrate your data from different data sources into the destination. We pay particular attention to storage options, access options and the performance requirements of the data warehouse.

                                                                            Design and optimization of ETL routes

                                                                            The data from the various data sources is then consolidated. This means that the data is structured in such a way that it can be retrieved uniformly in its structure in the data warehouse.

                                                                            Connection of different data sources

                                                                            In this step, the relevant data sources are connected to the data warehouse so that the data is available at the destination.

                                                                            Definition of key performance indicators

                                                                            Now it is possible to retrieve the structured data in the data warehouse and to highlight the relevant information for your corporate planning. KPI's are the key figures that have a direct influence on your company's success.

                                                                            Setup and optimization of a dynamic reporting system

                                                                            In order to make the relevant data available for your company and to present it transparently, we support you in the further course with the development of dashboards. Thus you have your data quickly available at any time.

                                                                            Development of permission distribution concepts

                                                                            Finally, we define together which parts of your company can access the relevant data and make use of the information in order to be able to react quickly to changes and to speed up decision-making processes.