Section 1 : Introduction

lecture 1 Introduction 3:28

Section 2 : Excel as a BI Tool

lecture 2 Excel's Ubiquity And Strategic Importance 3:51
lecture 3 Excel Analytics Facilities 5:7

Section 3 : Data Management And Modeling Core Excel and the Excel Data M

lecture 4 Core Excel BI 3:30
lecture 5 DEMO Web Queries and the Data Connection Wizard 7:34
lecture 6 Office Data Connections
lecture 7 DEMO Managing Office Data Connections 2:13
lecture 8 Analysis Services Support 1:31
lecture 9 DEMO Querying an OLAP Cube 8:48
lecture 10 The Excel Data Model
lecture 11 The BI Semantic Model 6:42

Section 4 : Data Management and Modeling PowerPivot

lecture 12 Features Overview 6:26
lecture 13 Obtaining the Add-In, Data Import 4:47
lecture 14 DEMO Data Import and Setting Relationships 6:36
lecture 15 Advanced Modeling 6:48
lecture 16 DEMO Advanced Modeling, Querying In Excel 9:42

Section 5 : Data Discovery and Visualization Power View

lecture 17 Overview 5:1
lecture 18 Creating Reports 5:56
lecture 19 Demo Power View Basics 3:18
lecture 20 Maximize, Filters and Bubble Charts 1:14
lecture 21 DEMO Filters, Bubble Charts and the Play Axis.
lecture 22 Advanced Properties 1:56

Section 6 : Data Acquisition Data Explorer

lecture 23 Overview, Data Sources and Tie-Ins with Excel 7:57
lecture 24 Demo Importing Web and Facebook Data 4:16
lecture 25 Data Shaping, Data Manipulation and Integratin 2:36
lecture 26 Demo Importing, Shaping and Visualizing HDInsi
lecture 27 Data Formulas, Scripts and the 'M' langauge 1:45
lecture 28 Demo Working with Data Steps and Scripts 2:30

Section 7 : Mapping GeoFlow

lecture 29 Overview and First Steps 3:49
lecture 30 Demo Mapping the Hadoop Data
lecture 31 Chart Types, Controls and Visual Elements 3:34
lecture 32 Demo Bubble Charts, Heat Maps, Panning, Zoomin 4:38
lecture 33 Layers, Scenes and Tours 2:12
lecture 34 Demo Working with Layers, Building Scenes and 2:0

Section 8 : How SharePoint Ties In

lecture 35 Overview and Excel ServicesExcel Web App 3:11
lecture 36 Demo Excel Analytics in the Excel Web App on O 3:16
lecture 37 PowerPivot and Power View 3:45
lecture 38 PerformancePointReporting Services, Analysis S 4:21

Section 9 : Wrap-Up

lecture 39 Review and Wrap Up 4:30