Description
Via PivotTable (PivotTable), the user can analyze numbers in an instant and efficiently. Excel can use the Power Query and Power Pivot tools to use external data as a basis for PivotTables, graphs,...
We'll start with a brief introduction to relational databases. Then we learn how to use Power Query to analyze external data in Excel. Finally, we learn how to create a Power Pivot model based on external data sources and dynamic Excel tables (tables) and how to use a Power Pivot model as a basis for Excel PivotTables.
Audience
This course is intended for people who want to process large amounts of external data into clear Excel reports.
Methods
Classroom training with attention to individual guidance and the ability to ask questions. Using exercises, the student can immediately put the possibilities of the program into practice.
Contents
- Introduction
- What is Power Pivot? What is Power Query?
- Excel database principles
- Excel database vs. relational database
- Power Query
- Connections to external data sources
- Transforming Data
- Combining Data Sources (Merge & Append)
- Using data
- Power Pivot
- Start Power Pivot
- Power Pivot screen exploration
- The 4 elements of a Power Pivot model (input, calculations, output, variables)
- CHICKEN
- Using the Data Model in Excel
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.