“When I joined BAM Woningbouw in 2009 I quickly realized the existing information platform was not up to scratch. For several years a data warehouse initiative was in place to get rid of the vast and complex use of Excel for all internal and external reporting and analysis. The workgroup of controllers that led this initiative from a functional requirements perspective was at best demotivated. Basically, the introduction of the data warehouse and other BI tooling not only came at great cost for the organization but had not been able to get rid of a single Excel application. The dependency on the IT organization had only grown and the run time of programming was too high The result was a black box with low flexibility, insufficient scenario capabilities and an unacceptable performance.”
Korstiaan Rietveld, Director of Finance
Download to read what happened
The integration process between Océ and Canon touched almost every aspect of the two organizations. The finance department not excluded. Both Océ and Canon organized their budgeting and forecasting process in a different way. The formats differed both in terms of detail and reporting requirements. Looking at the current systems both companies had in place, it was clear that these would not be flexible and fast enough to incorporate both models. Also, given the amount of data and complexity, it was clear Excel would not suffice, not even for an intermediate solution. Reducing the impact on IT to the minimum the finance department had to look for a more creative solution.
Jan van de Grint, Business Process Manager Business Intelligence at Canon.
Download to read what happened
“Encouraged by our first findings with Jedox our state of mind was very much: let’s just do it. See how far we can get on our own with a little help from Celcus. This was our attitude throughout the whole project and still is. It paid off in terms of not being dependent on external help and obviously the costs. Amazing to see that Jedox has managed to seamlessly integrate three types of interfaces: Excel, web and iPad. As our company required the use of iPads it’s a great advantage you only have to design the application in web and have the iPad ready to go. We’ve proved the fact that a good and fast performance management platform doesn’t have to be expensive.”
Albert de Boer, Information Manager at Nooteboom Group
Download to read the full story
“For Merford, Jedox provides a very versatile environment for analysis and planning. Great value for money. The training provided by Celcus enabled a steel learning curve. Due to the pragmatic and result driven approach the first results were visible within no time. Merford uses Jedox for both financial reporting, analysis and business planning.”
Hendrik Pot, Financial Director at Merford
“Michel’s mentorship, support and coordination appeared to be crucial. He’s perfectly aware of all capabilities and is a creative thinker – not only on the technical aspects, but just as much from our business perspective. He is a real consultant understanding both IT and business sides of the case and therefore can add high value to the projects!”
Vojta Rosina, Finance BI Manager at Avery Dennison Europe
“My team was immediately convinced about the strength and quality of Jedox. The depth and flexibility of the system clearly produced better results for all our controlling activities: planning, rolling forecasts, allocations… The whole team followed the training which was clear and practical and we are planning to apply Jedox extensively from now on.“
Arno van Geet, Financial Director, Allianz Group Netherlands
“Analysis and reporting needs have not only increased but have become more complex. To accommodate the growing need for intelligence and performance management I have experience with a number of systems: Oracle, SAP, access… and obviously Excel in combination with VBA. The technical limitations and disadvantages of these tools made me seek out for a better solution. Today we use Jedox to connect to various systems including SAP and it is at the hart of our information delivery”
Martjan Pols, Controller & BI specialist, Allianz Group Netherlands
Municipality de Bilt
“Celcus has done a great job in creating a truly integrated solution for all our planning & control activities. Basically it contains all our historic financial data and facilitates a monthly rolling forecast for all our expenditures. It not only allows the management of the municipality to steer financially but also in terms of human resources, service norms and so forth: no more surprises. The ‘can do’ mentality Celcus showed proved very helpfull in extracting all the underlying operational systems, especially in aligning all parties involved. As we move forward we will add more functionality and increasingly take responsibility for the implementations and maintenance of the platform”
Bonne Hylkema, Controller De Bilt
“Business Performance Management means sharing the right information at the right time with the right people in the right format. IBM and Celcus enable us to manage our Business Performance in the “G4S Way”, with better insights in G4S processes and faster decision making. The developed TM1 tooling captures the corporate information knowledge and let’s users easier analyze and gain better understanding in the management information provided. The pragmatic and hands-on approach of IBM and Celcus were a vital element in the realization of our goals for a successful implementation at G4S.”
Berend Jan van der Wal, Business Controller G4S
Due to the central location and their specialized staff, the University Medical Centre Utrecht is one of the busiest trauma centers in the country. On an annual basis, thousands of trauma patients are admitted through the emergency department for often multi-disciplinary treatment of their injuries. Other than providing the best possible treatment and care for these patients, the UMC Utrecht invests in detailed scientific research and performance management within the trauma care chain. With Jedox, Celcus has now provided them with a powerful tool to streamline their data collection, reporting and analysis processes.
Typically, a hospital’s information systems are not suited for the detailed data collection and analysis of specific patient populations and only provide the means for registration and storage of basic logistics and patient data. These are stored as both structured data (e.g. emergency department visit log, lab results, admission times, etc.) and unstructured data (e.g. emergency room reports, treatment reports, diagnostic reports, etc.). Furthermore, in order to create insight into the full trauma care chain, the integration of third party data (e.g. pre-hospital ambulance data from emergency services) is also required. Therefore, the detailed collection, often done manually through spreadsheets or local standalone relational databases, and analysis is time-consuming and cumbersome.
By placing Jedox at the center of these processes, collection and analysis of trauma data will be streamlined and integrated. By connecting to the relational data sources (internal and third party) ETL can automatically collect and load structured data, while write back functionality still provides users with the opportunity to collect and register the unstructured data directly in the multidimensional cubes. Meanwhile, data validation and a structured workflow guides the detailed registration process from identifying patients, to loading or registering data, and the monitoring and approval by the responsible medical specialist. Finally, standardized dashboards and dynamic reports through web and flexible ad-hoc data discovery through the Excel add-in provide analysts with the means to perform any kind of required data analysis.
At Shanks the choice for Jedox was sure and certain. It was chosen because it is so intuitively without any loss of functionality: a recipe for very low implementation costs. It only took us two weeks to install Jedox and deliver of the first set of reports. Fully on our own without any outside help. Since then, three members of the finance business intelligence team have had a two-day Jedox training to enlarge our self-sufficiency. This means we can continue to build reports, dashboards and extract data from our ERP systems by ourselves.
Another important reason to choose for Jedox is that our prior tool only offered business intelligence functionality. Besides reporting on actuals it is very important for Shanks to have a clear view of what is going to happen. By adding data entry fields we have designed our applications to allow people to share their expectations, forecasts and planning.
Six months after the implementation of the first BI reports, the finance business intelligence team also fully supports performance management processes like budgeting, forecasting, quarterly reviews and a 5-year planning. Jedox has become our number one tool.
Looking back, the strong integration with the familiar Microsoft Excel has proved to be important to convince financial controllers and the finance director of the power of Jedox.
Gianni Eggermont, Head of Finance Business Intelligence
“We have managed to increase consciousness in the area of finance and risk and the ability to act accordingly: on every business level our people are lowering risks and minimizing costs. Jedox has worked as a catalyst to make this happen.”
Paul de Hair, CFO VolkerRail
For the full story: Celcus Case VolkerRail
Eurocommercial Properties N.V.
Miljoenen huishoudens in Europa gebruiken dagelijks de producten van Burg Groep. Dit internationaal opererende familiebedrijf produceert onder andere azijn, limonadesiropen, reinigingsmiddelen, waaronder schoonmaakazijn en vloeistoffen voor gebruik in en om de auto.
Investeringen in gebouwen, machines en de inrichting van het fabricageproces is van groot belang voor de uitvoering van de groeistrategie van Burg Groep. Mede hierdoor is de noodzaak van een betrouwbaar, gedetailleerd, lange termijn plan voor de toewijzing en controle op investeringsbudgetten de afgelopen jaren sterk toegenomen.
Burg Groep zet performance management technologie in voor inzicht en sturing van investeringen. Via een web applicatie leveren verschillende medewerkers en disciplines een bijdrage aan lopende en toekomstige investeringsprojecten ten behoeve van CAPEX planning.
Roll based security bepaalt wie bepaalde informatie mag zien en/of invoeren. Denk aan aanschafprijzen, lease opties en planningen. Workflow bepaalt wie verantwoordelijk is voor de invoer en wie uiteindelijk goedkeuring verleent voor het vrijgeven van een project. Dit kan de Raad van Commissarissen zijn, het bestuur of een lager beslisniveau. Alle betrokken medewerkers van een project beschikken over een ‘inbox’ met een overzicht van alle workflow taken en wanneer die uitgevoerd moeten worden.
Alle invoer wordt centraal vastgelegd en gebruikt voor allerlei rapportages, analyses en een dashboard. Dezelfde snelle, centrale database bevat ook realisatiecijfers die automatisch ontsloten worden vanuit het financiële ERP pakket. Zodoende kan een rolling forecast gemaakt worden (latest estimate) met de meest recente realisatie cijfers bij de hand. In verschillende valuta’s en ‘bevroren’ versies.
‘Afwijkingen ten opzicht van budget zijn direct te zien. Onze bedrijfsleiders zijn nu in staat om hun vijf tot tienjaren investeringsplannen te finetunen en te optimaliseren en daarbij overzicht te houden over alle geplande projecten. De inzet van performance management technologie verhoogd de grip op al onze investeringen en toekomstige cashflow. Op de korte termijn realiseren wij grip op onze investeringen, maar op de lange termijn zien wij kansen om performance management ook in te zetten voor de totale financiële performance van Burg Groep. De juiste keuzes maken op het juiste moment, kan onze groeiambities verder versnellen. Familiebedrijven gaan voor continuïteit op de lange termijn, maar vinden een mooi rendement zeker ook belangrijk. Het rendement denken, kunnen we versterken door het inzetten van performance management systemen.’: Arjen Pauzenga, CFO Burg Groep.
(Nederlands) Celcus case – Bindinc