IN-STEP V.I.S.I.O.N. - Intelligent Data Analysis with Power Query and Power Pivot
2 days
HRD Corp claimable
Runs in-house for your team
Overview
This programme is for analysts, finance staff, managers, executives and administrators who handle large volumes of data in Excel. It teaches them to combine and clean data in Power Query and model it in Power Pivot.
Participants pull data from tables, workbooks and folders of files, fix blanks, data types and regional date formats, and append or merge tables. They then load the results into the Excel Data Model, relate tables to each other and write DAX measures with functions such as CALCULATE and TOTALYTD.
Participants leave able to build PivotTable reports and KPIs from several related tables, and to refresh them when the source data changes.
Module topics
- Power Query basics and data extraction
- Row and column transformations
- Appending and merging tables
- Loading and refreshing data
- Power Pivot and the Excel Data Model
- Table relationships and simple DAX
- DAX time intelligence and KPIs
- Refreshing reports from source data
Who runs this programme
At a glance
2 days
In-house at your premises or a venue you choose
HRD Corp claimable
Prefer to chat? WhatsApp us on 012-600 4488.
Ask about this programme
Tell us your team size and preferred dates. Our team will reply with the outline and a quotation.
More in this category
Microsoft Excel
2 days
Microsoft Excel
1 day
Microsoft Excel
1 day