Business Intelligence Consulting
Faster reporting for predictable success.
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".
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.
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
Increase in decision quality
Increased corporate transparency
Our approach. We support you during the entire process.
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.