" rel="stylesheet">
Skip Main Navigation
Page Content
This event has ended

#SQLsatROC Precon #1: Practical Self-Service BI with PowerPivot for Excel

Rochester PASS SSUG

Friday, June 20, 2014 from 8:30 AM to 4:30 PM (EDT)

#SQLsatROC Precon #1: Practical Self-Service BI with...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Regular Price Ended $129.00 $4.22
Early Bird Ended $109.00 $3.72

Who's Going

Loading your connections...

Share #SQLsatROC Precon #1: Practical Self-Service BI with PowerPivot for Excel

Event Details

Practical Self-Service BI with PowerPivot for Excel

SQL Server MVP and Business Intelligence Architect Bill Pearson leads this full-day, hands-on introduction to using PowerPivot for Excel to deliver self-service business intelligence.  The focus of the course is to help those new to PowerPivot to become familiar with the assembly of data from diverse sources into models that deliver business intelligence upon demand.  Participants will gain exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct and share PowerPivot applications that support analysis and reporting throughout the enterprise


Presenter: Bill Pearson, MVP (SQL Server BI), 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 atSQLServerCentral.com, and he presents regularly at SQL Saturdays and other diverse events all over the United States and elsewhere. 

Course Objectives

Upon completion of this course, attendees will be able to: 

  • Assemble and relate data from diverse sources into a PowerPivot model to support self-service business intelligence
  • Employ DAX functions to create basic calculations within the PowerPivot data model
  • Construct PowerPivot applications that support enterprise analysis and reporting
  • Understand deployment options for PowerPivot via SharePoint


Attendees with the following will benefit the most from this course:

  • Basic familiarity with the Microsoft Windows operating system
  • Exposure to Excel PivotTables and PivotCharts
  • Exposure to standard Excel functions
  • Exposure to basic relational database concepts 

Course Hardware and Software Requirements 

Course material will be provided on thumb drives. A laptop is not necessary but will help you take advantage of the course better.  If you wish to bring a laptop, requirements are as below.   

Cancellation policy: You can cancel or request refund 48 hours before the event. Full payment is due at the time of registration.



Coffee will be available in the morning and meal cards will be provided to attendees for lunch in RIT's Global Village.

Have questions about #SQLsatROC Precon #1: Practical Self-Service BI with PowerPivot for Excel? Contact Rochester PASS SSUG

When & Where

Rochester Institute of Technology
1 Lomb Memorial Dr
CIMS Building #78 (Room 2120)
Rochester, NY 14623

Friday, June 20, 2014 from 8:30 AM to 4:30 PM (EDT)

  Add to my calendar


Rochester PASS SSUG

Rochester PASS is a user group for SQL Server professionals or those interested in learning more about SQL Server in the Rochester, NY area.  

Rochester PASS is a chapter of the Professional Association for SQL Server and we seek to empower the local SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server platform.

  Contact the Organizer
#SQLsatROC Precon #1: Practical Self-Service BI with PowerPivot for Excel
Rochester, NY Events Conference

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.