SSAS Tabular Video Course
This recorded video course covers the Tabular modeling in Microsoft SQL Server Analysis Services 2016 workshop.
The very content we deliver in classroom courses is now available in recorded format, at your fingertips. No knowledge of previous version of Analysis Services – Multidimensional – is required; Tabular is based on different concepts and on the DAX language, rather than MDX.
This video course was refreshed in 2016 and covers all the new features introduced by Analysis Services 2016, like the new DirectQuery engine, the integrated workspace, and bidirectional filter propagation in relationships.
In order to complete your training on Analysis Services Tabular, after this video course you should follow the Mastering DAX video course. In the Mastering DAX video course, you will learn how to write complex measures and queries using the DAX language, which is just shortly introduced in the SSAS Tabular video course.
Students have access to a private discussion area where they can interact with the instructors asking questions related to the lectures and the exercises.
Curriculum
-
Presentation of SSAS Tabular Video Course
-
Presentation of SSAS Tabular Video Course
FREE
-
Presentation of SSAS Tabular Video Course
-
Slides and examples
- How to download and use the examples
-
Introduction to Analysis Services
-
Introduction to Analysis Services
FREE
-
What is Analysis Services?
FREE
-
SSAS Architecture
FREE
-
SSAS Server Mode
FREE
-
Introduction to Analysis Services
-
Installing Analysis Services
-
Installing Analysis Services
FREE
- Installing SSAS 2016
- Choosing the Account for the Service
- Conclusions
-
Installing Analysis Services
-
Guided Tour of Tabular
-
Guided Tour of Tabular
FREE
- Sample Project
- Key Points
- Project Properties
- Model Properties
-
Calculated Columns
FREE
-
Measures
FREE
- Calculated Tables
- Different Views of the Project
- Other Topics
- Querying with Excel
- Querying with Power BI
- Querying with SSMS
- DAX Studio
- DAX Editor
- Conclusions
-
Guided Tour of Tabular
-
Loading Data
-
Loading Data
FREE
- Data Sources
- Impersonation
- Loading from SQL Server
- Working with Big Tables
- Loading from SSAS
- Loading from Clipboard
- DataSource Requirements
- Conclusions
-
Loading Data
-
Tabular Presentation Layer
-
Tabular Presentation Layer
FREE
- Introduction
- What are Hierarchies?
- Naming Objects
- Sorting Options
-
Formatting Options
FREE
- Perspectives
- Table Properties
-
Display Folders
FREE
- Translations
- KPI
- Conclusions
-
Tabular Presentation Layer
-
VertiPaq In-Memory Engine
-
VertiPaq In-Memory Engine
FREE
- How In-Memory Engine Works?
- What is the VertiPaq Engine?
- Run Length Encoding (RLE)
- VertiPaq In-Memory Compression
- Conclusions
-
VertiPaq In-Memory Engine
-
DirectQuery Mode
-
DirectQuery Mode
FREE
- How DirectQuery Works?
- DirectQuery Advantages
- VertiPaq versus DirectQuery
- DirectQuery Settings
- Sample Data Partitions
- Setting DirectQuery with SSMS
- Using DAX in DirectQuery
- Query Limits
- Monitoring DirectQuery
- Real Time and Coherency of Values
- DirectQuery Scenarios
- Row-Level Security
- Conclusions
-
DirectQuery Mode
-
Handling Security
-
Handling Security
FREE
- Security in SSAS Tabular
- Role-Based Security
- Administrator Role
- Basic Data Security
- Testing Security in Excel
- Security = Filter Context
- Role-Driven Dynamic Security
- Dynamic Security Functions
- DirectQuery Security
- Conclusions
-
Handling Security
-
Relationships and Modeling in Tabular
-
Relationships and Modeling in Tabular
FREE
- Introduction
- Tabular Relationships
- USERELATIONSHIP and CROSSFILTER
- What to Store in the Model?
- Many-to-Many Relationships
- What is Ambiguity?
- Conclusions
-
Relationships and Modeling in Tabular
-
VertiPaq Internals
-
VertiPaq Internals
FREE
- Introduction
- Segmentation
-
Segment Configuration
FREE
- Data Memory Usage
- Available DMV
- Large Dimensions
- Memory Usage During Process
- Conclusions
-
VertiPaq Internals
-
Hardware
-
Hardware
FREE
- Introduction
- Buying the Hardware
- The NUMA Issue
- Running in Virtual Machines
- Conclusions
-
Hardware
-
Processing and Partitioning Tabular Models
-
Processing and Partitioning Tabular Models
FREE
- Introduction
- Deploying a Solution from SSDT
- Other Deployment Techniques
- Partitioning Strategy
- Processing Options
- Executing Process
- Near Real Time
- Conclusions
-
Processing and Partitioning Tabular Models
-
Monitoring Tabular
-
Monitoring Tabular
FREE
- Introduction
- The SSAS Process
- SSAS Configuration
- VertiPaq Paging
-
Memory Limits
FREE
- Performance Counters
- SQL Profiler
- Extended Events
- Conclusions
-
Monitoring Tabular
-
Interfacing with Tabular
-
Interfacing with Tabular
FREE
- Introduction
- AMO and TOM Libraries
- TMSL Commands
- Automating Process and Partitioning
-
Automate Deployment
FREE
- Manipulate a Data Model
- Conclusions
-
Interfacing with Tabular
-
Conclusion
- Conclusion
Training Platform
This course is conducted through our training platform which is immersive and designed to facilitate your experience.
- Anthony Orzechowski (Feb 14, 2021)
Hi. I'm nearly halfway through the class, but wanted to add some notes before I forget these ... Overall, it is well done and the instructors are clearly knowledgeable and experienced. With that said, there are a number of videos where the instructors were not prepared for the response from the system (e.g. when their DAX Studio tool did not work), rather than showing this to show users real life problems, but the instructors never updated the video with what it should look like when working correctly. This should be done. Also, the instructors sometimes assume some working dba knowledge of the student that may not exist and this causes issues understanding what is being presented. For example, the concept of impersonation is presented on how to work with it, but the concept is never really introduced for a novice. The same for the interactions between SSDT, SSAS, SSMS and the credentials, etc. This could be done more effectively for a novice with some visuals rather than words. Overall, nicely done, but definitely opportunities to update and improve including integration of the "new" 2019 SSAS features by reworking some video modules.
- – Hi Anthony,
Thank you for your feedback. As a matter of fact we are working on a new edition due to come out later in the year!
Reply by Claire Costa (Feb 15, 2021)
- – Hi Anthony,
Thank you for your feedback. As a matter of fact we are working on a new edition due to come out later in the year!
- Kenneth Barber (Dec 2, 2019)
Good course about a product that clearly still needs a lot of work. Everything is presented very clearly. However, this course lacks the usual SQLBI polish. With more careful planning, the course could have been shorter, could have avoided capturing the confusion of the instructors, and could have had fewer moments where Alberto interrupts Marco. I look forward to a possible 2nd edition of this course, which will hopefully be a better course about a better product.
- Mark Haring (Aug 23, 2017)
Great online course. Covers all aspects of SSAS tabular and gets you up and running. For a non-programmer the actual set-up of the automated processing methods of the SSAS databases (via SSIS, SQL server Agent or PowerShell) is not really clear. This seems understandable as a lot of topics need to be covered.
- Darren Weinstock (Jun 5, 2017)
I give it a 4.5. I think a conclusion chapter would be great! Overall great job guys! Look forward to completing your SSAS 2016 book and the Mastering DAX recorded course! Keep up the good work.
- – Thanks for the feedback! We will consider it in future revisions.
Reply by SQLBI (Jun 5, 2017)
- – Thanks for the feedback! We will consider it in future revisions.