Excel > Data > From Other Connections > From Analysis Services
How to connect to your Tabular Model database and use it as the underlying model for either Pivot Table, Pivot Chart, or Power View
Power Query for Power BI and Excel
What I love about "Power Query for Power BI and Excel" is that it is full of useful tips and tricks on Power Query and the chapters are written layer upon layer to build you from minimal (or no knowledge) to functional / practical knowledge on Power Query.
Notes: "I Want It Now" Data Visualisation with Power View
Follow up to "I Want It NOW!" Data Visualization With Power View - my 24 Hours of PASS Summit 2014 Preview Session