I ended my last blog post with a brief description of Power Query. I described Power Query as a mini-tool for ETL (Extract Transform Load), which happens toward the beginning of the overall BI life cycle. Not only does this online course give an overview of the Power BI Tools, but it is structured in a way that mirrors the BI lifecycle—introducing each tool in the order in which you would use them. Naturally, building a data model in Power Pivot is the next step in our condensed journey through the BI life cycle. Power Pivot is an add-in for Excel that allows the user to import data from multiple sources (including Power Query) and build data models that can include calculated columns and measures that the user defines.