Developing, Deploying, and Managing a Tabular Data Model in Microsoft SQL Server 2014
In this lab, develop a tabular project based on the Adventure Works data warehouse. Specifically, it will enable sales performance analysis and monitoring of reseller sales compared to sales quota. Work with the entire development lifecycle including the creation of the Tabular Project, the importing of data from both Microsoft SQL Server and an OData data feed, the enhancement of the data model, and the implementation of business logic with measures and a key performance indicator (KPI). Once you have explored and tested the data model, enhance it with perspectives, partitions and a security role. Finally, deploy the project to a tabular instance of Analysis Services. Note that the estimated time to complete this lab is 90 minutes, and it is possible to break down this long lab into shorter activities, allowing you to (re)commence from any of the seven exercises.
Click here to run this lab in a Virtual Machine.
Click here to view the lab manual