Speaker details
Silicon Valley Code Camp 2013
Joel Champagne
CodeX Enterprises LLC
Joel Champagne
My 25 years in the industry have been largely spent in consulting, helping clients deliver large business solutions, mostly using .NET technologies, SQL Server, SSAS and SSRS. My specialty is in the SQL space, in particular data modeling and BI, although I've been very involved with application frameworks and architecture as well.
Speaking Sessions
A SQL Server performance warehouse using the SSAS tabular model
9:15 AM Sunday Room: PSEC4502What 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.
Silicon Valley Code Camp 2013
Code Stars Summit, Silicon Valley Code Camp, AngularU (tm) are trademarks of 73rd Street Associates (Copyright © 2021)
Site Built with React and Apollo GraphQL Client and Server
Built by PeterKellner.net
Select a Past SV Code Camp Year to View
