Learn how to import data from many sources e.g. CSV, Text, Access etc. and how to shape and transform the data as you import it. Learn how to easily add calculated fields to your data in PivotTables
Learn how to use Power Query, Power Pivot and DAX to transform and build powerful reports from your data.
Learn how to import raw data from
Excel - CSV - Text etc.
Learn how to create relationships between your data.
Learn how to add more calculated columns to your data
Learn how to how to use the new powerful formula language
Learn how to aggregate your data using Data Analysis Expressions (DAX)
Learn how to connect to your data sources and import.
Learn how to shape and transform your data ready for analysis
The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.