564 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
We run classroom and live online training courses with small course sizes in SSAS Tabular Model.
We currently run the following scheduled SSAS courses:
Everything was simple in the Analysis Services world before SQL Server 2012 came out. When you installed SQL Server, you got:
|SSRS (Reporting Services)||Create reports|
|SSIS (Integration Services)||Extract, transform and load data|
|SSAS (Analysis Services)||Create cubes to show information from data warehouses|
From SQL Server 2012, Analysis Services split into two parts:
|Version of SSAS||Language used for calculations|
What's important to realise is that the two versions are completely incompatible. When you install SQL Server, you'll be asked which SSAS version you want to instal.
So which should you learn? You may not have a choice: if your organisation has been using SSAS since before 2012 or so, and is full of geeky people who go round muttering about cubes and dimensions, it's likely you're heavily committed to using the older multi-dimensional version of SSAS.
However, if you have a free choice (perhaps because you're evaluating or setting up SSAS for the first time), we'd recommend you choose the newer tabular model of Analysis Services. Here are some reasons why:
|Leveraging existing skills||It's likely that you'll be familiar with relational databases, which will stand you in good stead when you come to create a data model in SSAS Tabular. By contrast it's likely that you're NOT used to thinking in multi-dimensional terms, so you'll find creating a cube quite a foreign idea.|
|Ease of use||SSAS Multi-dimensional shows its age. It includes concepts like attribute hierarchies which are hard to understand and explain, whereas SSAS Tabular was written more recently, and (it appears) by programmers who also got out a bit and spoke to other humans!|
|Future-proofing||Microsoft aren't developing SSAS Multi-dimensional these days, whereas SSAS Tabular receives major updates in every new version of SQL Server.|
|DAX / MDX||DAX is slightly easier to learn than MDX (these are the two underlying languages used in SSAS for creating something called measures).|
|PowerPivot||SSAS Tabular is basically an adult's version of Power BI, so if you're familiar with Power BI Desktop (or PowerPivot) you'll have a head start.|
Given all of the above, we have discontinued our SSAS Multi-Dimensional training, and only run courses in the newer SSAS Tabular model.
If you want more detail about the differences between the two versions of Analysis Services, have a read through this blog - or have a look at more help on choosing between our Analysis Services courses.
Each of our scheduled courses (whether classroom or online) includes:
In addition, our classroom courses also include:
Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.
Here are the SSAS courses we have scheduled for the next 3 months:
All prices exclude VAT. If you can't see the dates you want, don't forget that you always have the option of arranging onsite SSAS training at your offices (we'll even provide the computers and projector).
Wise Owl don't have a data warehouse (we don't have enough data!), but if we did we'd store it using Analysis Services (Tabular), and use Integration Services to load data into it each night.
On our two-day SSAS courses we'll do our best to show you not just how to use the software, but why we're recommending particular modelling decisions. There are at most 6 people on any of our scheduled (public) courses, so there should be plenty of time for you to ask questions specific to your organisation too!
There are many ways in which we can help you learn SSAS!
SQL Server Analysis Services could be very dull if you let it be! That's why we avoid the standard Microsoft databases, and use our own make-a-mammal one instead (like build-a-bear, but less patented).
Here are the blogs we've written on SQL Server Analysis Services.
25 Aytoun Street