Transcript Chapter Leader – Dan English

PASS BA Virtual Chapter
Presents:
“The 13 Excel Features Database Developers
Should Know About”
November 13, 2014
Email - [email protected]
PASS Business Analytics Updates
Chapter Leader – Dan English
Dan is a Microsoft SQL Server MVP, author, on the
leadership team for the MN Microsoft BI User Group, and
is the Business Intelligence Practice Manager at Superior
Consulting Services in MN.
Chapter Co-Lead – Paras Doshi
Paras is a consultant at SolidQ, Microsoft Community
Contributor awardee and Blogger. He is passionate about
helping businesses extract valuable insights from data.
PASS Business Analytics Virtual Chapter
http://tinyurl.com/linkedinpassbavc
Twitter handle @passbavc
https://twitter.com/passbavc
YouTube Channel
http://www.youtube.com/user/PASSBAVC
Nov 13 – The 13 Excel Features 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!
Presenter – Kevin Goff (@KevinSGoff http://www.kevinsgoff.net)
Kevin S. Goff 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
Azure Machine Learning - Links
•Azure ML Free to Try – https://studio.azureml.net
•Machine Learning Service - http://azure.com/ml
•Machine Learning Documentation - http://aka.ms/mlds
•Machine Learning Pricing - http://aka.ms/mlpricing
•Machine Learning Studio - http://studio.azureml.com
•Machine Learning FAQ - http://aka.ms/mlFAQ
•Machine Learning Marketplace - http://aka.ms/mlmarket
•Azure Machine Learning blog https://aka.ms/mlblog
PASS Virtual Chapters Listing
Check out the sqlpass.org for more information on all the Virtual Chapters:
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Application Development
Azure
Big Data
Book Readers
Business Analytics
Business Intelligence
Data Architecture
Database Administration
DBA Fundamentals
Excel BI*
Healthcare
High Availability and Disaster Recovery
InMemory
Master Data\Data Quality
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Oracle SQL
Performance
PowerShell
Professional Development
Security
Virtualization
Women in Technology
Global Chinese
Global French*
Global Hebrew
Global Italian*
Global Portuguese
Global Russian
Global Spanish
*New Virtual Chapters
http://www.sqlpass.org/PASSChapters/VirtualChapters.aspx
Select Virtual Chapter Meetings
VIRTUAL CHAPTER
MEETING
TOPIC
DBA Fundamentals
Nov 11 11:00– 12:00 (GMT-06:00)
In-Memory OLTP – The Ultimate
Performance Frontier with Ami Levin
High Availability and
Disaster Recovery
Nov 11 12:00-13:00 (GMT-06:00)
Introduction to Log Shipping with
Brandon Leach
Global Spanish
Nov 12 12:00-13:00 (GMT-05:00)
Recuperación de desastres y soluciones
de alta disponibilidad con SQL Server
with Michelle Gutzait
Business Analytics
Nov 13 12:00-13:00 (GMT-05:00)
13 Excel features that DB Developers
should know about with Kevin Goff
Business Intelligence
Nov 17 14:00-15:00
(GMT+01:00)
How to (not) torment your fellow SSIS
developer?
Big Data
Dec 2 14:00-15:00 (GMT-05:00)
Hive: SQL on Hadoop
SQLSaturday
Upcoming North America Events
Upcoming International Events
• Nov 1 #337
Oregon
• Nov 22 #355
Parma
• Nov 22 #350
Winnipeg
• Nov 22 #353
London (BA Edition)
• Dec 6 #347
Washington DC
• Dec 6 #359
Istanbul
• Dec 13 #354
Charleston
• Dec 6 #351
Lima
• Dec 13 #356
Slovenia
• Jan 17 #363
Nashville
• Jan 19 #360
Israel
• Jan 31 #362
Austin
• Jan 24 #346
El Salvador
Visit www.sqlsaturday.com to
register for an event near you!
Volunteering with PASS
Volunteer Today!!
Now it’s easier than ever to volunteer with PASS.
Let us know your volunteer preferences by updating the
“MyVolunteering” section of your MyPASS profile.
PASS would not exist without our passionate, dedicated,
and hardworking volunteers from around the globe.
8
PASS Volunteer Awards
Outstanding Volunteer Award
Do you know a volunteer that has gone
above and beyond recently?
Nominate them for the monthly OVA.
[email protected]
9
PASSion Award
The highest of PASS accolades presented
yearly to an outstanding volunteer.
http://www.sqlpass.org/Community/Volunteers
/PASSionAward.aspx
Stay Involved!
•
Sign up for a free membership today at sqlpass.org
•
•
•
•
Linked In:
Facebook:
Twitter:
PASS:
http://www.sqlpass.org/linkedin
http://www.sqlpass.org/facebook
@SQLPASS
http://www.sqlpass.org