£695 + VAT for most venues (£795 + VAT for London)
SQL Server Analysis Services 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 two-day course shows you how to build "cubes" to report on data tied up in your data warehouse or day-to-day transactional database, and show results from these in pivot tables, KPIs and much more. During your the course journey you'll learn how to create dimensions and hierarchies, how to create measures in MDX and how to build and deploy cubes.
The content of this course are as follows:
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 any recent version of SQL Server (there are very few differences between the versions, at least for multi-dimensional models).
Saatvik Bansal (PricewaterhouseCoopers Services Ltd.)
Harshal Vijapura (NHS Brent CCG)
Ersin Cimener (Tesco)
Andrew Lord (Marie Stopes International)
Emma Pendlebury (Guardian Industries UK Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Here are the SSAS - Multidimensional courses we have scheduled for the next 3 months:
|Tue/Wed 22-23 October 2019||2||Manchester||£695||Book places|
|Tue/Wed 17-18 December 2019||2||Manchester||£695||Book places|
|Wed/Thu 05-06 February 2020||2||Manchester||£695||Book places|
|Tue/Wed 21-22 April 2020||2||Manchester||£695||Book places|
|Tue/Wed 09-10 June 2020||2||Manchester||£695||Book places|
|Tue/Wed 11-12 August 2020||2||Manchester||£695||Book places|
|Tue/Wed 27-28 October 2020||2||Manchester||£695||Book places|
|Tue/Wed 08-09 December 2020||2||Manchester||£695||Book places|
All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSAS training at your offices (we'll even provide and set up the computers).