The PASS Business Analytics Group provides virtual training on the tools and architecture patterns required to create world-class Business Analytics solutions.

Login to Subscribe

News and Updates

Join us today - become a member of the Business Analytics Virtual Group.

Sign up for a free PASS membership and choose the option to join the BA Virtual Group in the myPASS portal. We'll keep you posted of all upcoming meetings, learning opportunities and the latest and greatest info from Microsoft.

Interested in speaking at an upcoming BA VG webinar?

Send us your information by completing the Call for Speaker survey here and we will follow up with you or you can contact us today to let us know by email using


The Baker’s Dozen: 13 tips for KPIs with the Microsoft SQL/BI Stack

Thu, Feb 20 2014 17:00 UTC

The Baker’s Dozen: 13 tips for KPIs with the Microsoft SQL/BI Stack

In this webcast, I’ll present 13 tips for designing and creating Key Performance Indicators (KPIs) using the Microsoft SQL BI Tools. I’ll cover a bit of practical theory on KPIs and balanced scorecards, and then dive into some specific examples of basic KPIs, trend-based KPIs, data-driven KPIs from actual applications. I’ll also cover some recommended practices for creating KPIs. Along the way, I’ll use SSAS OLAP, SSAS Tabular, Reporting Services, Excel, and PerformancePoint Services to demonstrate the creation and surfacing of KPIs.

Kevin Goff

Kevin S. Goff ( is a Microsoft SQL Server MVP Database architect/developer/speaker/author Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics Frequent speaker at community events in the Mid-Atlantic region. Host of BDBI Radio (, a weekly webcast on SQL/BI topics

Follow us on Twitter: @PASSBAVC | Contact us: PASSBAVC@SQLPASS.ORG
Back to Top