Course
digicode: MEPQPP
Power Query and Power Pivot for Data Analysis in Excel
During this Microsoft Excel course, you will learn how to use Power Query and Power Pivot to efficiently merge, process, and analyse large amounts of data from multiple data sources.
Duration
2 days
Price
1'300.–
Course documents
Digital digicomp courseware
Course facts
Download as PDF- Creating advanced analyses, reports, and visualizations using data from a wide variety of sources with the help of Power Query and Power Pivot
- Analyzing key performance indicators (KPIs) and preparing management reports
1 Power Query
- Importing data from various sources
- Preparing, cleaning, and transforming data
- Sorting and filtering data
- Combining and merging multiple queries
- Visualizing data effectively using PivotTables and PivotCharts
2 Power Pivot
- Importing data from various data sources
- Building a data model step by step
- Preparing data
- Creating relationships between multiple tables
- Calculating data using DAX functions
- Using hierarchies, date tables, and KPIs
This course is aimed at experienced users of PivotTables in Excel and at anyone who wants to analyse and visualise large amounts of data using Microsoft Excel.
Participants of this course must have attended the following course or have equivalent knowledge: