PASS Business Analytics Virtual Chapter November Meeting – 13 Excel features that Database developers should know about
Posted by denglishbi on November 12, 2014
The next PASS Business Analytics Virtual Chapter meeting is coming up and in fact it is tomorrow! This month we welcome Microsoft SQL Server MVP Kevin Goff who is going to go over the baker’s dozen Excel features that database developers should know about.
Abstract – 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 Power Pivot, Power View, Power Query and Power Map 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!
Bio – 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.
–> REGISTER NOW <–
Just a reminder if you want to stay in touch with the PASS BA Virtual Chapter here are some ways:
If you are interested in speaking we are always looking for speakers, please leave a comment or send me an email at firstname.lastname@example.org