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

Stretch Databases: The Basics 28 Sep 2016
What Is It? A stretch database is a database where the rarely used portions of the data are stored in the cloud. Offered by SQL Server 2016 alongside Azure, it will allow seamless migration of data between the cloud and your local server databases. Consider data as being warm or cold; warm data ...

Azure ML Regression Example - Part 2 Training the Model 16 Sep 2016
This is where the real fun begins! In this blog we will get to the heart of machine learning and produce a regression model. Training the model We now need to split the data into training and testing sets. This is so we can train the algorithm using the training set and then test the accuracy of ...

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 ...