4th - 7th May 2016



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

Scraping Website Data using Power Query 05 Feb 2016
In Power BI and more specifically Power Query, there is a simple, out of the box Web connector that enables you to scrape data from a website.  This blog will show you how to achieve this in both Power BI desktop and through Excel. Power BI Desktop 1.      Open a Power ...

SQL - Using The MERGE Statement To Apply Type 2 SCD Logic 04 Feb 2016
Introduced in SQL 2008 the merge function is a useful way of inserting, updating and deleting data inside one SQL statement. In the example below I have 2 tables one containing historical data using type 2 SCD (Slowly changing dimensions) called DimBrand and another containing just the latest ...

Forecasting: R and SQL Server 2016 20 Jan 2016
Forecasting is pretty crucial to any business as nearly every function within a company needs an estimate of what the future will look like as a foundation to create and update plans. In a previous blog I addressed the principles and methods of forecasting and in this blog I will go through how you ...

Deploying to SQL SERVER 2016 from source control 13 Jan 2016
This is a quick blog to help others avoid what I went through while trying to deploy a DB from TFS to SQL Server 2016 with no success. Apart from the usual option of backup/restore there was no other viable way of deploying through source control. Visual Studio would throw an “unable to ...

Utilising R in SSRS 12 Jan 2016
With the release of SQL Server 2016 CTP3 the inclusion of R has been a powerful and welcome addition. As R can now be directly queried from inside SQL Server Management Studio (SSMS) one can now use the data outputs from R in SQL Server Reporting Services (SSRS) thereby utilising the power of R in ...