Arizona SQL Saturday #193 Pre-Con: Practical Self-Service BI with PowerPivot for Excel
Friday, April 26, 2013 from 8:30 AM to 4:30 PM (PDT)
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.
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
·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
OTHER COURSE INFORMATION:
Arizona SQL Saturday Main Event Page :http://www.sqlsaturday.com/193/eventhome.aspx%20
Food: Lunch will be provided.
Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $125 is due at the time of registration.
When & Where
Arizona SQL Server User Group
The Arizona SQL Server User Group is the first Microsoft SQL Server user group to serve the Phoenix, Arizona metropolitan area. Our group focuses on the business and technical aspects of deploying and administering Microsoft's premier database and business intelligence system. Guided and often presented by our membership, meeting content is designed to enlighten the audience and provide timely insight.
Meetings and membership are free to anyone interested in learning more about Microsoft SQL Server and related products and technologies.
We meet the 2nd Wed of every month at the Microsoft Offices in Tempe. Get plugged in by visiting arizona.sqlpass.org!