Top 200 law firm Roythornes is increasing its use of Qlik to fulfil a wider-variety of requirements including complex client reporting and the automated delivery of financial and statistical analysis using Qlik dashboards for finance, business development and risk management. Roythornes has been a customer of Qlik Elite Solution Provider Informance since 2012 and it has been using Qlik to improve business agility by giving decision makers fast access to accurate information in a format that users are comfortable with.
Jonathan Swan, operations & IT director for Roythornes says: “Qlik has dramatically improved the quality of our management information and has made us much more proactive in the monitoring of our performance, so it was a natural progression for us to expand Qlik into other areas of our business. He continues: “As Informance has substantial Qlik product knowledge and an expert grasp of the legal industry we were more than happy to work with them again on these new projects.”
Since 2013 Roythornes has been using Qlik for analysis of financial key performance indicators across its property, litigation, commercial, private client and personal injury business functions and Qlik has helped the firm improve the accuracy and delivery of its financial information. The financial dashboards monitor performance in areas such as financial management trends, work-type analysis, revenue, work-in-progress, outstanding debt, productivity, utilisation, realisation and cash collection. Jonathan says: “Qlik has enabled us to proactively communicate with real impact accurate financial metrics and trends to the appropriate points of action in a timely manner and most appropriate format. Following the success of our initial financial dashboards we have since extended the use of Qlik to fulfil a wider-variety of requirements including complex client reporting and automated delivery of financial and statistical analysis”.
Roythornes also wanted to expand Qlik’s reach using automated report distribution so installed the Informance report distributor to deliver quick financial information, such as performance trends, to users with in-built exception reporting so that they are only presented with the information they need to know. Jonathan says: “The Informance report distributor has enabled us to push the right business information to the right people which has helped us introduce rules based ‘push’ features within Qlik which stimulates demand ‘pull’ from users of the system”.
Roythornes is also extending Qlik to enhance data discovery around business development and client care which includes analysing data from areas such as sources of business, cross referrals and net-promoter scores. Business information delivered by Qlik provides the metrics used to inform the overarching performance review process to visualise and recognise the value of non-financial metrics. Jonathan says: “Before Qlik, analysis of sources of business, the value of cross-referrals and client feedback were ad-hoc processes. Now the information is instantly available and we are able to drill-down from the headlines into the most granular level of detail and even into the source application from Qlik with speed and ease”.
As a Lexcel accredited firm, Roythornes is developing a Qlik risk management dashboard to visualise and alert users about potential risk scenarios with information on client risk profiles, matters, work types and fee-earners. Jonathan says: “Based on configurable and weighted risk factors we can now automate the reporting of risk profiles and use the information to improve our overall risk management. He continues: “Qlik is also being developed to make the selection of files for review more targeted in order to help further improve risk management throughout the firm”.
Roythornes is also planning to further extend the use of Qlik to customer relationship management and business development to visualise client growth, client retention, profitability and cross-selling opportunities. Jonathan says: “Our Qlik application from Informance has surpassed my expectations and it has helped transform the way we produce and consume management information. With this great product and an established skill set we have an exciting roadmap ahead and we look forward to leveraging even more value from Qlik in the future”.