Create an Excel BI Report and Share on Microsoft SharePoint 2013
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