Skip Main Navigation
Page Content
This event has ended

Practical Self-Service BI with PowerPivot for Excel w/ William Pearson III

SQL Saturday OKC

Friday, August 22, 2014 from 8:00 AM to 4:30 PM (CDT)

Oklahoma City, OK

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Early Bird Registration 73 Tickets Ended $99.00 $3.47
Regular Price 16 Tickets Ended $120.00 $3.99

Who's Going

Loading your connections...

Share Practical Self-Service BI with PowerPivot for Excel w/ William Pearson III

Event Details

Length:

1 Day

   

Language(s):

English

Audience(s):

Analysts, Reporters, Developers, Other Information Workers and CPA's

Level:

200-300

Technology:

PowerPivot, Microsoft Excel 2010

Type:

Course

Delivery Method:

Instructor-led (classroom)

 

 

 

Course Description

SQL Server MVP and Business Intelligence Architect Bill Pearson leads this full-day, hands-on introduction to using PowerPivot 2012 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.

 

Intended Audience

Information workers (business- or IT-based) involved in analysis and reporting of data, intermediate - to - advanced Excel users, practitioners that want to gain familiarity with PowerPivot to build compelling analysis, reporting applications to deliver self-service BI and for Certified Public Accountants (CPA's) looking to earn 8 hours of Continuing Education (CE) credit. 

 

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

 

Passive attendance can certainly be useful. However, to obtain maximum benefit through active participation in the course, it is highly recommended that attendees bring along a laptop loaded with the following:

 

  • 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 2010 or higher for Excel (32-bit or 64-bit, as appropriate to attendee machine) installed (Pre-Reqs installed as a part of installation, as necessary)
  • Microsoft SQL Server 2008 R2 installed, or available for connection
  • AdventureWorksDW2008R2 and AdventureWorks2008R2 database engine samples
  • Adventure Works DW 2008R2
  • Connectivity available to AdventureWorksDW2008R2 Analysis Services database sample
  • Connectivity available to fully processed Adventure Works Analysis Services database

 

Please contact instructor with questions: wep3@islandtechnologies.com

 

About the Instructor


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 theStairway to MDXand 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.

 

Have questions about Practical Self-Service BI with PowerPivot for Excel w/ William Pearson III? Contact SQL Saturday OKC

When & Where


Moore Norman Technology Center
13301 S Pennsylvania Ave
Room A/B
Oklahoma City, OK 73170

Friday, August 22, 2014 from 8:00 AM to 4:30 PM (CDT)


  Add to my calendar

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.