Author Archives: Terry McCann

About Terry McCann

Data warehouse/Big data/Data science consultant for Adatis consulting limited a Microsoft Data & Analytics consultancy. Passion for advanced data analytics and automation. Specialising in Microsoft BI architecture. Frequent speaker at SQL Saturdays in the UK and Europe. Organiser of the Data Science user group in Exeter and previous co-organiser of SQL Saturday Exeter. 

January meeting – Friday 16th January 2015

This month the user group is on a different day!

Hi Everyone,

Firstly let me wish you all a happy new year!

In January we will be running the UG on Friday 16th January (at the Jury’s Inn In Exeter – starting at 17:30).

SQL Skills session selection 2015
We have been very kindly offered a chance to have a couple of remote sessions for SQL South West members from SQL Skills ( during 2015, so here are the options so that we can try to get the most popular content to you.

The session date will depend on which session is selected and the availability of that speaker during the year. We’ll collate the results of your votes during January and then work with SQL Skills to schedule the sessions as close as possible to our normal third Thursday of a month.

You can select your favourite sessions using the form in this link- here are the options.

January sessions
We are starting the UG off in 2015 in a big way, with two speakers focusing on great BI topics.

Session 1
Our first session will be from Prathy Kamasani ( T ), a BI Consultant with DataSciences Consulting. Prathy will be presenting on “Loading Dimensions with SSIS

Abstract: There are many different ways of using SSIS to load data into a Data Warehouse. To populate a simple star schema it is quite easy to use an SCD transformation task  in SSIS. But when you want to handle advanced Data Warehouse requirements such as Type 3 SCDs, auditing execution details, error logs and fast performance, the SCD transformation makes it difficult. In this session I will present a pattern which can handle these in a scalable , efficient way in SSIS.I will also show how this pattern will benefit us when we use the Kimball audit model ,SSISDB and the SSIS catalog in SQL Server 2012.

Session 2
Then for the second half we have a session from Chris Webb ( B | T ). Chris is a seasoned presented, author and SQL Server MVP. Chris will be presenting on “Everything you wanted to know about Power BI but were too afraid to ask“.

Abstract: You’ve probably seen a lot of Power BI demos and been wowed by 3D maps, cool dashboards and tales of working with millions of rows of data in Excel. But do you actually know what Power BI is? Where does Office 365 fit in? Does your data have to be stored in the cloud? Which versions of Excel do you need? How does it compare to corporate BI tools like Reporting Services and Analysis Services? This session will answer all of these questions and more, and help you understand whether Power BI is right for you.

SQL Saturday Exeter 2015
We are close to announcing more details about sessions. Make sure you attend the January UG to receive your UG discount code for the Friday pre-conference sessions.

New year’s resolution to start presenting? Or just have something you want to talk about? Let us know!

See you all on Friday (Not Thursday! :S)
All the best