SQL Server Analysis Services 2012 Tabular Workshop (in association with SQLBI)

28th May 2012 - 29th May 2012

Who is it for?

This course is aimed at BI professionals who want to exploit the full power of the new Tabular models in Analysis Services. No knowledge of previous versions of Analysis Services and Unified Dimensional Model (UDM) is required, because Tabular is based on different concepts and on the new DAX language.

What you will learn

The course agenda is as follows:

Day 1

Understanding Analysis Services 2012, BISM and the Multidimensional and Tabular models
Installing Tabular
Loading data
DAX basics
Evaluation context in DAX

Day 2

Querying a Tabular model
The xVelocity (or Vertipaq) engine
The Tabular presentation layer
Security
Deployment
Optimisation

For full details on this course, see:
http://www.sqlbi.com/wp-content/uploads/SSAS-Workshop-Course-Outline.pdf

Key benefits

This course will enable you to build your own Tabular models in Analysis Services 2012, create calculations using DAX and write queries using DAX.

Course attendees will also receive a copy of the new book "Microsoft SQL Server Analysis Services 2012: The BISM Tabular Model".

The cost of this course is £850 + VAT until May 15th 2012, and £990 + VAT after that.

Cost: £850 plus VAT

Trainer

Chris Webb

Chris Webb is the owner of Crossjoin Consulting, and is a consultant specialising in Analysis Services, MDX, PowerPivot and DAX. He is a co-author of "Expert Cube Development with SQL Server 2008 Analysis Services", and "MDX Solutions with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", and blogs at http://cwebbbi.wordpress.com/

Marco Russo

Marco is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors like financial services (including complex olap designs in banking area), manufacturing, gambling and commercial distribution. Marco is also a book author and, apart from his BI-related publications, he also wrote some books about .NET programming. He is also a speaker in international conferences like PASS Summit, SQLRally and SQLBits. He achieved the unique SSAS Maestro certification and is also a Microsoft Certified Trainer with several Microsoft Certified Professional certifications.

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG

legal disclaimer

Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 1 week before the beginning of the course are entitled to a full refund minus a £25 processing fee. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.

In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.

Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.

Calvin Ferns

Consultant, Adatis

Chris has an incredible ability to explain even the most complex logic of Analysis Services and MDX in an easy and funny way. He is one of the best Microsoft Business Intelligence trainers I've ever met.