Baker Tilly is an accountancy and tax consultancy firm offering a broad range of services from statutory audits of annual accounts to VAT consultancy and from employment law to IT advice. The firm primarily focuses on the public sector, healthcare and larger SMEs. The firm’s four lines of business -Auditing, Tax Consulting, SME Accountancy & Consulting, and Advisory- generate a combined annual turnover of around 100 million euros.
Standing out from the crowd
Baker Tilly’s mission is to provide predictably consistent quality as effectively as possible. To boost the quality and relevance of its services, the firm launched a project in 2018 to optimize data use across the entire organization. “Many of our end products are the same regardless of who creates them, such as an auditor’s report or an audit opinion,” says Jan-Willem van Essen, IT Advisory Manager at Baker Tilly. “The difference can be found in the way you create these end products and the value that you add for the client during the process. This requires smart operations and smart use of tools. We were convinced that by optimally incorporating the latest technological developments in the field of big data and analysis, we could substantially improve our working methods and operations.”
Unstructured data processes
The firm collects massive quantities of data from its clients during the course of its auditing, control, accounting and consultancy services. “With the old system, this data would often be entered four or five times by the various lines of business and offices,” explains Jan-Willem. “There was no standardization, so everyone started from scratch every time. Data security was also patchy, as it was stored across various drives and sent via email. And these are just a few of the many internal issues that we had. Furthermore, our clients increasingly expect more from us: they want us to make it quick and efficient to provide their data and expect us to use this data smartly and securely. For all of these reasons, it was vital that we improved our data management.”
From dashboards to professional data management
Baker Tilly started by rolling out a data environment using Qlik Sense. “Our end users were very enthusiastic, although monitoring was an issue,” says Jan-Willem. “The data is untraceable, so if somebody wanted to know the source of a particular transaction, we would have to search for it manually. Furthermore, the performance was suboptimal as we had to load all of the data each and every time rather than just the amended records. Clearly, it was high time to take the next step and roll out a platform that would automate everything to do with data and substantially improve data management.”
This decision led to the set-up of the Data Factory, with Baker Tilly selecting the TimeXtender data management platform. “TimeXtender is a data integration tool that allows rapid conversion of data into practical information,” explains Jan-Willem. “TimeXtender automates data access and provides modelling and compliance tools. In short, TimeXtender enables every internal and external data source to be connected, catalogued, modelled, transferred and documented for the purposes of analysis and AI.”
Fully automated provision and presentation of data
The roll-out of TimeXtender was flawlessly smooth. Within a week, Baker Tilly had converted the entire data environment from Qlik to TimeXtender with Qlik as an endpoint. “We named the new environment Data Factory,” says Jan-Willem. “After the first week, we refined the environment and ensured that virtually no human activity is involved in the provision of data and presentation of data via dashboards. The data-provision process is now either conducted via RPA we trigger it using scripts.”
Better service in less time
This automated system gives Baker Tilly’s staff powerful tools to retrieve data sets for auditing and analysis purposes. “TimeXtender allows us to combine the various data sets into high-quality information for our auditors,” says Jan-Willem. “TimeXtender also handles validations, which are vital for auditing and control services, as well as automating and documenting the data lineage, allowing us to see how the data has been processed. This information can be provided to supervisory bodies at the touch of a button, which saves our staff and clients a great deal of time and boosts the quality of our services. We can now do smarter things with our clients’ data, which in turn allows us to give them better advice.”
Flexible and scalable
The next step for Baker Tilly is to duplicate the TimeXtender environment in the Netherlands and to create similar environments for international clients. “Within our Dutch firm, we want to distinguish between data for our internal clients –i.e. our own organization– and our external clients,” explains Jan-Willem. “We want to host our own data on the premises and our clients’ data in the cloud via Microsoft Azure, and as TimeXtender works so well with Microsoft, this can be done with just a couple of clicks. The same convenience was clearly evident during the roll-out of this environment to our international offices. TimeXtender is so scalable that all we need to do is set up a single Microsoft Azure environment for our German and American colleagues, and when it comes to the endpoints we use, TimeXtender is equally scalable and flexible. We happened to select Qlik Sense, although with TimeXtender as a data estate, you can also select other endpoints such as Power BI.We also use an Excel endpoint to enable data enrichment.”
Investment pays for itself in weeks rather than months or years
TimeXtender paid for itself within just a few weeks. “I would advise any small or medium-sized enterprise to investigate the benefits of using TimeXtender as a data management platform,” says Jan-Willem. “After all, as the volume of data that organizations have to handle increases –which it will undoubtedly continue to do in the future– aspects such as version management and data lineage will become increasingly vital for the purposes of compliance. This can’t be done with a BI application, but it is possible with TimeXtender. Therefore, I would advise any SME owners to investigate the platform, and if you do decide to implement it, select existing tools rather than building a made-to-measure application.”