Excel BI with Power Query / PowerPivot

- 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