This page has 0 threads | Add post

Wise Owl's Analysis Services (SSAS) Training Courses

Shaun (one of our 7 Wise Owl trainers)

Preferred venue/format

Benefits of our SSAS training

Not sure if we deserve all the reviews you can see on this site? Here are some of the things we do (very) differently to earn them.

Hidden

Friendly and professional training ... guaranteeed▼

How can any training company guarantee the quality of their courses? Here's how:

We limit our courses to no more than 6 people per class.
Unlike almost every other computer training company, we never subcontract or use freelancers - here's why this matters.

The best courseware in the industry? See for yourself▼

Our course manuals and exercises are by some way the best in the computer training industry. Fortunately you don't have to take our word for this - you can see for yourself:

See our SSAS - Tabular Model courseware
See our SSAS tabular model exercises

Genuine integrity - and good manners▼

Our values are simple - we treat people as we would like to be treated ourselves. So:

We will - almost never - cancel courses. To see what "almost never" means see our no cancel guarantee.
There's nothing worse than being pestered, so we don't pester people. Ever.
It's dangerous to be sanctimionius, but we can see no possible benefit that tobacco and gambling companies bring to the world (and quite a lot of harm), so we choose not to work for them. Sorry.

You can see more on our corporate values here.

Innovative online training platform▼

We've put a lot of thought into making our online courses as useful and interactive as possbile:

Delegates use Remote Desktop to connect to our machines, so our trainers can see everyone's screens at all time.
We arrange (without charge) a half-hour pre-course check for each online delegate before courses, to ensure that they everyone will be able to join the course seamlessly when it begins.
As well as providing a PDF of the manual and exercises for each online course delegate we will (again without charge) also post this out to each person a few days before if required.

Choose a specific course, or stay on this page to see all of our SSAS training.

Course:

We don't currently have any SQL Server Analysis Services courses scheduled. We may consider adding dates - it's always worth asking.

Alternatively, if you have a handful of like-minded people in your organisation, you could consider booking your own bespoke SSAS course, whereby you get to pick the dates, training delivery method and venue!

Our SQL Server Analysis Services classroom training venues

What other people have said about our SSAS training

Here are some comments we've received about our SSAS + training. You can see all of our 528 reviews here. We would like to sincerely thank the clients whose names are shown below for kindly agreeing to let us share their feedback.

"I really enjoyed the course. The notes that were provided are helpful as well. I use it as my guide while working. The course definitely strengthened the foundations of my knowledge with Tabular. It was able to simplify tabular concepts that I did not understand previously. I attended the Power BI Course last year and learned a lot from that training."

Gabriel Averia

Frontline Ltd

"Good structure to the course, with a good teacher. We had some good rapport too, this helped by being a 1-1 session. There is quite a lot to cover, however having the physical copy of the course content along with the files that we worked on will help me practice topics that could not be covered in depth, in my personal time. My colleague took this course several years ago and recommended it to me."

James Twigg

Sepura plc

About our SSAS training

Everything was simple in the Analysis Services world before SQL Server 2012 came out. When you installed SQL Server, you got:

Software	Used to
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
Tabular model	DAX
Multi-dimensional model	MDX

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:

Area	Notes
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.

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!

FAQs (Frequently Asked Questions

Click on any heading below to learn more.

How can I contact you with any questions?▼

You can reach us in one of the following ways:

Contact method	Details
Phone	Call us on (0161) 883 3606 and (within normal UK office hours) a friendly and helpful human will answer the phone!
Email	Send an email to our inbox and we'll aim to answer it within a couple of working hours.
Web	Fill in an enquiry form letting us know what you want to achieve, and we'll do our best to help!

Do you ever blog about SSAS?▼

Here are the blogs we've written on SQL Server Analysis Services:

Blog topic
SSAS blogs (tabular)

This page has 0 threads

Add a new post