This two-day instructor-led course concentrates on PowerPivot and Power View in Excel 2013. The attendees will learn how to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
This course is intended for analysts, business intelligence (BI) developers and IT professionals that will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013 to be surfaced on SharePoint.
*Course Cost listed does not include the cost of courseware or lunch, required in your registration. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course is subject to minimum enrollment. Course may run as a live distance learning course if minimum is not met.
Work with the SharePoint Business Intelligence Center.
Create dedicated apps in SharePoint for PowerPivot and Power View.
Use PowerPivot within Excel to import a table from SQL Server.
Use PowerPivot within Excel to import a table from SQL Server Analysis Services
Hide columns they don’t want reflected in the resulting PivotTable.
View the relationships existing within the imported tables from SQL Server and then import an additional table and configure a relationship between it and the existing.