Back to the main page
Duration: | 1 day |
Target group: | Users who want to efficiently process data from external sources in Excel |
Target: | Evaluation of large data sources from different sources |
Prior knowledge: | Good basic knowledge of Excel, experience with pivot tables |
Content: | Introduction to Power Pivot- Application possibilities, classification in Power BI
- Access to different data sources (Excel, text files, Access, etc.)
- Setting up relationships in PowerPivot
- Calculated columns and elements
- Calculations with Data Analysis Expression (DAX)
- Creating Measures
- Working with date tables / time intelligence
- Create and customize pivot tables and pivot charts
- Groupings through hierarchy formation
- Create KPI
|
Power Pivot is for your analyses of large data from different sources, where normal pivot tables reach their limits.