The fount end is more power view. Query is for getting the data, Power Pivot is for modeling the data (using DAX functional language for BI) and power view is for visualizing and telling stories with the data