I assume at this point some of you are already in Seattle and even getting ready to attend Preconference Sessions. If you are, enjoy them. Many are now in the process of traveling to the conference including myself. So, if you are still looking at the schedule, consider hitting one of my sessions, including a session in the last slot on Friday. Here is the info on my sessions, maybe I will see you there.
Building a Tabular Model
4:45 PM – 6:00 PM
[BIA-208] Building a Tabular Model Database
Come learn about the tabular model in SQL Server 2012 Analysis Services and watch a model being built from “Create Project” to deployment. Microsoft introduced the tabular model in SSAS 2012. Its supporting technology is based on the xVelocity query processor, which was introduced in PowerPivot. In this session, we will create a tabular model database in SSAS using SQL Server Data Tools. We will add data from various types of data sources and build relationships between them, then extend the solution by adding calculations, measures, and hierarchies. Finally, we will cover some of the management techniques required to support a tabular model in an enterprise solution.
A Window into Your Data: Using T-SQL Window Functions
4:15 PM – 5:30 PM
[AD-319] A Window into Your Data: Using SQL Window Functions
Window functions are an underused feature in T-SQL that have been greatly expanded in SQL Server 2012. These functions can help you solve complex business problems such as running totals and ranking. If you have never used these functions or are looking to solve ranking and aggregate types of calculations without using GROUP BY, join this demo-filled session on how and when to use SQL window functions.