BI, Big Data, and Data Visualization

SQT15 An Overview of PowerPivot for Excel


4:15pm - 5:30pm

Level: Introductory to Intermediate

William Pearson

William E. Pearson III

Business Intelligence Architect and Founder

Island Technologies Inc.®

In this presentation, Microsoft BI Architect and SQL Server MVP Bill Pearson explores "self-service BI" as a concept. He then provides a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makers and analysts throughout our organizations. "There's no service like self-service" This session applies equally to SQL Server and Analysis Services 2008, 2008R2 and 2012 data sources.

You will learn:

  • An understanding of Self-Service BI, including the advantages and the challenges that accompany its introduction into the enterprise
  • Overview of the architecture and uses of PowerPivot for Excel 2010 within the organization to support self-service BI.
  • Explore and demonstrate the assembly of data from diverse sources into models that deliver business intelligence upon demand, including exposure to accessing and relating data, and to employing the Data Analysis Expressions (DAX) language, to construct PowerPivot applications that support analysis and reporting throughout the enterprise