SSAS Training
SSAS Tabular Model training course
£695 + VAT for most venues (£795 + 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.
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!
Course details
Locations:Manchester
Next course:Tue 29 October 2019
Time:09.30-16.30
Course Contents
The content of this course are as follows:
Getting started
Multidimensional vs tabular- Separate named instances
Visual Studio basics
- Visual Studio windows
- Setting startup options
- Creating a project
Connecting to SQL Server
- Creating and using connections
- Filtering rows and columns
Creating a data model
- Hiding from client tools
- Renaming tables/columns
- How column storage works
- How processing works
Relationships
- Diagram view
- Creating relationships
Excel pivot tables
- Analysing data in Excel
- Connecting from Excel
- Using Excel pivot tables
If time
Power BI Desktop overview
- Importing from SSAS
- Basic visualisations
- How publishing works
Other data sources
- Linking to Excel
- Pasting in data
Calculated columns
- Using IF and SWITCH
- BLANK arithmetic
- Linking tables using RELATED
Measures
- Creating measures
- SUMX, AVERAGEX, etc.
Changing query context
- The CALCULATE function
- Using FILTER
Prototyping using PowerPivot
- Using PowerPivot
- Importing PowerPivot models into SSAS
- Constraints
Accessing DAX queries
- From within Excel
- From Reporting Services
Calendars
- Creating a calendar table
- Using multiple calendars
Date calculations
- Working days
- Period to date
- Prior and parallel periods
- Semi-additive measures
Hierarchies
- Creating a hierarchy
- Viewing hierarchies
KPIs
- The parts of a KPI
- Absolute and relative measures
- Creating and viewing KPIs
Perspectives
- Creating perspectives
- Using in Excel
If time
Security
- How security works
- Creating roles
- Filtering rows by role
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.
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 546 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Phil Breeze (Sepura plc)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Scheduled SSAS - Tabular Model training dates
Here are the SSAS - Tabular Model courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Tue/Wed 29-30 October 2019 | 2 | Manchester | £695 | Book places |
| Tue/Wed 26-27 November 2019 | 2 | Manchester | £695 | Book places |
| Date(s) | Venue |
|---|---|
| 29/10 | Manchester |
| 26/11 | Manchester |
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).
Related Courses
Other Analysis Services training resources
SSAS exercises
The exercises listed here should give you some idea of what to expect from this course.
SSAS blogs
Have a look at our Analysis Services blogs for inspiration on SSAS!
View SSAS multi-dimensional or SSAS tabular blogs