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 analyze large amounts of data from multiple data sources.
Duration
1 day
Price
750.–
Course documents
Digital Digicomp coursware
Course facts
- Create sophisticated reports and data visualizations of mass data (more than 1 million rows) from a wide variety of sources using Power Query and Power Pivot
- Analysis of key performance indicators (KPIs) and preparation of management reports
- 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
- Visualize data in a targeted manner using pivot tables and charts
- 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 analyze and visualize large amounts of data using Microsoft Excel.
Participants of this course must have attended the following course or have equivalent knowledge: