Курс M55084: Excel Self-Service Analytics with No Code for the End User

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

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

Даты (день):

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

Цель:

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

Формат обучения, регистрация на курс:

План курса:

• Module 1: Course Overview
• Module 2: Microsoft Business Intelligence Vision
• Module 3: Excel 2013 PowerPivot
• Module 4: Power View
• Module 5: Power Query
• Module 6: Power Map
• Module 7: Summary Lab Exercises

Module 1: Course Overview

• Introduction
• Course Materials
• Facilities
• Prerequisites
• What We'll Be Discussing

Module 2: Microsoft Business Intelligence Vision

• What is Business Intelligence?
• Enterprise Business Intelligence
• Team Business Intelligence
• Self-Service Business Intelligence
• Lab : Microsoft Business Intelligence Vision
  • Explore SharePoint 2013 Interface

Module 3: Excel 2013 PowerPivot

• Best Things That PowerPivot Brings to Excel
• What Will PowerPivot Do for the Analyst?
• Introduction to PivotTables (Optional)
• PowerPivot Versions
• New 2013 PowerPivot Features
• VLOOKUP Not Required (Use Relationships)
• Architectural Changes in Excel 2013
• PowrPivot and Excel 2013
• PowerPivot and SharePoint
• Enterprise Business Intelligence and PowerPivot
• Importing Data
• Data Models
• Relationships
• Simple PivotTable Reports
• Calculated Columns and Calculated Fields
• Refreshing Data
• Calculations
• SharePoint Sharing
• Lab : Excel 2013 PowerPivot
  • Pivot Tables (Optional)
  • PowerPivot User Interface
  • Importing Data
  • Importing Large Datasets
  • Importing Data with a Query
  • Creating Relationships
  • Creating a Cascading Relationship
  • Creating a Relationship Between Tables From Different Sources
  • Hiding Columns, Change Data Type, Sorting, and Filtering
  • Calculated Column and Calculated Field
  • Add a Calculated Field From the PivotTable
  • Filter Context Using One Table
  • Row Context and Dynamic Selection
  • FILTER Function
  • CALCULATE Function
  • Build a Date Table
  • Relate a Table to an Excel Calendar Table
  • Time Intelligence
  • Perspectives
  • Hierarchies
  • KPIs

Module 4: Power View

• Report Design Principles
• New 2013 Power View Features
• Microsoft Power View User Interface
• Tables
• Charts
• BI Semantic Models
• Saving and Sharing
• Lab : Power View
  • Power View

Module 5: Power Query

• Power Query and Power Query Formulas
• ETL with Power Query
• Online Search
• Data Refresh
• Managing Data Sources and Queries
• Lab : Power Query
  • Explore and Connect to Data Sources Using Power Query
  • ETL Using Power Query
  • Online Search
  • Managing Data Sources and Queries

Module 6: Power Map

• What is Power Map and How Does It Work?
• Data Visualizations and 3D Mapping Using Power Map
• What is a Tour?
• Lab : Power Map
  • Power Map Reports
  • Create a Tour

Module 7: Summary Lab Exercises

• Summary Scenario xx
• Summary Scenario xx
• Summary Scenario xx
• Lab : Summary Lab Solutions
  • Summary Scenario Solution xx
  • Summary Scenario Solution xx
  • Summary Scenario Solution xx