9:15 AM Sunday
Silicon Valley Code Camp : October 5th and 6th 2013session

A SQL Server performance warehouse using the SSAS tabular model


About This Session

What if you could take performance data related to SQL Server (and we'll touch on non-SQL Server sources as well) and collect it into a data warehouse that's implemented using the SQL 2012 SSAS Tabular Model? You'd be able to build virtually an infinite number of reports using tools such as Excel 2010+. You'd be able to consolidate different kinds of metrics and define your own KPI's. In this session I'll show you the work I've done to accomplish this, codified in the SQL-Hero product. You'll understand the concepts involved so you can roll your own solutions, or you'll see enough to get up-and-running quickly if you choose to use SQL-Hero. Along the way, you'll also learn about SSAS, PowerPivot and DAX; plus we'll touch on SQL Server Extended Events and some handy DMV queries.

Time: 9:15 AM Sunday    Room: PSEC4502 

The Speaker(s)

undefined undefined

Joel Champagne

Owner , CodeX Enterprises LLC

Data architect, data tool developer, consulting, BI, etc.