This event has ended

Practical Self-Service BI with PowerPivot for Excel-William E. Pearson III

Lincoln SQL Server User Group

Friday, October 5, 2012 from 8:00 AM to 5:00 PM (CDT)

Lincoln, NE

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Regular   more info 15 Tickets Ended $119.00 $7.54

Who's Going

Loading your connections...

Share Practical Self-Service BI with PowerPivot for Excel-William E. Pearson III

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.

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 MDXand Stairway to PowerPivot and DAX columns at SQLServerCentral.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

 

Prerequisites

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.

  

·         Windows 7, Windows XP (SP3), or Windows Vista (SP1)

·         1GB RAM minimum (with 2GB RAM recommended)

·         Microsoft Excel 2010 (32-bit or 64-bit) installed

·         PowerPivot for Excel (32-bit or 64-bit, as appropriate to attendee machine) installed

·         Microsoft SQL Server 2012 installed, or available for connection

·         Connectivity available to AdventureWorksDW20012 database

·         Connectivity available to Adventure Works Analysis Services database

  

OTHER COURSE INFORMATION:

 Food:  Lunch will be provided at The Knolls Country Club.

 Recommended Hotel: The Victorian Suites http://newvictorianinn.com/ Rooms blocked under SQL Saturday.

Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $99 is due at the time of registration.

 

Have questions about Practical Self-Service BI with PowerPivot for Excel-William E. Pearson III? Contact Lincoln SQL Server User Group

When & Where



Victorian Suites Hotel
225 N 50th St
Lincoln, NE 68504

Friday, October 5, 2012 from 8:00 AM to 5:00 PM (CDT)


  Add to my calendar

Organizer

Lincoln SQL Server User Group

Lincoln SSUG is hosting pre-conference sessions for SQL Saturday 165 featuring Mark Stacey, Kevin Kline and William E. Pearson III. Be sure to also register for our FREE full day conference style event, SQL Saturday which will be held Saturday, October 6th. For details and registration: http://www.sqlsaturday.com/165/eventhome.aspx

Also be sure to register visit our website and register to receive the Lincoln SSUG newsletters by going to http://lincoln.sqlpass.org.

  Contact the Organizer

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.