MS55084-Excel 2013 Self-Service Analytics with No Code for the End User

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

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
• PowerPivot 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

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

Module 5: Power Query

• Power Query and Power Query Formulas
• ETL with Power Query
• Online Search
• Data Refresh
• 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?

Module 7: Summary Lab Exercises

• Summary  Scenario xx
• Summary  Scenario xx
• Summary  Scenario xx

Klientów indywidualnych prosimy o kontakt z Centrum Innowacji ProLearning, w celu uzyskania bieżącego harmonogramu szkolenia. Istnieje możliwość dostosowania się pod preferencje terminowe Klienta.