This event has ended

Power Pivot for Excel

Excel in Accounting

Saturday, June 22, 2013 from 8:30 AM to 12:00 PM (PDT)

San Francisco, CA

Power Pivot for Excel

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
IMA/AFWA member 24 Tickets Ended $40.00 $0.00
General 24 Tickets Ended $50.00 $0.00
Student 23 Tickets Ended $40.00 $0.00
Group 23 Tickets Ended $40.00 $0.00

Who's Going

Loading your connections...

Share Power Pivot for Excel

Event Details

Microsoft SQL Server PowerPivot for Excel is a new technology aimed at providing self-service Business Intelligence (BI). This tool, an Excel add-in, puts the power of expensive and complex business intelligence tools in the hands of strong Excel users, free of charge. PowerPivot is a powerful in-memory database that allows the user to join data from multiple sources, create relationships, and develop calculations in a way previously out of reach to non-technical users.

This class is intended to help you begin to cross the chasm between analyst/Excel user and business intelligence professional. Microsoft has also expanded into Big Data and this class will include a demo on using Big Data in a PowerPivot solution and a GeoFlow demo if time permits.

Presented by: Experienced Excel user and Business Intelligence Professional - Joe Dion

Session will cover:


  • Understanding the components of PowerPivot
  • Importing Data from multiple types of data sources
  • Understanding and creating relationships between the data sources
  • Introduction to DAX, the Data Analysis Expressions language that Excel users can easily understand
  • Adding calculated measures to the data
  • Demo on how to incorporate Big Data into PowerPivot
  • A demo of GeoFlow on a PowerPivot solution if time permits (this is a Geography based reporting solution released in Beta in April.)


This is a hands-on knowledge sharing session. Bring your own laptop to follow along.

***No computer is provided by the organizer. ***

Requirements

Have questions about Power Pivot for Excel? Contact Excel in Accounting

When & Where


Slalom Consulting
201 Spear Street
#1550
San Francisco, CA 94105

Saturday, June 22, 2013 from 8:30 AM to 12:00 PM (PDT)


  Add to my calendar

Organizer

Excel in Accounting

ExcelinAccounting is a community of finance and accounting professionals in and around San Francisco who want to learn and share advanced Excel spreadsheet techniques used specifically for finance and accounting. ExcelinAccounting began as a San Francisco Institute of Management Accountants program (SFIMA.org), and has grown into a community of its own.

  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.