New SSAS, Power BI And SQL Server Training Courses For 2016

I’ve just added a number of new 2016 training course dates to the Technitrain site. If you’re looking for Power BI, Analysis Services, SQL Server or Data Science training in London then please check them out! Also, if you’d like to sign up for the Technitrain newsletter to stay up-to-date with our news you can do so here.

Here are more details on the new courses:

SQL Server Performance Tuning and Internals Boot Camp, Bradley Ball, 15-19 February 2016, London
This 5-day hands-on course is designed to provide DBAs with the tools and knowledge that are required to keep their SQL Servers running efficiently and reliably.

Introduction To Power BI, Chris Webb, 22-23 February 2016, London
A two-day introduction to Microsoft’s exciting new BI tool suitable for BI professionals, analysts, report developers or anyone interested in using it to build reports or dashboards.
Real World Cube Design And Performance Tuning With SSAS Multidimensional,  Chris Webb, 11-13 April 2016, London
A course aimed at intermediate-to-experienced Analysis Services Multidimensional developers, looking at more advanced cube design topics and query performance tuning.

Mastering DAX, Marco Russo, 20-22 June 2016, London
A three-day introduction to the DAX language used by Power BI, Analysis Services Tabular models and Power Pivot.

Optimising DAX, Marco Russo, 23-24 June 2016, London
An advanced two-day course for experienced DAX developers who wish to learn how to optimise DAX calculations and queries for performance.

Introduction to MDX, Chris Webb, 4-6 July 2016, London
A three day course designed for those with little or no experience of MDX, this course will teach you how to write MDX queries and calculations for Analysis Services.
Practical Data Science with Cortana Analytics, Rafal Lukawiecki, 24-27 October 2016, London
This course is aimed at analysts, analytical power users, predictive developers, BI power users and developers, budding data scientists and consultants.

Technitrain Courses For The Rest Of 2015

We’re almost halfway though the year and so I would draw your attention to some of the training courses we have coming up at Technitrain. Since you are the the discerning sort of person who reads my blog, then you are probably also going to be the discerning sort of person who is interested in the kind of expert-led Microsoft BI and SQL Server training that Technitrain runs! To get regular updates on new courses, you can sign up for our mailing list here.

Introduction to Power BI with Chris Webb, June 12th, Edinburgh

I know this is only next Friday but there are still places available. It’s a one-day precon for SQL Saturday Edinburgh BI Edition, which is well worth attending too. On this course I’ll give you a full introduction to Power BI, what it is, when to use it, and where it’s going.

SSIS Design Patterns with Andy Leonard, September 7th-10th, London

If you’ve already got some SSIS experience but want to find out about design patterns, best practices, BIML and new features in SSIS 2012/2014, this is the course for you.

Mission Critical SQL Server with Allan Hirt, September 28th-October 1st, London

Allan ( is probably the number 1 expert on high availability for SQL Server, and this course will cover features such as AlwaysOn Availability Groups, true multi-site failover clustering instances, support for Windows Server Core, and what’s new in SQL Server 2016.

Introduction to MDX with Chris Webb, October 12th-14th, London

Yes, MDX isn’t cool or fashionable any more, but if you’re working with SSAS Multidimensional you still need to know it. On this course I’ll teach you all you need to know about MDX queries and calculations.

Practical Data Science – Azure Machine Learning, SQL Data Mining and R with Rafal Lukawiecki, October 19th-22, London

I’m particularly excited about this course, in part because the subject matter is so interesting (and so now) and in part because Rafal has such an amazing reputation as a trainer and a speaker, so I know it will be great. You can see a very detailed course agenda here.

Video Training

If you can’t make it over to the UK, don’t forget that a lot of my training material on MDX and SSAS has been recorded and is available on subscription at Project Botticelli, along with videos from Rafal, Marco Russo, Alberto Ferrari and others. Register with the discount code TECHNITRAIN2015 for a 10% discount.

Microsoft BI and SQL Server Courses For 2015

The Technitrain course schedule for 2015 has now been finalised, so if you’re looking for top quality Microsoft BI and SQL Server classroom-based training in central London why not check out what we’ve got coming up?

PASS Summit And Other Speaking And Training Dates

This is just a quick post to advertise some upcoming speaking and training dates…

PASS Summit

I’ll be at the PASS Summit in Seattle next week, and if you see me around be sure to say hello! I’ll be presenting a deep dive session on MDX scoped assignments at 9:45am on Friday November 7th, and I’ll be signing copies of my new Power Query book on the Apress stand in the exhibition hall at 1pm on Wednesday November 5th.

I will also be live-tweeting (I’m @technitrain on Twitter if you aren’t following me already) and blogging throughout the keynotes each day too. I suspect there will be some big announcements this year – Jen Underwood dropped some hints, and a list of interesting sessions to attend, on her blog last week.

Future Decoded

On Wednesday November 12th I’ll be speaking about Power BI at Microsoft’s Future Decoded event in London, alongside the likes of Jen Stirrup, James Rowland-Jones and assorted celebrities like Professor Brian Cox, Sir Nigel Shadbolt and David Braben (the guy who co-wrote Elite!)

Training in London

There are a whole bunch of new courses up on the Technitrain site, taught by me and various other SQL Server experts (such as James Rowland-Jones, Jamie Thomson, Klaus Aschenbrenner, Andy Leonard and Allan Hirt) from around the world, and covering a wide variety of SQL Server and Microsoft BI topics. There are still places available on my Power Query course on Thursday November 13th if you’re interested in attending.

Training in Aarhus, Denmark

In December I’ll be teaching two one-day courses with my friends at Orange Man in Aarhus in Denmark: an introduction to Power BI on December 3rd and my Power Query course again on December 4th.

Technitrain Courses In London This Autumn

I’ve just put up a bunch of new courses (including a dedicated Power Query course!) on the Technitrain site that will be running this autumn in London. They are:

I hope to see some of you there! Don’t forget you can also get 10% off on my MDX training videos and lots of other great MS BI content at Project Botticelli using the discount code TECHNITRAIN2014.

New Free Video On The MDX CurrentMember Function

New modules are being added to my MDX online training course all the time, and now there’s another free video available: a short introduction to the CurrentMember function. You can view it here (registration required):


The previous free video on MDX SELECT statements is also still available here, now with no registration required. If you’d like to subscribe to this course you can get a 10% discount by using the code TECHNITRAIN2014 when registering.

Don’t forget, if you are looking for classroom training in London for MDX, DAX, Analysis Services Multidimensional or Tabular, Power BI, Integration Services or the SQL Server engine check out

Upcoming SSAS and MDX Training Course Dates

If you’ve got some training budget burning a hole in your pocket, here’s a quick reminder of some upcoming SSAS and MDX courses I’m teaching:

Hope to see you there! If you’d like to find out about new courses by me and other SQL Server people, you can sign up to the Technitrain newsletter at

PS I’ve also got Andy Leonard coming over to London to run his ever-popular SSIS Design Patterns course too, in early September.