Microsoft PowerPivot Excel 2013 in Action

Download this episode

Download Video

Description

Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions. In this session, see how to create a business solution from scratch, loading tables inside PowerPivot, enriching them with new data, building complex formulas using the DAX language, leveraging the materialization of DAX queries in Excel and finally building dashboards and reports using the new PivotTable features and Power View. The goal of the session is to provide a clear understanding of the power of BI in Excel 2013 and raise your curiosity about the DAX language and the Tabular architecture.

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      dmwiz

      Still not sure this is going to be above my head.  I know nothing about the DAX language.

    • User profile image
      marco.russo

      You can watch the session the same, you will understand what are the capabilities of DAX in many scenarios, even if you will need some practice in order to understand many implementation details.

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.