Classroom Training
SSAS Tabular Model training course
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.
Course details
Possible locations:London, Manchester, Online
Next classroom course:No classroom dates
Time:09:30-16:30
Course Contents
The contents 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
- 520 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
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).
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