In this lab, explore the many new business intelligence features of Microsoft Excel and SharePoint 2013. Create and enhance parameterized Excel PivotTable based reports that consume data from PowerPivot, with a high level overview of the data model behind the PowerPivot data model. Enhance the report by applying conditional formatting and adding a Timeline Slicer to filter data. Use the new Quick Explore feature to add relevant visualizations to the workbook. Then, publish the workbook to SharePoint and create a dashboard using components from the workbook. Using connected Web Parts and parameters, provide user interactivity to the dashboard. Leverage built-in features of Excel Services 2013 like Fields List and Quick Analysis to manipulate the structure of the published report directly in the browser.
Click here to run this lab in a Virtual Machine.
Click here to view the lab manual
Code:
OFC-H305
Room:
Hall 7