What does self-service BI mean? Essentially, it is a business intelligence platform prepared by the IT department, which gives various specialist departments such as sales, finance or warranties the opportunity to carry out independent data analyses directly and create their own reports.
Mazda Austria realised that a business intelligence system only makes sense if users can independently prepare and analyse the data required for their work processes – all within a short space of time. For a long time, the company worked with an Excel-based reporting system that could only be serviced externally. If, for example, a new vehicle model was introduced at Mazda, the corresponding data had to be imported (integrated) via an external service provider. This was, of course, as cumbersome and time-consuming as it sounds
Trivadis implemented a new data warehouse and BI system for Mazda Austria with the standard Oracle Data Integrator (ODI) and Oracle Business Intelligence Enterprise Edition (OBIEE) software products. During intensive workshops, the target architecture for central data storage and data management was developed together with Mazda and implemented by Trivadis in several development stages. This then served as a basis for BI reporting and also enabled the metadata models, BI analyses and dashboards to be implemented:
In the individual departments, analysts were trained in business intelligence. These analysts have direct access and the relevant permissions and can create reports according to their expectations. As a result, the BI system can be used efficiently by all departments – from vehicle sales, spare parts management, to the warranties, finance or sales planning departments through to the marketing department.
“A self-service BI solution is shaped by several factors for success. A central and consistent database – also known as a “single point of truth“ – ensures that authorised employees in an organisation can quickly access the right data and, above all, use consistent figures. An almost self-explanatory reporting front-end and solid user training enable the business departments to evaluate relevant data in self-service mode and also interpret results correctly,” reports Günther Krobath, BI manager at Trivadis in Vienna.
The BI system was first introduced at the headquarters in Klagenfurt and then gradually integrated into department by department and rolled out in 17 central European countries. The individual country organisations were excited about the possibilities when presented with the newself-service BI solution.The web interface is intuitive to use and the data can be accessed from anywhere: from the office, from home or while out and about. The system’s speed can also be derived from the following key figure: In the past, it took a total of eight hours to load the system (with relatively little data), and now the BI system loads with a great deal more data within one hour.
The new BI solution creates true added value for Mazda Austria because now employees can analyse corporate data from different perspectives and use it to make important decisions.
Hans-Peter Petek, information services manager, Mazda Austria
Mazda’s close and strong cooperation with Trivadis was a key factor in the project’s success. The basic pillars of the solution architecture were coordinated at the beginning of the project and the BI system was specified, implemented and put into practice in several agile iterations. The early involvement of the specialist departments enabled a high level of user acceptance for the database provided. The accompanying training of end users with the newBI front-end supported a quick introduction to the BI tool and the independent creation of reports.The excellent communication from the BI manager concerning the project’s progress using newsletters and BI project marketing articles brought the project to a successful conclusion at Mazda Austria.
Mazda operates an international sales, marketing and logistics organisation in Klagenfurt for the wholesale of cars and spare parts. With around 110 employees, Mazda Austria supplies a total of over 400 retail and workshop partners in 21 countries with cars, spare parts and mobility services. Mazda Austria GmbH is a subsidiary of the listed Mazda Corporation based in Hiroshima, Japan.