Excel BI with Power Query / PowerPivot
(0)
- Bechtle-Nr.: EDU128431
- Method: In-person seminar, Live online training
- Target group: Field sales representatives, Advanced users, Managers, Controlling employees, Marketing employees, Office users
- Duration: 2 day(s)
Please select:
€1,300.00
Gross price: €1,547.00 incl. €247.00 VAT
1
Course outline
Method
In-person seminar, Live online training
Duration
2 day(s)
Prerequisites:
Good understanding of Excel
Objective:
You'll learn how to import and present data from various sources. You are able to create and analyses complex and comprehensive data with PowerPivot.
Content:
- Power Query: Access and transform data: Acquire data online and from files, import data from databases and other sources, process queries, define relationships, calculations in queries
- PowerPivot: Import data from various sources, create relationships, create and edit hierarchies, an overview of pivotables and charts, PowerPivot calculations and features, working with date tables, KPIs, perspectives
Comment:
0