PowerPivot para usuarios finales (50433)
¡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
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