Description
PowerPivot is the BI tool integrated into Excel 2013 allowing you to go beyond the limits of the spreadsheet and analyze large volumes of data (OLAP cubes, data warehouses, flat files and Excel tables). In this internship, you will learn how to extract data, manipulate it, and present it with PowerPivot.
Who is this training for ?
For whom ?
Any Excel user who needs to analyze and synthesize data.
Prerequisites
Good knowledge of Excel or equivalent to Excel Level 1 courses. Basic knowledge of relational DBMS.
Training objectives
Training program
- PowerPivot Overview
- - Benefits and features.
- - The different versions of PowerPivot and what's new in PowerPivot 2013.
- - Which data should I use with PowerPivot?
- - Comment restore the data in Excel in a synthetic form?
- Data restitution: Excel as interface
- - Create PivotTables and PivotCharts.
- - Define measures in TCDs: functions, ratio, deviations, progression.
- - Define levels of chronological grouping, define ranges of values.
- - Use segments to dynamically qualify data.
- - Use timelines to filter analyses.
- Working with heterogeneous data sources
- - Load PowerPivot tables from Excel.
- - Access relational databases: SQL Server, Access, ODBC etc.
- - Manage connections and updates .
- - Use the Diagram view.
- - Define relationships between tables.
- - Refer to another table.
- - An alternative to the Search function.
- - Arrange displays and create perspectives.
- Calculation in the cube
- - DAX functions, Excel functions and calculation in the TCD.
- - Sort and filter data.
- - Organize columns and eliminate unnecessary information.
- - Create calculated columns.
- - Convert and format data.
- - Prepare grouping levels.
- - Design calculated fields.
- - Carry out pre-calculated measurements.
- - Implement intelligent date management.
- Publication and Collaborative Work
- - Know the publishing and sharing solutions.
- - Example of Powerview reports.
- - SharePoint and/or Office 365.
