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

How SQL Server 2016 handles JSON 20 May 2016
Inspired by a project I recently worked on, I decided to write a short post on a subject many people will find useful, that is how SQL Server 2016 handles JSON. This post shows also some simple examples of how SQL Server 2016 can query and extract values from JSON strings.  1 - About JSON ...

Query Parameters in Power Query – Part 1 18 May 2016
A new feature has recently been added into Power Query – called Query Parameters.  This was actually released to Power BI as part of May 2016’s update. So what is a Query Parameter?  For anyone familiar with Microsoft Reporting Services, it has pretty much the same functionality as a ...

The Cloud BI Transition: Business Intelligence Key Players and their changing roles 17 May 2016
I’ve previously talked around how Azure is changing traditional BI approaches, and the various architectural frameworks we’re going to see coming out of it. But what about the existing job roles within BI Teams and related structures? How are they going to change with the new ways of working that ...

Introduction to Data Lakes 13 May 2016
Data Lakes are the new hot topic in the big data and BI communities. Data Lakes have been around for a few years now, but have only gained popular notice within the last year. In this blog I will take you through the concept of a Data Lake, so that you can begin your own voyage on ...

Slowly-Changing Parent-Child Dimensions – Part 2: The Implementation 12 May 2016
First of all, an apology. It’s always hard to recognise whether your posts are useful for people out there and this one slipped through the cracks. After several requests, I thought I’d finally get around to posting the related solution to a post I wrote 2 years ago! Apologies to anyone this could ...