PowerPivot para usuarios finales (50433)

Duración: 14 horas.
¡Quiero saber más sobre el curso de PowerPivot para usuarios finales (50433)!

A quien va dirigido

Usuarios avanzados de Excel, usuarios que desean familiarizarse con PowerPivot para crear informes convincentes.

Descripción

Este curso de 2 días dirigido por un instructor le muestra cómo usar PowerPivot para obtener acceso a orígenes de datos, crear relaciones, usar las expresiones DAX de PowerPivot y generar y dar formato a informes. También explorará cómo se pueden integrar los libros de PowerPivot con SharePoint 2010.

A quien va dirigido

Usuarios avanzados de Excel, usuarios que desean familiarizarse con PowerPivot para crear informes convincentes.

Descripción

Este curso de 2 días dirigido por un instructor le muestra cómo usar PowerPivot para obtener acceso a orígenes de datos, crear relaciones, usar las expresiones DAX de PowerPivot y generar y dar formato a informes. También explorará cómo se pueden integrar los libros de PowerPivot con SharePoint 2010.

  • Explore todos los aspectos del uso de Microsoft PowerPivot
  • Habilidades generales de Excel y creación de informes

A simple introduction module.

  • None
  • None
  • Understand your course, classroom, classmates, facility and instructor.

In this module we take a look at an introductory view of PowerPivot.

  • Excel 2010 Features
  • PowerPivot Introduction
  • Install PowerPivot for Excel
  • Install PowerPivot for Excel
  • Be able to navigate the PowerPivot windows
  • Understand the new features of Excel 2010

In this module we take a look at all the possible data sources of which PowerPivot can work with!

  • Supported Data Sources
  • Load Data From SQL Server
  • Load Data From Text Files
  • Load Data via Copy and Paste
  • Load Data via Data Feeds
  • Load Data via Reporting Services
  • Cleaning data in PowerPivot
  • Create Relationship between Data Sources
  • Import various data sources into PowerPivot
  • Understand how to clean imported data

In this module we take a look at PowerPivot Functions/DAX Expressions and how to use them!

  • PowerPivot Expressions
  • Create a Time Table for future labs
  • Use DATE Function
  • Use DATEVALUE Function
  • Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
  • Use EDATE Function
  • Use EOMONTH Function
  • Use NOW and TODAY Functions
  • Use TIME and TIMEVALUE Functions
  • · Use WEEKDAY and WEEKNUM Functions
  • Use FIRST* and LAST* Functions
  • Use DATE* Functions
  • Use STARTOF* and ENDOF* Functions
  • Use CLOSING* and OPENING* Functions
  • Use LASTOF* and FIRST* Functions
  • Use PREVIOUS* and NEXT* Functions
  • Use AVERAGE* Functions
  • Use COUNT* Functions
  • Use MAX* and MIN* Functions
  • Use ALL, ALLEXCEPT and ALLNOBLANKROW
  • Use CALCULATE, CALCULATETABLE
  • Use DISTINCT and VALUES
  • Use EARLIER and EARLIEST
  • Use FILTER
  • Use RELATED
  • Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
  • Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
  • Use TEXT Functions
  • Be able to describe all the new PowerPivot Expressions
  • Use and apply many of the PowerPivot Expressions

In this module we take a look at building reports using PowerPivot.

  • PowerPivot Reports
  • Use PivotCharts
  • Use Slicers
  • Use Sparklines
  • Describe the different Report types in PowerPivot
  • Be able to create Slicers and Sparklines for more engaging reports

In this module we take a look at PowerPivot for SharePoint 2010.

  • Reports and Email
  • PowerPivot for SharePoint 2010
  • Install PowerPivot for SharePoint 2010
  • Configure PowerPivot for SharePoint
  • Publish to SharePoint 2010
  • Configure PowerPivot for SharePoint 2010
  • Describe the integration points between PowerPivot and SharePoint 2010
  • Be able to publish and setup workbook data refresh in SharePoint 2010