Introduces business analysts to the toolset and reporting capabilities that can be used to source and incorporate large datasets in analytics, including PowerPivot, SQL Server, and SharePoint, covering such topics as how to move data between these tools, how to leverage relational databases, and creating visualizations and dashboards.Select the appropriate table and field names from the drop-down lists to redefine the relationship. 4. Click OK ... Click the Close button in the Manage Relationships dialog box to get back to the Power Pivot model. In Figure ... You cannot use custom lists to automatically sort the data in your Power Pivotadriven PivotTables.
|Title||:||Microsoft Business Intelligence Tools for Excel Analysts|
|Author||:||Michael Alexander, Jared Decker, Bernard Wehbe|
|Publisher||:||John Wiley & Sons - 2014-05-05|