4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Preparing a Power BI Workbook for Publication

This session describes how to prepare an Excel workbook for publication to a Power BI site to fully exploit supported Excel reporting capabilities, and those of Power View, Power Q&A and Power Map.
Topics will include defining an intuitive Power Pivot data model with friendly names, synonyms, comments and data formats; enabling images; defining "automatic" calculated fields (measures) to provide end-user flexibility to aggregate data; and how to appropriately configure the data model reporting properties. Numerous demonstrations will show the before-and-after effects in Power View and Power Q&A when applying configurations to the data model.
In addition, supported native Excel reporting capabilities that will function in Excel Online (via a web browser) will be described, together with an explanation of how to appropriately configure the Browser View Options.
This session is relevant for Power Pivot data model developers and information workers interacting with Power View reports.
Presented by Peter Myers at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO

    Peter Myers has been working with Microsoft database and development products since 1997. Today he specializes in Microsoft Business Intelligence and provides mentoring, technical training and course content authoring for Microsoft SQL Server and Microsoft Office. Specifically, he works with SQL Server Integration Services, SQL Server Analysis Services (data modeling and data mining), SQL Server Reporting Services, Microsoft Excel, PowerPivot and PerformancePoint Services.


    He has a broad business background supported by a Bachelor degree in applied economics, and he extends this with current MCITP and MCT certifications. He has been a SQL Server MVP since 2007.


    Peter is an established presenter and enjoys sharing his enthusiasm for Microsoft products by presenting in classrooms and at user group meetings, technical events and conferences.

  • Video
    The video is not available to view online.