Course
Power Query and Power Pivot for data analysis in Excel («MEPQPP»)
During this one-day 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
1 day
Price
750.–
Course documents
Digital Digicomp coursware
Course facts
- Creating sophisticated reports and data visualisations of high-volume data (more than 1 million rows) from multiple sources using Power Query and Power Pivot
- Analysing key performance indicators (KPIs) and creating management reports
1 Power Query
- Import data from a wide variety of sources and storage locations
- Sort, filter and query data
- Clean or prepare data
- Display and combine queries
- Visualise data in a targeted manner using pivot tables and charts
2 Power Pivot
- Importing data from a variety of data sources
- Editing and formating Power Pivot tables
- Creating and applying relationships between Power Pivot tables
- Calculating with Power Pivot (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: