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

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

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

Interested in speaking at an upcoming BA VC webinar?

Contact us today to let us know: passbavc@sqlpass.org

Next Meeting

Thu, Nov 13 2014 12:00 (GMT-05:00) Eastern Time (US & Canada)


The 13 Excel features that Database developers should know about

RSVP: http://bit.ly/PASSBAVC101314

The 13 Excel features that Database developers should know about

In the beginning, SQL Developers viewed Excel as the enemy – vowing to take every data entry spreadsheet and turn it into a beautiful relational database application with validations. But times have changed, and Excel has come back around, but in a different light. Business users rely on Excel for analytics out of the data we provide them (and even for data where we can’t give them a clean version). Even if developers don’t use Excel themselves, they owe it to themselves and their companies/clients to be aware of the many Excel features for “slicing and dicing” data. In this presentation, I’ll show 13 different features in Excel where knowledge will help developers to speak the same language as their users – everything from PowerPivot, PowerView, PowerQuery and PowerMap features to advanced Excel formulas and Excel “what-if” functionality. And who knows – maybe a few developers will walk away with some ideas for using Excel for some of their personal development projects!


Kevin S. Goff (http://www.kevinsgoff.net) 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 (http://www.bdbiradio.com), a weekly webcast on SQL/BI topics

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