Building Your First Tabular Model
With the release of SSAS 2012 Microsoft has introduced a new BI storage engine. In addition to the traditional OLAP engine you now have the option to build your BI models on top of the new Vertipaq engine (This is the same engine used by PowerPivot.) To use the new xVelocity engine you build a Tabular data model. A new query language DAX (Data Analysis Expressions) is used to create calculations, measures, and KPI’s. DAX is similar to the expression language used in excel and it should be easier to use than MDX and appeal to a broader audience.
This session is designed to introduce you to the process of building a tabular model in SQL Server Data Tools (BIDS rebranded).