If you have used data modeling in Power BI or PowerPivot, you have used the tabular Model. The difference is a self-service BI application versus an enterprise database everybody with permissions can use.

This session starts with the architecture of Analysis Services (SSAS) for the Tabular Model. The flow continues with Data Sources, Data Sets and Relationships. The Dimensional Model database structure will be used to demo dim and fact tables in the database.

Measures will be created along with DAX functions to show the power of SSAS. The ever important Date Table will be demonstrated as well as Time Intelligence functions. We conclude the session with security and reporting with Excel PivotTables and Power BI.