This recorded video course covers the Tabular modeling in Microsoft SQL Server Analysis Services 2016.

The same content that we deliver in in-person workshops is now available – in recorded format – at your desktop. No knowledge of previous versions of Analysis Services (Multidimensional) is required, because Tabular is based on different concepts and on the DAX language (instead of MDX).

This course has been renewed 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 course you can follow the Mastering DAX Video Course. In that course, you will learn how to write complex measures and queries using the DAX language, which is just shortly introduced in this video training.

Curriculum

  • Presentation of SSAS Tabular Video Course

    • Presentation of SSAS Tabular Video Course
      FREE
  • 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
  • Installing Analysis Services

    • Installing Analysis Services
      FREE
    • Installing SSAS 2016
    • Choosing the Account for the Service
    • Conclusions
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • VertiPaq Internals

    • VertiPaq Internals
      FREE
    • Introduction
    • Segmentation
    • Segment Configuration
      FREE
    • Data Memory Usage
    • Available DMV
    • Large Dimensions
    • Memory Usage During Process
    • Conclusions
  • Hardware

    • Hardware
      FREE
    • Introduction
    • Buying the Hardware
    • The NUMA Issue
    • Running in Virtual Machines
    • Conclusions
  • 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
  • Monitoring Tabular

    • Monitoring Tabular
      FREE
    • Introduction
    • The SSAS Process
    • SSAS Configuration
    • VertiPaq Paging
    • Memory Limits
      FREE
    • Performance Counters
    • SQL Profiler
    • Extended Events
    • Conclusions
  • 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
  • Conclusion

    • Conclusion
Student Rating
4.8
19 ratings
79%
21%
0%
0%
0%

Student Reviews (19)
  • Sergey Altukhov (Feb 22, 2018)

    Great course, thanks a lot

  • Sarah Bessard (Feb 22, 2018)

    Great job ! Thanks for this training

  • Clay Seifert (Feb 20, 2018)

    This video course was outstanding. It's a pleasure to have instructors with hands-on experience in using the product because they can present the material that includes suggestions on matters to be aware of. Let me close out this review by giving my unrestrictive recommendation to those considering taking this video course. It is money well spent!!!!! Clay Seifert

  • Francisco Tapia (Dec 16, 2017)

    This a very through explanation of Tabular with SSAS. If you are familiar with Sql and are getting into business intelligence, this course is perfect for getting you started with the engine.

  • Lyn Taylor (Dec 13, 2017)

    Very helpful and well organized to understand Analysis Services. Will refer to this course as we build and deploy models.

  • 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.

  • Hans Bamesberger (Jul 1, 2017)

    I think that Alberto´s and Marco´s video courses cannot be topped. Simply the best. Not just professional content but also a lot of passion. I think after attending their course every student wants to become a BI professional. Many thanks to the twins Alberto and Marco.

  • 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)

  • VICTOR RUIZ (May 31, 2017)

    It was exactly what I was looking for! THANK YOU! EXCELENT JOB!

  • ronan dodworth (May 30, 2017)

    excellent !

  • Sadek Alaoui (May 18, 2017)

    Extremely satisfied.

  • Vanessa Cerda (May 15, 2017)

    It easy to follow, cover in detail a lot of information

Do you prefer a course in classroom?

This video course is based on a live, classroom course we teach all around the world. If you prefer a live learning experience, take a look at the dates below for a list of our upcoming events!
Sorry, there are no public courses scheduled at the moment.