What’s the difference between these Power tools?
As Rob Collie says, Power Pivot is like the engine, so without it, you can’t get any analysis done.
Together with the data model and DAX, you can create the basis for your analysis.
Power Query is the fuel for your engine – it’s how you get the data in.
It’s also called “Get and Transform”.
It allows you to clean up and prepare your data for the engine.
This may involve a few different steps.
For example, you might need to add a new column to your data.
Or you might need to split some columns with a different logic or delimiter than the rest.
Power Query can easily handle it.
The best part is: It remembers the steps – similar to the macro-recorder in VBA. It reapplies them the moment new data comes in.
Once you’ve prepared the data for the engine, you can create your reports in Excel with the usual charts and tables, or send the data to Power BI.