Classroom Training
Classroom training course - online version also available
£950 + VAT for most venues (£1,095 + VAT for London)
2 days
For anyone who is familiar with relational databases, tabular models in Analysis Services are easier to create and use than the old multi-dimensional cube models; plus they use DAX as a language, rather than the harder-to-understand MDX. Tabular models are a natural extension of PowerPivot within Excel.
This course will show you (among other things): how to create tabular models by combining tables from SQL Server, Access, Excel and other data sources; how to create DAX calculated columns and measures to extend your data mode; and how to extract data from these models using clients such as Excel pivot tables.
The contents of this course are as follows:
If time
If time
You should be familiar with how relational databases work to attend this course. You'll also find the course more difficult if you haven't used pivot tables in Excel.
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Victor Ochieng (Plan International)
Folakemi Ayoade (Bank of England)
InSun Ahn (Tokyo Electron Europe Ltd)
Jordan Byrom (Addleshaw Goddard)
Alasdair Rose (SQL North Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
View SSAS multi-dimensional or SSAS tabular blogs