Columbus GA
SQL Server Users Group

 

 
 Next Meeting
Tuesday May 28th  6:00 PM - Columbus Public Library

An Overview of PowerPivot for Excel

Synopsis: In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores “selfservice BI” as a concept. He then provides a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. “There’s no service like self-service ….”   This session applies equally to SQL Server and Analysis Services 2008, 2008R2 and 2012 data sources.

Objectives:

1. Impart an understanding of Self-Service BI, including the advantages and the challenges that accompany its introduction into the enterprise

2. Overview the architecture and uses of PowerPivot for Excel 2010 within the organization to support self-service BI.

3. Explore and demonstrate the assembly of data from diverse sources into models that deliver business intelligence upon demand, including exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct PowerPivot applications that support analysis and reporting throughout the enterprise.

Bill Pearson, SQL Server Analysis Services Maestro, SQL Server MVP, CPA,

CITP, CMA, CIA, MCDBA, MCSE, is a consultant, author, mentor and business intelligence architect who has been working with business intelligence for over 18 years, and with the integrated Microsoft Business Intelligence solution since its inception.  Bill has been awarded the Microsoft Most Valuable Player multiple times for his technical experience implementing

Microsoft BI, as well as his contributions to the community as an author and speaker.  Bill’s recent series’ include the Stairway to MDX and Stairway to PowerPivot and DAX columns at SQLServerCentral.com, and he presents regularly at SQL Saturdays and other diverse events worldwide.  Bill is a member of the Boulder BI Brain Trust.

******************************************

See you then, and don't forget to friend Columbus PASS on facebook (http://facebook.com/columbussql).

Tim
 Announcements

Training Opportunity!
 

SQL Saturday's are fantastic ways to meet others in the SQL Community as well as learn more about SQL Server.  SQL Saturday follow the same format as the PASS Summit with multiple sessions per hour to chose from.  These are regional events and they happen within driving distance of Columbus GA many times per year.  Check out http://sqlsaturday.com/ to see when the next meetings are.

Also are you on Twitter?  There is a huge SQL Community on Twitter.  Did you know you could tweat #sqlhelp to ask others questions?  Did you know #sqlpass is also available to ask questions regarding SQL PASS or any of the SQL Saturday events?

In my opinion one of the BEST training events is the PASS Summit.  http://www.sqlpass.org/  Check out the event.  There is still time to register.  The best of the best will be holding sessions from very basic T-SQL skills to the most advanced skillsets with BI, SSRS, SSIS, etc.  The Summit is a must attend kind of event.  We have at least 5 folks from our PASS chapter that are attending.
 Sponsors