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 (http://sqlha.com/) 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):
https://projectbotticelli.com/knowledge/what-is-mdx-current-member-function-video-tutorial?pk_campaign=tt2013cwb

clip_image002

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 http://www.technitrain.com/courses.php

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 http://www.technitrain.com

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

SSAS Multidimensional and MDX Training in Australia

This is just a quick post to mention that this summer I’ll be running two courses in Australia, one in Sydney on July 23-26, and one in Melbourne on July 29-August 1, in association with the folks at Wardy IT. The course content will cover all things Analysis Services Multidimensional: there’ll be one day on SSAS cube design, two days on MDX queries and calculations, and one day on SSAS performance tuning; you can see the full course outline here. It’s aimed at intermediate-to-advanced SSAS developers who want to deepen their knowledge and learn best practices. I’m really looking forward to it, and I hope to see you there!