Course Excel PowerPivot and PowerQuery
The Excel PowerPivot and PowerQuery course is intended for advanced MS Office users who need to process data from differ...
The Excel PowerPivot and PowerQuery course is intended for advanced MS Office users who need to process data from different sources, create reports from structured and relational databases, or make multiple and extensive data repositories and their outputs clearer and analyze them. Part of the course is not only working with these tools, but also their installation and setup.
Minimum input knowledge
Experience with MS Excel is assumed for this course. Experience at the level of completing the Excel 2 - Slightly Advanced course is recommended. Previous experience with pivot tables, working with objects (charts) and working with larger tables or databases is an advantage.
Course dates Excel PowerPivot and PowerQuery
Daily courses (2 days): 09:00 - 15:00
Evening courses (3 days): 16:30 - 19:00
Weekend courses (2 days): 09:00 - 15:00
Course price: 250.00 / 307.50 EUR
without VAT / incl. VAT
Training syllabus Excel PowerPivot and PowerQuery
INTRODUCTION
- Introduction to Business Intelligence and differentiation of the product group PowerQuery, PowerPivot, PowerMap, PowerView, Power BI Adding and installing add-ins into the Microsoft Excel environment
POWERPIVOT
- Familiarization with the editor for data modeling
Data Model
- Loading data into the Model Processing and editing database data import from different file types Linking tables and creating relationships
Output Alternatives to Microsoft Excel from the Data Model
- Measures and creating calculated fields Key performance indicators Hierarchy and groups Slicers
POWERQUERY
Basic Structure and Philosophy of the Tool
- Power Query versus Power Pivot
Working with the Power Query Editor
- Import and loading of different types of data files Editing and transforming data Queries Managing columns and reducing records in loaded databases Cleaning databases Transforming data and working with fields of type: Text, Number, Date Merging and appending queries Rules for working with the M language
Exporting Data to Microsoft Excel
- Loading data directly Loading data into the Data Model Creating connections
DAX LANGUAGE
- Language syntax Basic functions (SUM vs SUMX) CALCULATE RELATED and RELATEDTABLE DISTINCTCOUNT Practical use of additional DAX functions
Output knowledge
A course graduate can install the PowerPivot and PowerQuery add-ins. They can use these tools and use them to process data, create reports and analyze different data. The graduate also knows the best-known Business Intelligence add-ins.
Recommended courses after completing Excel PowerPivot and PowerQuery
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel PowerPivot and PowerQuery
Average rating