tim_kent.jpg

Tim Kent

Tim is the joint owner of Adatis, a specialist Microsoft Business Intelligence Consultancy based in the UK.  He has been working with SQL Server and in particular the BI stack for more than 10 years.  He specialises in Analytics, Reporting and data visualisation techniques and campaigns frequently against the use of pie charts!  Tim was first awarded the MVP for SQL server in 2009
http://blogs.adatis.co.uk/blogs http://blogs.adatis.co.uk/blogs/MainFeed.aspx

A look at the principles of Dashboard and report design design and how to achieve them with SSRS

Blog posts RSS

Query Folding in Power Query 10 Aug 2016
Query Folding in Power Query isn’t an entirely new concept but when I first heard of it, I thought “What is Query Folding”?  There are probably a number of you out there who think the same, so let me explain it. When carrying out transformations (e.g. Sort) in Power Query, it is possible that ...

Azure ML Regression Example - Part 1 Preparing the File 05 Aug 2016
This blog series will give you a quick run through of Azure Machine Learning and by the end of it will have you publishing an analytical model which can be consumed by various external programs. This particular blog will focus on just preparing the file before we will look at training the model in ...

Query Parameters in Power Query – Part 2 02 Aug 2016
As promised, here is Part 2 of Query Parameters in Power Query.  My last blog demonstrated how this feature (released in April 2016) could be used to reduce the data volumes in your PowerBook.  This article focuses on how you can easily switch between different parameter values and ...

Update queries in Azure SQL Data Warehouse 14 Jul 2016
  I’ve recently started working on a project where we working in the cloud with Azure SQL Data Warehouse: “Azure SQL Data Warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational”  For more information about Azure ...

Introduction to Dynamic Data Masking 06 Jul 2016
What is it SQL Server Dynamic Data Masking is a new feature which has been released with SQL Server 2016. It is designed to allow the creation of a pre-defined rule which can be applied to the data in a column limiting the exposure of the actual data. For example, if you have the following ...