Change Location × San Francisco

    Find Me

    • Use Current Location

    Recent Locations

      Power Pivot for Excel in San Francisco

      • Power Pivot for Excel Photo #1
      1 of 1
      June 22, 2013

      Saturday   8:30 AM - 12:00 PM

      201 Spear Street
      San Francisco, California 94105

      Map
      Performers:
      • No Performers Listed
      0 people track this event
      EVENT DETAILS
      Power Pivot for Excel

      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

      Categories: Conferences & Tradeshows | Sales & Retail

      Event details may change at any time, always check with the event organizer when planning to attend this event or purchase tickets.
      COMMENTS ABOUT Power Pivot for Excel