Now you know you like the Legal IT Insider Top 200 Charts, so you are going to love this… DW Reporting has utilised a superb feature in Microsoft Excel 2013 called Power Query. Power Query, a free Excel add-in, allows you to perform searches against the web and retrieve data in a tabular form, returned and self-formatted in Excel. Once the data was made available DW simply created a dashboard (for the example above Qlikview was used) but the view can also be replicated in Microsoft Power View, another Excel 2013 add-in.

For more details contact DW Reporting. Founded by Dan Wales and Lawrence Watkins and established as a full time consultancy in 2013, London-based DW Reporting specialises in practice management software and reporting/BI solutions within the professional services industry.