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

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 passbavc@sqlpass.org

Thanks!

The 13 Excel features that Database developers should know about

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

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 Goff

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
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids