As you've seen in the example presented by this article, Power Query makes it quick and relatively easy to get data into a good shape that can be loaded into Power Pivot to be modeled. Even though Power Query is quite a new tool, it already includes many
of the common transformations that are required to handle both structured and unstructured data. In addition to this, it can be used to quickly prototype ETL logic that can later be used to support SSIS package ETL design and build activities.
You can download the workbook from the
Note: This article was adapted from
this original blog post which also presents the completed Power Pivot Data Model and Power View data visualizations.