£895 + VAT for most venues (£995 + VAT for London)
SQL Server Analysis Services now comes in two varieties: multidimensional or tabular models. This course covers the former (creating multidimensional models, which until version 2012 was the only method possible in SSAS).
This 3-day course shows you how to build "cubes" of the data tied up in your data warehouse or day-to-day transactional database, and use these to monitor KPIs, perform data-mining and much more. On the course you'll learn how to create dimensions and hierarchies, how to build and deploy cubes, and how to write MDX to analyse your data.
Stephen Collings (Greater Manchester Fire & Rescue Service)
Jennifer Alexander (Pipex)
Sam Stonier (Greater Manchester Fire & Rescue Service)
Amreek Dhillon (NHS North of England Commissioning Support Unit)
Jelili Alao (JO Informatics Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
You should only attend this course if you have either attended our two-day introduction to SQL course or if you are comfortable creating queries using SQL. You should also have a good understanding of what a relational database means.
This course is suitable for those using either SQL Server 2012 or 2008 R2 (there are very few differences between the versions, at least for multi-dimensional models).