Create a Microsoft Excel BI Report and Share on Microsoft SharePoint 2013
In this lab, explore the many new business intelligence features of Excel and SharePoint 2013. You 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. You enhance the report by applying conditional formatting and adding a Timeline Slicer to filter data. You also use the new Quick Explore feature to add relevant visualizations to the workbook. You then publish the workbook to SharePoint and create a dashboard using components from the workbook. Using connected Web Parts and parameters, you provide user interactivity to the dashboard. You also leverage built-in features of Microsoft Excel Services 2013 like Fields List and Quick Analysis to manipulate the structure of the published report directly in the browser. "