PowerPivot for the data analyst : Microsoft Excel 2010

PowerPivot for the data analyst : Microsoft Excel 2010

ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft’s free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and make better decisions in less time! Simple, step-b...

Descripción completa

Detalles Bibliográficos
Otros Autores: Jelen, Bill Author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] Que 2010
Edición:1st edition
Colección:MrExcel library PowerPivot for the data analyst
Materias:
Microsoft Excel (Computer file)
Business intelligence > Computer programs
Business > Computer programs
Commerce
Marketing & Sales
Business & Economics
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629241506719
Tabla de Contenidos:
  • Downloading and installing PowerPivot
  • The promise of PowerPivot
  • Why wouldn't I build every future pivot table in PowerPivot?
  • Getting your data into PowerPivot
  • Creating and managing relationships
  • Using data sheet view
  • Building pivot tables
  • Cool tricks native to pivot tables
  • Cool tricks new with PowerPivot
  • Using DAX for aggregate functions
  • Using DAX for date magic
  • Named sets, GetPivotData, and cube formulas
  • Final formatting : making the report not look like Excel
  • Upgrading to PowerPivot server.

Ejemplares similares