Курс 50433B: PowerPivot for End Users

Цена для физических лиц, р.: 7900
Цена для юридических лиц, р.: 8500

Продолжительность курса (дней): 2

Даты (день):

Даты (вечер):

Цель:

Необходимая подготовка:

Формат обучения, регистрация на курс: Explore every aspect of using Microsoft PowerPivot

План курса:

• Module 1: Overview
• Module 2: PowerPivot Introduction
• Module 3: PowerPivot Data Sources
• Module 4: PowerPivot Functions
• Module 5: Building Reports using PowerPivot
• Module 6: PowerPivot for SharePoint 2010

Module 1: Overview

Module 2: PowerPivot Introduction

• PowerPivot Introduction
• Lab : Installing PowerPivot
  • Install PowerPivot for Excel

Module 3: PowerPivot Data Sources

• Supported Data Sources
• Lab : Loading 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
• Lab : Cleaning Data
  • Cleaning data in PowerPivot
• Lab : Creating Relationships
  • Create Relationship between Data Sources

Module 4: PowerPivot Functions

• PowerPivot Expressions
• Lab : Create a Time Table
  • Create a Time Table for future labs
• Lab : Using DATE Functions
  • 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
• Lab : Using TIME INTELLIGENCE 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
• Lab : Using STATISTICAL Functions
  • Use AVERAGE* Functions
  • Use COUNT* Functions
  • Use MAX* and MIN* Functions
• Lab : Using VALUE Functions
  • Use ALL, ALLEXCEPT and ALLNOBLANKROW
  • Use CALCULATE, CALCULATETABLE
  • Use DISTINCT
  • Use EARLIER and EARLIEST
  • Use FILTER
  • Use REALTED, RELATEDTABLE
  • Use VALUES
• Lab : Using LOGICAL and INFORMATION Functions
  • Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
  • Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
• Lab : Using TEXT Functions
  • Use TEXT Functions

Module 5: Building Reports using PowerPivot

• PowerPivot Reports
• Lab : Creating Reports
  • Use PivotCharts
  • Use Slicers
  • Use Sparklines

Module 6: PowerPivot for SharePoint 2010

• Reports and Email
• PowerPivot for SharePoint 2010
• Lab : Installing PowerPivot for SharePoint 2010
  • Install PowerPivot for SharePoint 2010
  • Configure PowerPivot for SharePoint
• Lab : Configuring PowerPivot For SharePoint 2010
  • Publish to SharePoint 2010
  • Configure PowerPivot for SharePoint 2010