The Smart Method Logo

Publishers of the world’s most comprehensive and up-to-date Excel tutorials

Category: Top OLAP Post

Search again:

Understand modern data analysis

Understand modern data analysis

This article describes a new way of working with Excel called “modern data analysis” enabled by the new Get & Transform and Power Pivot tools.

Understand Get & Transform and ETL

Understand Get & Transform and ETL

Get & Transform (or Power Query) is an advanced ETL tool. ETL is an acronym for Extract, Transform and Load. This article simply explains this amazing tool.