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

Sign in to Subscribe

Meeting Details

The 13 Excel features that Database developers should know about

Thu, Nov 13 2014 17:00 UTC

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

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids