The Microsoft PowerPivot training course focuses on PowerPivot and Power View in Excel 2013. You will learn to surface the workbooks and visualizations using the Business Intelligence Center in SharePoint 2013.
By attending Microsoft PowerPivot workshop, delegates will learn to:
- Use PowerPivot within Excel to import a table from SQL Server
- Use PowerPivot within Excel to import large datasets
- Use PowerPivot within Excel to import with a query
- Create relationships between tables
- Create a cascading relationship
- Create a relationship between two tables from different sources
- Hide columns they don’t want reflected in the resulting PivotTable
- Change data types
- 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
- Create a PivotTable within an existing worksheet
- Add a calculated field to a table from the PivotTable
- Use the FILTER function
- Use the CALCULATE function
- Build a date table in excel
- Relate a table to the date table created in Excel
- Create and configure perspectives
- Create and configure hierarchies
- Create and configure KPIs
- Navigate and successfully use Power View
- Create a table
- Create a chart
- Save and share their work
- Explore the options and settings available within the new SharePoint 2013 Central Administration
- Access and review the Secure Store
- Create a new web application and business intelligence site while exploring the features of both
- Create custom apps to store visualizations and/or workbooks in SharePoint 2013 Business Intelligence Center
- Experience with Excel 2007 or higher
- An understanding of PivotTables
- A basic understanding of relational databases
The Microsoft PowerPivot class is intended for analysts, business intelligence (BI) developers and IT professionals who will be involved with the design, development, and maintenance of Excel workbooks utilizing PowerPivot and Power View 2013.