SPEAKER DETAILS

img

Joel Champagne

www.codexframework.com
My 20 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. My company's flagship product, SQL-Hero, codifies many of the daily consulting tasks I've dealt with including code generation, tracing, reporting, and more.

Sessions

A SQL Server performance warehouse using the SSAS tabular model

Level :
Intermediate
Date :
9:15 AM Sunday
Room :
PSEC4502
Track :
Microsoft Business Intell...
Interested : (-) - Registered : (21)

Speakers: Joel Champagne

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.

Details
  • Not Interested
  • Interested
  • Attending

SPONSORS List