Question: what is the difference between power pivot and power view?
Answer: PowerPivot is an add-in that lets end users gather, store, model, and analyze large amounts of data in Excel. Power View provides intuitive data visualization of PowerPivot models and SQL Server Analysis Services (SSAS) tabular mode databases. ... For example, there's the new Data Model, which I'll cover in-depth shortly.