£695 + VAT for most venues (£795 + VAT for London)
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.
This course runs in SQL Server 2016, but will be appropriate if you're using SQL Server 2012, 2014 or 2017 too. If you're in any doubt about the differences between the various SQL Server versions, ask us!
George Mason (PricewaterhouseCoopers Services Ltd.)
Mark Humphreys (Silverbear Software)
Richard Brooks (Ampetronic)
Rob Moore (Cafcass)
Emma Jellicoe (Groupe Bel UK Ltd)
There are lots more where these came from (or just refresh this page to change the quotes shown).
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.
Here are the SSAS - Tabular Model courses we have scheduled for the next 3 months:
|Tue/Wed 21-22 May 2019||2||Manchester||£695||Book places|
|Tue/Wed 23-24 July 2019||2||Manchester||£695||Book places|
|Thu/Fri 12-13 September 2019||2||Manchester||£695||Book places|
|Tue/Wed 29-30 October 2019||2||Manchester||£695||Book places|
|Tue/Wed 26-27 November 2019||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).