Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Postal code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
OXXO is only available in Mexico.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Job titles must be less than 50 characters.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
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
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.
Lincoln SSUG is a local PASS Group. We strive to connect SQL Server Professionals and facilitate SQL Server educational opportunities through monthly meetings and hosting SQL Saturday events.
This year's SQL Saturday will be held Saturday, October 27th at E.T. Mahoney State Park. For details and registration: http://www.sqlsaturday.com/767/eventhome.aspx
Be sure to register visit our website http://lincoln.pass.org. To receive our newsletters visit http://pass.org, register for free, then add Lincoln SQL Server User Group to your chapters.
Share Practical Self-Service BI with PowerPivot for Excel-William E. Pearson III
Share Tweet