Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

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.

November 13 – The 13 Excel Features that Database Developers should know aboutBAVCLogo (1)

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:

image

image

image

If you are interested in speaking we are always looking for speakers, please leave a comment or send me an email at denglishbi@gmail.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: